-
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
-
After
4.conn /as sysdba
Connected to idle instance
You have to give
STARTUP NOMOUNT pfile=%path%
Then
Create DB command
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
-
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.
-
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
-
I am allready doing that and asking experts like you if they can help.
Thank you.
-
Check Alert.log for errors.
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
-
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.
Last edited by patel_dil; 08-13-2003 at 09:47 AM.
-- Dilip
-
Re: ORA-01034 Oralce not available when creating database
------------------------------------------------------------
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
-
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 )
-
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 )
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
|