Re: Undo tablespace error while creating a database

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Tue, 17 Jul 2007 17:25:47 +0200
Message-ID: <469cdf79$0$5199$426a74cc@news.free.fr>

<muzu1232005_at_gmail.com> a écrit dans le message de news: 1184661488.240532.317060_at_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...
|

The tablespace you gave in the "undo_tablespace" parameter of your configuration file is not the undo tablespace you gave in the "create database" statement.

Regards
Michel Cadot Received on Tue Jul 17 2007 - 10:25:47 CDT