Re: manual creation

From: Sybrand Bakker <gooiditweg_at_nospam.demon.nl>
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 DBA
Received on Fri May 14 2004 - 19:45:26 CEST

Original text of this message