Re: manual creation

From: d.j. <dec2g_at_hotmail.com>
Date: Thu, 13 May 2004 18:40:06 -0400
Message-ID: <4QSoc.95$H7.3219@eagle.america.net>

Ok
1)I tried to put the db name in the create statement and it did not work would not even open the create file.
2)When I changed the character set to mswin1252 Error " CREATE DATABASE character set is not know" I changed both character sets US7ASCII & AL16UTF16 to mswin1252 was that correct? 3)Bdump has not been created do I need to go in and create one manually.

D.j.

Sybrand Bakker wrote:

> 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

Received on Thu May 13 2004 - 17:40:06 CDT