Saturday, June 14, 2014

ORA-00600: internal error code Oracle Database Crashed

ERROR: ====== Errors in file c:\oracle\click11g\diag\rdbms\click11g\click11g\trace\click11g_ora_1992.trc (incident=51767): ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1], [107], [57549], [57552], [], [], [], [], [], [], [] Incident details in: c:\oracle\click11g\diag\rdbms\click11g\click11g\incident\incdir_51767\click11g_ora_1992_i51767.trc Aborting crash recovery due to error 600 Errors in file c:\oracle\click11g\diag\rdbms\click11g\click11g\trace\click11g_ora_1992.trc: ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1], [107], [57549], [57552], [], [], [], [], [], [], [] Errors in file c:\oracle\click11g\diag\rdbms\click11g\click11g\trace\click11g_ora_1992.trc: ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1], [107], [57549], [57552], [], [], [], [], [], [], [] ORA-600 signalled during: ALTER DATABASE OPEN... Trace dumping is performing id=[cdmp_20100621003740] SOLUTION: ========= *>connect sys as sysdba* *> startup mount* *> alter database recover until cancel using backup controlfile; (i have ignored promtings).* *> alter database recover continue default; (until it says “no such file or directory” or there are no more suggestions.)* *> alter database recover cancel;* *> alter database open resetlogs;*

2 comments: