Home » RDBMS Server » Server Administration » error: ora 01034: Oracle not availabe
error: ora 01034: Oracle not availabe [message #181135] Fri, 07 July 2006 00:39 Go to next message
deepakkumarrr
Messages: 2
Registered: July 2006
Location: mysore
Junior Member
When I have installed oracle 8i it was working alright. but when i rebooted the system and to logged in SQL+ it is giving error ORA-01034: ORACLE not available .

OS- 2000 server Can anybody tell me how to resolve this problem?

Report message to a moderator

Re: error: ora 01034: Oracle not availabe [message #181139 is a reply to message #181135] Fri, 07 July 2006 00:59 Go to previous messageGo to next message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
Are you sure you started the database?

MHE

Report message to a moderator

Re: error: ora 01034: Oracle not availabe [message #181146 is a reply to message #181139] Fri, 07 July 2006 01:14 Go to previous messageGo to next message
deepakkumarrr
Messages: 2
Registered: July 2006
Location: mysore
Junior Member
ya, when restart my system automatically oracle goes off i need to start the oracle manually by executing some sql commands

sqlplus "/as sysdba"
startup mount;
alter database recover;
alter database open;
commit;

but i want the oracle to start automatically by itself, it is very diffculty to be their whenever the system get restarted.


plz guide me how to resolve this problem.

Report message to a moderator

Re: error: ora 01034: Oracle not availabe [message #181384 is a reply to message #181146] Sun, 09 July 2006 12:21 Go to previous message
saadatahmad
Messages: 452
Registered: March 2005
Location: Germany/Paderborn
Senior Member
hi,
I have created script for one of our clients who was having the same problem for starting oracle manually whenever server restart was required. Though we resolved the issue by another way but this script also works fine.
There are two files here. startup.sql and startorcl.bat
copy the startup.sql file in your oracle_home/bin.
copy the batch file anywhere in the system and schedule it to run whenever window log on.
modify the path in the batch file according to your path in your system.

It works fine.

Hope this will solve your problem.

regards,
Saadat Ahmad

Report message to a moderator

Previous Topic: ORA-01092: Oracle Instance Terminated. Disconnection Forced
Next Topic: MAX DATAFILES
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 10:34:41 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.