On Jul 17, 4: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..
post your init.ora settings and create database script.
Received on Tue Jul 17 2007 - 14:37:11 CDT
