Skip to Main Content

GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Golden Gate ERROR OGG-02028 Failed to attach to logmining server Error code 3113, error message:

User_2HXT6Feb 3 2017 — edited Feb 4 2017

Hi,

I am trying to start up the golden gate extract group and am getting the following error:

ERROR   OGG-02028  Failed to attach to logmining server Error code 3113, error message: ORA-03113: end-of-file on communication channel

The following are the contents from my alert log:

------------------------------------------------------------------------------------------------------------------------------------------

Fri Feb 03 16:38:40 2017

Thread 1 advanced to log sequence 3877 (LGWR switch)

  Current log# 1 seq# 3877 mem# 0: /data02/oradata/FACSESMOC01/onlinelog/o1_mf_1_cr7m318b_.log

Archived Log entry 392 added for thread 1 sequence 3876 ID 0x4cb65d61 dest 1:

Fri Feb 03 16:38:40 2017

Logminer Bld: Build started

ALTER SYSTEM SWITCH ALL LOGFILE start (facses01)

Thread 1 advanced to log sequence 3878 (LGWR switch)

  Current log# 2 seq# 3878 mem# 0: /data02/oradata/FACSESMOC01/onlinelog/o1_mf_2_cr7m31bg_.log

ALTER SYSTEM SWITCH ALL LOGFILE complete (facses01)

Fri Feb 03 16:38:40 2017

Logminer Bld: Lockdown Complete.  DB_TXN_SCN is 0 16956239 LockdownSCN is 16956239

Fri Feb 03 16:38:40 2017

Archived Log entry 393 added for thread 1 sequence 3877 ID 0x4cb65d61 dest 1:

ALTER SYSTEM ARCHIVE LOG

Thread 1 cannot allocate new log, sequence 3879

Checkpoint not complete

  Current log# 2 seq# 3878 mem# 0: /data02/oradata/FACSESMOC01/onlinelog/o1_mf_2_cr7m31bg_.log

Thread 1 advanced to log sequence 3879 (LGWR switch)

  Current log# 3 seq# 3879 mem# 0: /data02/oradata/FACSESMOC01/onlinelog/o1_mf_3_cr7m31d6_.log

Archived Log entry 394 added for thread 1 sequence 3878 ID 0x4cb65d61 dest 1:

Fri Feb 03 16:38:44 2017

Logminer Bld: Done

GoldenGate Capture: OGG$CAP_EXT1 CAPTURE Created

CAPTURE OGG$CAP_EXT1: Start SCN: 16956239 (0x102bb4f.00000000)

CAPTURE OGG$CAP_EXT1: First SCN: 16956239 (0x102bb4f.00000000)

CAPTURE OGG$CAP_EXT1: Required Checkpoint SCN: 0 (0x0000.00000000)

CAPTURE OGG$CAP_EXT1: Captured SCN: 0 (0x0000.00000000)

CAPTURE OGG$CAP_EXT1: Applied SCN: 0 (0x0000.00000000)

CAPTURE OGG$CAP_EXT1: Capture Type: LOCAL

CAPTURE OGG$CAP_EXT1: Logminer Id: 6

CAPTURE OGG$CAP_EXT1: Source Database: FACSES01

GoldenGate Apply: OGG$EXT1 APPLY Created

APPLY OGG$EXT1: Apply User: GG_ADMIN

APPLY OGG$EXT1: Apply Tag: 00

Setting XOUT_CLIENT_EXISTS to Y for Capture: OGG$CAP_EXT1

Fri Feb 03 16:38:46 2017

GoldenGate CAPTURE CP01 for OGG$CAP_EXT1 started with pid=69, OS id=8781

CAPTURE OGG$CAP_EXT1: Start SCN: 16956239 (0x102bb4f.00000000)

CAPTURE OGG$CAP_EXT1: First SCN: 16956239 (0x102bb4f.00000000)

CAPTURE OGG$CAP_EXT1: Required Checkpoint SCN: 0 (0x0000.00000000)

CAPTURE OGG$CAP_EXT1: Captured SCN: 0 (0x0000.00000000)

CAPTURE OGG$CAP_EXT1: Applied SCN: 0 (0x0000.00000000)

CAPTURE OGG$CAP_EXT1: Capture Type: LOCAL

CAPTURE OGG$CAP_EXT1: Logminer Id: 6

CAPTURE OGG$CAP_EXT1: Source Database: FACSES01

First applied SCN of the GoldenGate path from capture (OGG$CAP_EXT1) to propagation () to apply (OGG$EXT1) is set to SCN: 16956239 (0x102bb4f.00000000)

GoldenGate CAPTURE CP01 for OGG$CAP_EXT1 with pid=69, OS id=8781 is in combined capture and apply mode.

Capture OGG$CAP_EXT1 is handling 1 applies.

  -- capture is running in apply-state checkpoint mode.

Starting persistent Logminer Session with sid = 6 for GoldenGate Capture OGG$CAP_EXT1

LOGMINER: Parameters summary for session# = 6

LOGMINER: Number of processes = 0, Transaction Chunk Size = 1

LOGMINER: Memory Size = 60M, Checkpoint interval = 1000M

LOGMINER: SpillScn 0, ResetLogScn 1

LOGMINER: summary for session# = 6

LOGMINER: StartScn: 16957075 (0x0000.0102be93)

LOGMINER: EndScn: 0

LOGMINER: HighConsumedScn: 16956239 (0x0000.0102bb4f)

LOGMINER: session_flag: 0xb0

LOGMINER: DDL CKPT is on.

LOGMINER: Read buffers: 64

LOGMINER: Memory LWM: limit 10M, LWM 50M, 83%

LOGMINER: Memory Release Limit: 1M

LOGMINER: LowCkptScn: 0 (0x0000.00000000)

LOGMINER: HighCkptScn: 0 (0x0000.00000000)

LOGMINER: SkipScn: 16956239 (0x0000.0102bb4f)

Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x0] [PC:0x97F111A, lnxsni()+1874] [flags: 0x0, count: 1]

Errors in file /data01/app/oracle/diag/rdbms/facses01/facses01/trace/facses01_cp01_8781.trc  (incident=72565):

ORA-07445: exception encountered: core dump [lnxsni()+1874] [SIGSEGV] [ADDR:0x0] [PC:0x97F111A] [Address not mapped to object] []

ORA-01280: Fatal LogMiner error.

Use ADRCI or Support Workbench to package the incident.

See Note 411.1 at My Oracle Support for error and packaging details.

Fri Feb 03 16:38:53 2017

Sweep [inc][72565]: completed

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Any idea as to why this error is occurring?

This post has been answered by User_2HXT6 on Feb 4 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 4 2017
Added on Feb 3 2017
5 comments
3,899 views