Email: service@parnassusdata.com 7 x 24 online support!

CANNOT OPEN DATABASE WITH ORA-00600 [KOKIASG1].

CANNOT OPEN DATABASE WITH ORA-00600 [KOKIASG1].

PROBLEM:
--------
Database crashed and cannot be restarted open due to ORA-600 [kokiasg1]. 
There were missing internal sequences in AUDSEQ$.
 
DIAGNOSTIC ANALYSIS:
--------------------
Problem Background
===================
6-node RAC
 
- Database went down (aborted) 
Fri Nov 12 22:20:12 2010
Shutting down instance (abort)
 
- Database was did not restart due to ora0600 
Alert.log
----------
Validated domain 0, flags = 0x0
tkcrrsarc: (WARN) Failed to find ARCH for message (message:0x1)
tkcrrpa: (WARN) Failed initial attempt to send ARCH message (message:0x1)
*** 22:41:50.054
ksedmp: internal or fatal error
ORA-600: internal error code, arguments: [kokiasg1], [], [], [], [], [], 
[], []
Current SQL statement for this session:
ALTER DATABASE OPEN
 
- There were missing internal data dictionary sequences related to AUDSEQ$. 
 
 
- Customer recreated sequence in primary db based on sequence numbers from 
standby and open database.
 
- Because of this, state of database health is in question. Customer was told 
database maybe not supported. Customer was adviced to:
 
1) Perform cold backup and (exp/imp) database and recreate database
 
2. Failover to the standby database.
 
- Customer was adviced CLEARLY adviced that internal sequences belong to 
different components of the database and recreation of these sequences is not 
feasible as it may cause duplicate sequence numbers to be generated and may 
cause the components to break.
 
 
Base on what was done, here the some question from JPMorgan Chase:
 
1. Is there any Oracle tool or script to check internal health of the 
database based on what was done?
 
2. Can Oracle development validate supportability of the database