Wednesday, June 19, 2024

ORA-00600: INTERNAL ERROR CODE, ARGUMENTS: [KCRATR_SCAN_LASTBWR] ON 11.2.0.4

ORA-00600: INTERNAL ERROR CODE, ARGUMENTS: [KCRATR_SCAN_LASTBWR] ON 11.2.0.4

 

[oracle@TEST ~]$ export ORACLE_SID=TESTDB

 

[oracle@TEST ~]$ sqlplus

 

 

Copyright (c) 1982, 2013, Oracle. All rights reserved.

 

Enter user-name: /as sysdba

 

Connected to an idle instance.

 

SQL> startup

 

ORACLE instance started.

 

Total System Global Area 1486495744 bytes

 

Fixed Size 2850712 bytes

 

Variable Size 553648232 bytes

 

Database Buffers 922746880 bytes

 

Redo Buffers 7249920 bytes

 

Database mounted.

 

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

 

[], [], [], [], [], [], [], []

 

 

 

 

SOLUTION :

 

 

 

 

If you encounter this error, try to recover the database explicitly and see if it opens:

 

 

 

 

SQL> startup mount

 SQL> recover database;

 SQL> alter database open;

 

SQL> select name, open_mode from v$database;

 

NAME OPEN_MODE

 

--------- --------------------

 

TESTDB MOUNTED

 

SQL> alter database recover;

 

Database altered.

 

SQL> alter database open;

 

Database altered.