Create database Manually
349510Mar 25 2003 — edited Mar 26 2003I'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.