Oracle active standby ORA-01555

52 total views, 1 views today

公司的一台Oracle备库ADG(11.2.0.4)alert.log中出现大量ORA-01555错误。

查看系统视图都会出现ORA-01555

在网上找到了这篇mos。这个bug 影响版本是11.2.0.2到12.1(不含)。不过这个bug在11.2.0.4没有修复。只能升级解决。

 

问题发生原因:
当获取一个 library cache lock时导致更广泛的hang情况,其他会话需要等待这个锁,因此产生了自身hang(self-hang)或者spin。

 

问题重现:

A process spins in kglLock(),

other processes waiting for the spinning session

ORA-1555 on Active data Guard

 

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

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
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:

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

Please note: The above is a summary description only. Actual symptoms can vary. Matching to any symptoms here does not confirm that you are encountering this problem. For questions about this bug please consult Oracle Support.

References

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

发表评论

必填项已用*标注