Email: service@parnassusdata.com 7 x 24 online support!
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