BACKGROUND_DUMP_DEST=C:\Oracle\admin\dec2g\bdump
CORE_DUMP_DEST=C:\Oracle\admin\dec2g\cdump
TIMED_STATISTICS=TRUE
USER_DUMP_DEST=C:\Oracle\admin\dec2g\udump
d.j.
d.j. wrote:
> 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:15:09 CDT