database name is dec2g
C:\oracle\oradata\dec2g\system_01.dbf' SIZE 400M REUSE
>>UNDO TABLESPACE "UNDOTBS" DATAFILE
'c:\oracle\oradata\dec2g\undotbs01.dbf'
Thanks
D.j.
Alex Ivascu wrote:
> 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:10:39 CDT