Undo tablespace error while creating a database

From: <muzu1232005_at_gmail.com>
Date: Tue, 17 Jul 2007 08:38:08 -0000
Message-ID: <1184661488.240532.317060@e9g2000prf.googlegroups.com>

I got this error while creating the database. The Part from alert log file is given.

Errors in file /disk1/test/smoradata/udump/smalldb_ora_6080.trc:

ORA-00604: error occurred at recursive SQL level 1

ORA-30012: undo tablespace 'UNDOTSSMDB' does not exist or of wrong type

Mon Jul 16 16:23:33 2007

Errors in file /disk1/test/smoradata/udump/smalldb_ora_6080.trc:

ORA-01501: CREATE DATABASE failed

ORA-01519: error while processing file '?/rdbms/admin/sql.bsq' near line 5792

ORA-00604: error occurred at recursive SQL level 1

ORA-30012: undo tablespace 'UNDOTSSMDB' does not exist or of wrong type

Error 1519 happened during db open, shutting down database

USER: terminating instance due to error 1519

Mon Jul 16 16:23:34 2007

Instance terminated by USER, pid = 6080

ORA-1092 signalled during: create database smalldb

default temporary tablespace TEMPSMDB... Received on Tue Jul 17 2007 - 03:38:08 CDT