March 11, 2014 Leave a comment
We were seeing the following two ORA 600s after applying PSU7. Technically the issue wasnt related to PSU 7 but more the switchover involved when patching…
SR 3-8646935731 : ORA 600 [ktbdchk1: bad dscn]
SR 3-8664869401 : ORA 600-[FILE:jsks.c LINE:2388 FUNCTION:jsksStartOCICall() ID:OCIKCallPus]
Caused by Bug 8895202 : ITL HAS HIGHER COMMIT SCN THAN BLOCK SCN
The solution was to set the following dynamic parameter on both the primary and standby database:
ALTER SYSTEM SET "_ktb_debug_flags"=8 SCOPE=BOTH;
This parameter is designed to heal blocks having invalid dependent scn’s on switchover operations.
From the traces provided to oracle, I was told that the affected object for this issue was ID 12152331.
Running the following SQL determines the object:
select owner,object_name,object_type,subobject_name,object_id,data_object_id from dba_objects where object_id in (12152331) or data_object_id in (12152331);
The affected blocks were on index SYS.I_SCHEDULER_JOB_RUN_DETAILS on table SCHEDULER$_JOB_RUN_DETAILS.
As well as the dynamic parameter, I also did the following:
ANALYZE TABLE SCHEDULER$_JOB_RUN_DETAILS VALIDATE STRUCTURE online; ALTER INDEX SYS.I_SCHEDULER_JOB_RUN_DETAILS REBUILD online;