SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ERROR ORA-01034 : ORACLE not available

685113Feb 14 2009 — edited Feb 26 2009

HELLO FRIENDS,
i m new for oracle. I newly install Oracle 8i on my windows Xp computer. after restarting PC when i login on sql plus using scott/tiger it gives me a error message : ORA-01034 : ORACLE not available. then my friend tell me the following procedure to overcome this problem

1. go to <ORACLE_HOME>\bin
2. run svrmgrl.exe
then execute following two commands in svrmgrl command prompt.
connect internal
startup open

using this initially i logged in on sql plus using scott/tiger. but after restart the computer the same problem arise again.
please help me as soon as possible.

windows xp is installed on C:\ drive and oracle 8i is installed on E:\ drive.

thanks in advance.

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 26 2009

Added on Feb 14 2009

11 comments

1,751 views