ORA-00603: ORACLE server session terminated by fatal errorORA-01092: ORACLE instance terminated. Disconnection forcedORA-30012: undo tablespace ‘UNDOTBS2’ does not exist or of wrong type

Cause:

Undo tablespace is not configured properly or given wrong tablespace name or tablespace no longer exist

kIsH@Xhydra<>startup;
ORACLE instance started.

Total System Global Area 1962932432 bytes
Fixed Size                  9136336 bytes
Variable Size            1308622848 bytes
Database Buffers          637534208 bytes
Redo Buffers                7639040 bytes
Database mounted.
ORA-00603: ORACLE server session terminated by fatal error
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-30012: undo tablespace 'UNDOTBS2' does not exist or of wrong type
Process ID: 20608
Session ID: 1 Serial number: 41909
kIsH@Xhydra<>!oerr ORA 30012
30012, 00000, "undo tablespace '%s' does not exist or of wrong type"
// *Cause:   the specified undo tablespace does not exist or of the
//           wrong type.
// *Action:  Correct the tablespace name and reissue the statement.

Action:

Change the parameter with the tablespace which exist

[oracle@xhydra ~]$ cat /u01/app/oracle/product/19.0.0/dbhome_1/dbs/initdb9zx.ora|grep 'UNDO'
*.undo_tablespace='UNDOTBS1'

kIsH@Xhydra<>create spfile from pfile;

File created.

kIsH@Xhydra<>startup
ORACLE instance started.

Total System Global Area 1962932432 bytes
Fixed Size                  9136336 bytes
Variable Size            1308622848 bytes
Database Buffers          637534208 bytes
Redo Buffers                7639040 bytes
Database mounted.
Database opened.
kIsH@Xhydra<>show parameter pfile

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string      /u01/app/oracle/product/19.0.0
                                                 /dbhome_1/dbs/spfiledb9zx.ora

Leave a Reply