Error ORA-30012 – Undo tablespace does not exist or of wrong type

Undo tablespace does not exist or of wrong type

CREATE DATABASE ORCL *

ERROR at line 1:

ORA-01092: ORACLE instance terminated. Disconnection forced

ORA-01501: CREATE DATABASE failed

ORA-01519: error while processing file ‘%ORACLE_HOME%\RDBMS\ADMIN\dtxnspc.bsq’ near line 5

ORA-00604: error occurred at recursive SQL level 1

ORA-30012: undo tablespace ‘UNDOTBS1’ does not exist or of wrong type

Process ID: 4324

Session ID: 237 Serial number: 5

SQL>

 

Solution:

Verify that the name of our undo tablespace in create database statement, matches the name in your init file.