#757

[Oracle] PMON (ospid: 4501): terminating the instance due to error 472

Step 1:

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

NAME VALUE
——————– ——————–
undo_management MANUAL
undo_tablespace UNDO_TBS

Step2:

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

FILE_NAME TABLESPACE_NAME
—————————————————————-
/path/to/tablespace/undotbs_02.dbf UNDO_TBS
/path/to/tablespace/undotbs_01.dbf UNDO_TBS

Step 3: Create a new undo tablespace

create UNDO tablespace UNDOTBS datafile '/path/to/tablespace/undotbs01.dbf' size 1024m REUSE AUTOEXTEND ON NEXT 4096K MAXSIZE 1024M;

Tablespace created.

Step 4:

ALTER SYSTEM SET undo_tablespace = 'UNDOTBS' scope=spfile;

System altered.

Step 5: set old undo tablespace offine mode and drop

ALTER TABLESPACE UNDO_TBS offline;

Tablespace altered.

drop tablespace UNDO_TBS including contents and datafiles;

Tablespace dropped.

Step 6:
Rebounced the db services

Step 7: Changed the undo management parameter to AUTO

alter system set undo_management='AUTO' scope=spfile;

System altered.

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

NAME VALUE
——————– ——————–
undo_management AUTO
undo_tablespace UNDOTBS

Now the database is up and running with no issue and we cant find any ora error in the alert log file,