Below is the workaround steps
1. Startup database in mount mode
SQL> startup mount
ORACLE instance started.
Total System Global Area 4294967296 bytes
Fixed Size 2078264 bytes
Variable Size 4160752072 bytes
Database Buffers 117440512 bytes
Redo Buffers 14696448 bytes
Database mounted.
2. Check the values for Undo related parameter
SQL> show parameter undo
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_management string AUTO
undo_retention integer 900
undo_tablespace string UNDOTBS1
3. Change the UNDO_MANAGEMENT to ‘MANUAL’
SQL> alter system set undo_management='MANUAL' scope=spfile;
4. As, the above parameter is a static one, bounce the database
SQL> shu immediate;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 4294967296 bytes
Fixed Size 2078264 bytes
Variable Size 4160752072 bytes
Database Buffers 117440512 bytes
Redo Buffers 14696448 bytes
Database mounted.
Database opened.
5. If everything seems fine, then go ahead and create a new undo tablespace.
SQL> create undo tablespace UNDOTBS datafile '/disk1/oradata/idcdb/undotbs1.dbf' size 1G autoextend on;
Tablespace created.
SQL> show parameter undo
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_management string MANUAL
undo_retention integer 900
undo_tablespace string UNDOTBS1
6. Set the undo_tablespace to the new Undo Tablespace name and undo_management back to ‘AUTO’
SQL> alter system set undo_tablespace='UNDOTBS' scope=spfile;
System altered.
SQL> alter system set undo_management='AUTO' scope=spfile;
System altered.
7. Bounce the database
SQL> shu immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 4294967296 bytes
Fixed Size 2078264 bytes
Variable Size 4160752072 bytes
Database Buffers 117440512 bytes
Redo Buffers 14696448 bytes
Database mounted.
Database opened.
After this the database was open successfully without any error.But,things don’t end up here.
Credit : Anand's Blog