Re: manual creation
Date: Fri, 14 May 2004 19:45:26 +0200
Message-ID: <4b1aa09c5kgsu9jn5vuh5tb7cqsjaa0mc7_at_4ax.com>
On Fri, 14 May 2004 09:44:53 +0300, Kalev Kadak <otto_mommiste_at_yahoo.com> wrote:
>"d.j." 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.
>
>Just for clarification: do you do enter CREATE DATABASE your_dbname or
>do you have DB_NAME variable set already? REUSE is only useable on
>CONTROLFILE recreation afaik.
>
>Kalev
Doc question.
If you don't have a db_name in init.ora, you must have a db_name in
the create database command, or your db_name will be oracle.
If you do have a db_name in init.ora you don't need a database name in
create database. If you have a database name it must conform to the
db_name init.ora parameter.
-- Sybrand Bakker, Senior Oracle DBAReceived on Fri May 14 2004 - 19:45:26 CEST