Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Create database Manually

349510Mar 25 2003 — edited Mar 26 2003
I'm trying to Manually create a database with Oracle 9i release 9.2 on Win 2000.
I successfully followed the documentation instructions
(create the instance with ORADIM, and then STARTUP it, but when I submit the CREATE DATABASE script from sqlplus, I get the error
======ERROR FROM SQLPLUS SHELL ====
SQL> @E:\$appoggio\Capitolo3Teoria\Cdb1.sql
CREATE DATABASE prod
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
========ERROR FROM SQLPLUS SHELL ====

The script containing the create database is:
====START CREATE DATABASE SCRIPT ====
CREATE DATABASE prod
USER SYS IDENTIFIED BY manager
USER SYSTEM IDENTIFIED BY manager
LOGFILE GROUP 1 ('E:\oracle\oradata\prod\redo01.log') SIZE 100M,
GROUP 2 ('E:\oracle\oradata\prod\redo02.log') SIZE 100M,
GROUP 3 ('E:\oracle\oradata\prod\redo03.log') SIZE 100M
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
MAXINSTANCES 1
CHARACTER SET WE8MSWIN1252
DATAFILE 'E:\oracle\oradata\prod\system01.dbf' SIZE 325M REUSE
UNDO TABLESPACE undotbs
DATAFILE 'E:\oracle\oradata\prod\undotbs01.dbf'
SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED;
====END CREATE DATABASE SCRIPT ====

So I checked in the alert_log file and i found the message
related to the failure of the UNDO TABLESPACE:
=== ALERT_PROD.LOG file (bdump directory) ====
CREATE UNDO TABLESPACE UNDOTBS DATAFILE 'E:\oracle\oradata\prod\undotbs01.dbf'
SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED

Tue Mar 25 16:44:04 2003
Created Undo Segment _SYSSMU1$
Created Undo Segment _SYSSMU2$
Created Undo Segment _SYSSMU3$
Created Undo Segment _SYSSMU4$
Created Undo Segment _SYSSMU5$
Created Undo Segment _SYSSMU6$
Created Undo Segment _SYSSMU7$
Created Undo Segment _SYSSMU8$
Created Undo Segment _SYSSMU9$
Created Undo Segment _SYSSMU10$
ORA-30012 signalled during: CREATE UNDO TABLESPACE UNDOTBS DATAFILE 'E:\oracl...
Tue Mar 25 16:44:04 2003
Errors in file e:\oracle\admin\prod\udump\prod_ora_2624.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-30012: undo tablespace 'UNDOTBS1' does not exist or of wrong type
=== END ALERT_PROD.LOG file (bdump directory) ====
In fact the script created the CONTROL, REDO, SYSTEM datafiles, but I can also see the UNDOTBS01.DBF datafile.

Can someone help me correcting the script?

thank you
g.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 23 2003
Added on Mar 25 2003
2 comments
1,083 views