CANNOT OPEN DATABASE WITH ORA-00600 [KOKIASG1].

Posted by PDSERVICE on Jan 16, 2016 In

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

You are here