OGG Integrated Replicat Hangs and Apply Server shows library cache pin / library cache lock

(Doc ID 2237568.1)

Last updated on JANUARY 31, 2018

Applies to:

Oracle GoldenGate - Version 12.1.2.1.0 and later
Information in this document applies to any platform.

Symptoms

IR hangs with time since checkpoint not decreasing

REPLICAT INTREP Last Started 2016-07-02 07:12 Status RUNNING
INTEGRATED
Checkpoint Lag 00:00:00 (updated 01:04:13 ago) <===
Process ID 198379
Log Read Checkpoint File /opt/ggate/dirdat/rt000298
2016-07-01 23:07:42.970472 RBA 2280124

Apply trace shows following

LibraryHandle: Address=0x5ff72c348 Hash=92d5f3eb LockMode=X PinMode=S
LoadLockMode=0 Status=INVL
ObjectName: Name=SYS.STREAMS$_APPLY_PROGRESS Streams

PROCESS 316: AS11

LibraryObjectPin: Address=0xb686e778 Handle=0x5ff72c348 Mode=S
User=0x2a98efeb8 Session=0x2a98efeb8 Count=1 Mask=0003 Flags=[00]
SavepointNum=0x16c3

process id: 314, oracle@clprxdb9206d.chicago.cme.com (AS0R)
is waiting for 'library cache lock' with wait info:
p2: 'lock address'=0x5f7eaffc8
2. event: 'library cache lock'
time waited: 15 min 0 sec (total)
and is blocked by
process id: 309, oracle@clprxdb9206d.chicago.cme.com (AS0O)
which is waiting for 'library cache pin' with wait info:
blocking: 7 sessions
p2: 'lock address'=0x5fadd3690
and is blocked by
process id: 316, oracle@clprxdb9206d.chicago.cme.com (AS11)
which is waiting for 'rdbms ipc message' with wait info:
blocking: 8 sessions
Chain 1 Signature: 'rdbms ipc message'<='library cache pin'<='library cache
lock'

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms