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