Re: Undo tablespace error while creating a database

muzu1232005_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...
>

How are you creating your database? With DBCA or manually?

It looks like the CREATE DATABASE statement, with all of its options, is not defined correctly. Without seeing the actual statement, it could be difficult to diagnose the problem.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

-- 
Posted via a free Usenet account from http://www.teranews.com