DOYENSYS Knowledge Portal

We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal

Saturday, January 14, 2017

ERROR: - "ORA-01092: ORACLE instance terminated. Disconnection forced".


Once database open after within few seconds we got the

ERROR: - "ORA-01092: ORACLE instance terminated. Disconnection forced"

Alert log file shows lot of trace file and majorly shows

TRACE file:-

ORA-00600: internal error code, arguments: [kdoirp-1], [2], [], [], [], [], [], []


To shrinking table data  & Rebuild the indexes related to that table at same time and unexpectedly database bounced by some client dba.


Start the database and immediately run the segments status.

 SQL> Select    segment_name,   status from dba_rollback_segs where status='NEEDS RECOVERY';

SEGMENT_NAME                   STATUS
------------------------            ----------------
_SYSSMU41$                     NEEDS RECOVERY
_SYSSMU100$                    NEEDS RECOVERY

So some segments need to recovery, then offline the those segments into parameter level and start the database

Keep the below parameter into pfile


And start the database using pfile. Then database successfully started and stable.

Then create spfile from pfile& shutdown database and startup.

No comments: