Menu

Dipesh Majumdar

Blog and Paintings

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

July 5, 2012


The Problem:

Oracle Database remains in mounted state. It can't be opened. If it is focibly opened it throws error (ora-00600) as shown below:
 
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kcratr_scan_lastbwr], [], [], [],
[], [], [], [], [], [], [], []

SOLUTION: 

Use the command- 'recover database' as shown below:

SQL> shutdown immediate
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.

Total System Global Area  534462464 bytes
Fixed Size                  2215064 bytes
Variable Size             322962280 bytes
Database Buffers          201326592 bytes
Redo Buffers                7958528 bytes
Database mounted.
SQL> recover database;
Media recovery complete.

SQL> alter database open;

Database altered.

Go Back

still same issue

Warning: oci_connect(): ORA-01033: ORACLE initialization or shutdown in progress in C:\websites\ir\db.php on line 11

solved my error..thnx sir

Thanks a lot; able to resolve using the solution provided.

Thanks again.

This post helped me to recover my DB with more than 15 days work..Thank you very much

It worked for and saved lot of time. Thank you so much and appreciate your help.

thanks a lot for solution

The solution provided above worked for me.. saved a lot of my time and effort.. thanks a ton!

thanks a lot that solution is right on the block for me

Thank you very much, after unsuccesful trial for hrs with others solution, at the end its solve my issue immedately!

Esta soluciĆ³n, me salvo la vida. Grande Master

saludos y Gracias por tu ayuda.



Comment