ORA-01555 on Active Data Guard Standby Database

ORA-01555 on Active Data Guard Standby Database [ID 1273808.1]
		修改時間 18-APR-2011     型別 PROBLEM     狀態 PUBLISHED

In this Document
  
  
  
  

---

Applies to:

Oracle Server - Enterprise Edition - Version: 11.2.0.2.0 and later   [Release: 11.2 and later ]
Information in this document applies to any platform.
Primary and Standby databases at 11.2.0.2

Symptoms

After upgrading to 11.2.0.2 we see this ORA-1555 on the Standby Database. It is not possible to logon with system, dbsnmp or other db-users. Only sys as sysdba is working.
It's like we are running on system's undo Tablespace, - and not the one which has been restored..

Cause

This is described in
: QUERY IN ACTIVE DATA GUARD RETURNS ORA-1555
which is duplicate from
: ACTIVE DATAGUAD INSTANCE HANGS DUE TO A LIBRARY CACHE LOCK HOLDER
This is resolved by applying the fix for
Internal :  DBMV2-BIGBH:SPIN IN KGLLOCK CAUSED DB HUNG AND HIGH LIBRARY CACHE LOCK

Solution

On Unix Platforms:

Apply this Patch 10018789 or request corresponding Patch if not available for your Platform. on Top of 11.2.0.2

On Windows Platform.:

Please apply 11.2.0.2.0 Patch 3 (11.2.0.2.3P)
32-Bit Patch:11731183
64-Bit (x64) Patch:11731184
For more info please check this note:
11.2.0.x Oracle Database and Networking Patches for Microsoft Platforms ()

References

- ACTIVE DATAGUAD INSTANCE HANGS DUE TO A LIBRARY CACHE LOCK HOLDER
- QUERY IN ACTIVE DATA GUARD RETURNS ORA-1555
- 11.2.0.x Oracle Database and Networking Patches for Microsoft Platforms