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".


Problem:- 

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:-

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


Cause:-

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


Solution:-

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

*._offline_rollback_segments=_SYSSMU41$
*._offline_rollback_segments=_SYSSMU100$

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

Then create spfile from pfile& shutdown database and startup.



No comments: