ORA-01034 Oralce not available when creating database

[Aljaz]

Hi,

Oracle 9iR2, OS Windows XP


I am trying to set up instance and database manualy. I have allready created instance and I am able to connect to instance. But when I try to execute command CREATE DATABASE test I get ORA-01034 Oracle not available.

And here are the steps

1. I have created dictories

oradim -new -sid TEST -pfile "c:\ora9iR2\databas\initTEST.ora" startmode a

I have used the sample init file, renamed it copied it to default location, changed the value db_name to TEST and added two lines
DB_CREATE_FILE_DEST=C:\ORA9iR2\OraData\TEST
DB_CREATE_ONLINE _LOG_DEST_1=C:\ORA9iR2\OraData\TEST

2. SET ORACLE_SID = TEST
SET LOCAL = TEST

3.sqplus /nolog
4.conn /as sysdba
Connected to idle instance

5.create database "TEST";

Here is where I get ORA-01034

[abhaysk]

After
4.conn /as sysdba
Connected to idle instance

You have to give

STARTUP NOMOUNT pfile=%path%

Then

Create DB command

[Aljaz]

Thank you, but now I have new problem

I can now execute command
create database TEST;

But now I am getting ORA-01092 Oracle instance terminated. Disconnection forced.

[abhaysk]

I wud now suggest RTM

[Aljaz]

I am allready doing that and asking experts like you if they can help.

Thank you.

[abhaysk]

Check Alert.log for errors.

[patel_dil]

Check if you have right permissions in the folders you are trying to create the database. Also check if you are trying to overwrite the any datafile during database creation. Maybe the alertlog will let you know what other errors are associated.

[bazza]

------------------------------------------------------------
oradim -new -sid TEST -pfile "c:\ora9iR2\databas\initTEST.ora" startmode a

---------------------------------

try startmode manual (you can use oradim -edit later if need be to set it to auto startup), when you create the instance.

Wipe out any old services and clean up your box before starting again of course, make sure you delete any old PWD*.ora files as well.

Bazza

[Aljaz]

Check Alert.log for errors.

Check alert.log for errors and then post the question!!!!

I forgot to create password file


Thank you all ( for now )

[Aljaz]

Check Alert.log for errors.

Check alert.log for errors and then post the question!!!!

I forgot to create password file


Thank you all ( for now )