-
ORA-01034 Oralce not available when creating database
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|