Re: manual creation

"d.j." wrote:
>
> I am attempting to create a database manually with oracle 9i. I have
> started the instance through the command prompt and opened it. I did a
> startup nomount and the database mounted. I am at the point now where I
> have to create the actual database I am using windows xp pro and these
> commands
>
> CREATE DATABASE
> MAXLOGFILES 255
> MAXINSTANCES 10
> MAXDATAFILES 256
> MAXLOGHISTORY 256
> DATAFILE 'C:\oracle\oradata\dec2g\system_01.dbf' SIZE 400M REUSE
> UNDO TABLESPACE "UNDOTBS" DATAFILE 'c:\oracle\oradata\dec2g\undotbs01.dbf'
> SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
> CHARACTER SET US7ASCII NATIONAL CHARACTER SET AL16UTF16
> LOGFILE GROUP 1 ('c:\oracle\oradata\dec2g\redo1_01.dbf') SIZE 100M REUSE,
> GROUP 2 ('c:\oracle\oradata\dec2g\redo1_02.dbf') SIZE 100M REUSE,
> GROUP 3 ('c:\oracle\oradata\dec2g\redo1_03.dbf') SIZE 100M REUSE;
>
> It attempts to create but I get an error which says " ORA-01092: ORACLE
> instance terminated. Disconnection forced. "
> I can not figure out what's going on. I checked my all my parameter
> files and paths and everything seems to be all right so could someone
> please give advice here
>
> Thanks in advanced
>
> D.j.

Just for clarification: do you do enter CREATE DATABASE your_dbname or do you have DB_NAME variable set already? REUSE is only useable on CONTROLFILE recreation afaik.

Kalev Received on Fri May 14 2004 - 08:44:53 CEST