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

Steps for ORA-00600: internal error code, arguments: [kccpb_sanity_check_2] (CONTROLFILE):

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

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

SQL> shutdown immediate

ORA-01507: database not mounted

ORACLE instance shut down.

SQL> startup nomount

ORACLE instance started.

Total System Global Area 612368384 bytes

Fixed Size 1304728 bytes

Variable Size 188745576 bytes

Database Buffers 415236096 bytes

Redo Buffers 7081984 bytes

2. change the control file settings

SQL> alter system set control_files=’E:\APP\PRAVEEN\ORADATA\ORACLE\CONTROL01.CTL’ scope=spfile

3. Restart the database

SQL> shutdown immediate;

ORA-01507: database not mounted

ORACLE instance shut down.

SQL> startup

ORACLE instance started.

Total System Global Area 612368384 bytes

Fixed Size 1304728 bytes

Variable Size 188745576 bytes

Database Buffers 415236096 bytes

Redo Buffers 7081984 bytes

Database mounted.

ORA-01113: file 4 needs media recovery if it was restored from backup, or END

BACKUP if it was not

ORA-01110: data file 4:

‘E:\APP\PRAVEEN\ORADATA\ORACLE\EXAMPLE01.DBF’

Database did not opened. Above error message displayed.

4. Now recover the database

SQL> recover database;

Media recovery complete.

Then control file settings should change again as in step 2 using CONTROL02.CTL’ and do the 3 and 4 steps as above.

Database recovery complete. Now restart the database, database will start in open mode.