ERROR ORA-01034 ORACLE not available (307 Views)
Reply
Occasional Visitor
Satish Varma
Posts: 1
Registered: ‎12-23-2006
Message 1 of 3 (307 Views)

ERROR ORA-01034 ORACLE not available

Hi Dahlinger
i installed the oracle8i on window XP after successfully installation of my Oracle 8i its connected with all the user like system/manager,scott/tiger , i restarted my computer and now am trying to connect the oracle which i created now its saying ERROR ORA-01034 ORACLE not available,if i go and check the services.msc its showing the OracleServiceFINPRD(sid,Global Database Name) always in the STARTING state all the option will desabled like to restart the service.

Please guide me how can i resolve the problem ,i am very thankfull to you .

Regards
Satish Varma
alluri.snraju@gmail.com
Please use plain text.
Honored Contributor
Steven Schweda
Posts: 9,079
Registered: ‎02-23-2005
Message 2 of 3 (307 Views)

Re: ERROR ORA-01034 ORACLE not available

If you're using Windows XP, then you might
get better answers sooner in a Windows forum
than you will in this Tru46 UNIX forum.
Please use plain text.
Frequent Advisor
patrik rybar_1
Posts: 31
Registered: ‎06-19-2005
Message 3 of 3 (307 Views)

Re: ERROR ORA-01034 ORACLE not available

seem like you are running this from terminal client (you could have problem with rights to start services)
just try
net stop oracleservicefinprd
start sqlplus
set ORACLE_SID=FINPRD
set LOCAL=FINPRD
sqlplus "sys/password as sysdba"
startup
Please use plain text.
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation