Saturday, 7 November 2015

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

Problem :  While trying to start the database after rollback from 11.2.0.4 to 11.2.0.3, I found so many ORA-600 errors in the alert log and instance was restarting  automatically.
I was not able to shutdown cleanly it was giving "ORA-03113: end-of-file on communication channel"


SQL> shutdown immediate ;
ORA-03113: end-of-file on communication channel
SQL>


In alert log -->
ORA-01595: error freeing extent (44) of rollback segment (1))
ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], [], [], [], [], []


Incident 432371 created, dump file: /bobshr/dump01/diag/rdbms/inst_a/inst_a1/incident/incdir_432371/insta1_smon_78761_i432371.trc
ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], [], [], [], [], []
Error 600 in redo application callback


Error 600 in redo application callback  --  indicates Problem is with undo tablespace.  


I tried creating undo tablespace but that also errored out


SQL> CREATE undo tablespace APPS_UNDOTBS02 datafile '+INST_AIDB_VG/inst_a1/datafile/undots1_002.dbf' SIZE 5G
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [4194], [ody "SYS.DBMS_STANDARD"


Also Not able to compile package SYS.DBMS_STANDARD


SQL> alter package dbms_standard compile ;
alter package dbms_standard compile
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [4194], [ody "SYS.DBMS_STANDARD"


Solution :


1) Shutdown immediate;


2) edit init files to change below values


*.undo_management='MANUAL'
inst_a1.undo_tablespace='APPS_UNDOTBS01'  <-- the name of new undo tablespace


3) startup pfile=init<sid>.ora




4)  Create a new undo tablespace
CREATE undo tablespace APPS_UNDOTBS01 datafile '+INST_A1DB_VG/inst_a1/datafile/undots1_001.dbf' SIZE 5G;




5) Set the current undo tablespace to newly created one and drop the old one.
ALTER SYSTEM SET inst_a1.undo_tablespace='APPS_UNDOTBS01' ;
DROP TABLESPACE APPS_UNDOTS1 INCLUDING CONTENTS AND DATAFILES;


6) shutdown and restart the database ;


This fixed the issue and no "ORA-00600: internal error code, arguments: [4194]"  any further.



No comments:

Post a Comment