Re: manual creation

On Thu, 13 May 2004 17:55:41 -0400, "d.j." <dec2g_at_hotmail.com> 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.

You did create a service using oradim prior to your startup nomount, did you ?

Sounds like you didn't

oradim -? in a dos box will show you all the options there are

If you did create a service it should show as 'OracleService<SID>' as 'Started' in the administrative tools section services applet of Control Panel.

Character set US7ASCII is a bad idea. It should be MSWIN1252 on Winblows.

--
Sybrand Bakker, Senior Oracle DBA