Re: manual creation

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. "

It means your init.ora doesn't reference the correct UNDO tablespace. Set UNDO_TABLESPACE=UNDOTBS.

You know how I ever learnt that the ORA-01092 meant that my undo tablespace was not named/referenced correctly? Because when you get an error like this, you should always check your alert log. And in the alert log, there will be a message along the lines of 'can't find the undo tablespace referenced. Terminating instance'.

The alert log is in the BACKGROUND_DUMP_DEST directory.

Regards
HJR Received on Thu May 13 2004 - 17:19:36 CDT