Monday, December 19, 2011

ORA-00600: internal error code, arguments: [kcratr_scan_lastbwr]

Launch SQL Plus from Oracle\bin folder ( not from Client folder)

SQL> conn sys/sys as sysdba
Connected to an idle instance.


SQL> startup mount;
ORACLE instance started.

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kcratr_scan_lastbwr], [], [], [],
[], [], [], [], [], [], [], []


SQL> shutdown immediate;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.

SQL> startup mount;
ORACLE instance started.
Database mounted.

SQL> recover database;
Media recovery complete.

SQL> alter database open;
Database altered.

SQL> conn scott/tiger@orcldb
Connected.

Your database is good to go now, You better take a backup of your system.

17 comments:

  1. Thank you. It saved me a lot of time.

    ReplyDelete
  2. great advice. Thanks.

    ReplyDelete
  3. Thank you so much !

    ReplyDelete
  4. thanks alot, dont understand why caused this issue though !

    ReplyDelete
  5. Thanks a lot also from me - it worked
    Any idea, why this happens?

    ReplyDelete
  6. Works perfect. Thank you so much!

    ReplyDelete
  7. Thank you very much :)

    ReplyDelete
  8. Man you saved my Job !!!

    ReplyDelete
  9. Thank you very much - worked perfectly. My development machine had this issue today and I already feared I'd have to reinstall Oracle... your post saved me a lot of time! Thanks.

    ReplyDelete
  10. A lot of thanks, really

    ReplyDelete