ORA-600 [17059] In a RAC Standby Database (Doc ID 818193.1)

Last updated on MARCH 18, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 to 11.1.0.7 [Release 10.2 to 11.1]
Information in this document applies to any platform.

Symptoms

In a RAC standby database configuration, where the instances are just mounted but the database is not opened, parallel SQL execution processes generate a lot of ORA-600 [17059] errors. The trace files show queries against GV$ views (such as GV$INSTANCE).

The following query doesn't return any rows:

connect / as sysdba

select do.obj#,
po.obj# ,
p_timestamp,
po.stime ,
decode(sign(po.stime-p_timestamp),0,'SAME','*DIFFER*') X
from sys.obj$ do, sys.dependency$ d, sys.obj$ po
where P_OBJ#=po.obj#(+)
and D_OBJ#=do.obj#
and do.status=1 /*dependent is valid*/
and po.status=1 /*parent is valid*/
and po.stime!=p_timestamp /*parent timestamp not match*/
order by 2,1 ;


As such there does not seem to be any problem with the data dictionary contents.

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