Tag Archives: Undo Corruption

PMON: terminating instance due to error 472

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

PMON (ospid: 8143): terminating the instance due to error 472

We identified that the error was in undo corruption and followed the below steps to over come above mention error.

Steps to change undo tablespace as followed:

Step 1: Check the Undo Parameters

SQL> SELECT name,value FROM v$parameter WHERE name IN ('undo_management','undo_tablespace');

NAME VALUE
-------------------------
undo_management MANUAL
undo_tablespace UNDO_TBS

Step 2: Check the Undo Tablespace file information.

SQL> select FILE_NAME, TABLESPACE_NAME from dba_data_files where TABLESPACE_NAME like 'UNDO%';

FILE_NAME TABLESPACE_NAME
-------------------------- ---------------
/oracle/data/undotbs_02.dbf UNDO_TBS
/oracle/data/undotbs_01.dbf UNDO_TBS

Step 3: Create a new undo tablespace

SQL> create UNDO tablespace UNDOTBS datafile '/ebiz/oracle/db/apps_st/data/undotbs01.dbf' size 1024m REUSE AUTOEXTEND ON NEXT 4096K MAXSIZE 1024M;
Tablespace created.

Step 4: Set the undo tablespace to new one created in previous step.

SQL> ALTER SYSTEM SET undo_tablespace = 'UNDOTBS' scope=spfile;
System altered.

Step 5: Set old undo tablespace offline mode and then drop it.

SQL> ALTER TABLESPACE UNDO_TBS offline;
Tablespace altered.

SQL> drop tablespace UNDO_TBS including contents and datafiles;
Tablespace dropped.

Step 6: Restart the db services
 
Step 7: Changed the undo management parameter to AUTO

SQL> alter system set undo_management='AUTO' scope=spfile;
System altered.

SQL> SELECT name,value FROM v$parameter WHERE name IN ('undo_management','undo_tablespace');

NAME VALUE
--------------------
undo_management AUTO
undo_tablespace UNDOTBS