Re: Undo tablespace error while creating a database

On Jul 17, 10:38 am, muzu1232..._at_gmail.com wrote:
> 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...

I don't see any database version, and, more importantly, I don't see the CREATE DATABASE statement (which should be in the alert log). Likely, the undo tablespace clause of your create database is incorrect, but as you jumped to this group without even looking, no one here can see it either.

--
Sybrand Bakker
Senior Oracle DBA