OGG Integrated Replicat Hangs and Apply Server shows library cache pin / library cache lock (Doc ID 2237568.1)

Last updated on MAY 22, 2023

Applies to:

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@<server>.<domain> (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@<server>.<domain> (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@<server>.<domain> (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'

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.