Oracle active dataguard ORA-01555

 

Bug 10018789  Spin in kgllock / DB hang with high library cache lock waits on ADG

 This note gives a brief overview of bug 10018789.
 The content was last updated on: 03-SEP-2013
 Click here for details of each of the sections below.

Affects:

Product (Component)	Oracle Server (Rdbms)
Range of versions believed to be affected	Versions >= 11.2.0.2 but BELOW 12.1
Versions confirmed as being affected	11.2.0.2 11.2.0.1
Platforms affected	Generic (all / most platforms affected)

 It is believed to be a regression in default behaviour thus:
   Regression introduced in 11.2.0.2

Fixed:

This issue is fixed in	12.1.0.1 (Base Release) 11.2.0.3 (Server Patch Set) 11.2.0.2.2 Database Patch Set Update 11.2.0.2 Bundle Patch 1 for Exadata Database 11.2.0.1 Bundle Patch 7 for Exadata Database 11.2.0.2 Patch 25 on Windows Platforms 11.2.0.2 Patch 3 on Windows Platforms
Symptoms:			Related To:
Hang (Process Spins) ORA-1555 Waits for "library cache lock"			Active Dataguard (ADG)

Description

This problem is introduced in 11.2.0.2 by the fix for bug 9214531

 

A self-hang / spin can occur when getting a library cache lock

leading to a wider hang scenario with other sessions waiting

for the blocked lock.

 

Rediscovery Notes:

  A process spins in kglLock(),

  other processes waiting for the spinning session

  ORA-1555 on Active data Guard

 

HOOKS ERROR:ORA-1555 SPIN:kglLock "WAITEVENT:library cache lock" CAUSE:9214531 SUPERCEDES:9214531 LIKELYAFFECTS XAFFECTS_11.2.0.2 XAFFECTS_V11020002 AFFECTS=11.2.0.2 XPRODID_5 PRODUCT_ID=5 PRODID-5 RDBMS XCOMP_RDBMS COMPONENT=RDBMS TAG_ADG TAG_HANG/SPIN TAG_RB202 TAG_REGRESSION ADG HANG/SPIN RB202 REGRESSION FIXED_11.2.0.1.BP07 FIXED_11.2.0.2.2 FIXED_11.2.0.2.BP01 FIXED_11.2.0.3 FIXED_12.1.0.1 FIXED_WIN:B202P03 FIXED_WIN:B202P25

References

(This link will only work for PUBLISHED bugs)
Note:245840.1 Information on the sections in this article