Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: manual creation
First off, you seem to be missing the database name in your create
statement. Please check the log file for any other errors (specified by the
background_dump_dest).
Alex Ivascu
"d.j." <dec2g_at_hotmail.com> wrote in message
news:uaSoc.87$H7.3026_at_eagle.america.net...
> 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.
>
Received on Thu May 13 2004 - 17:02:47 CDT