Home » Infrastructure » Windows » ORA-01034: ORACLE not available
ORA-01034: ORACLE not available [message #101256] Wed, 07 July 2004 20:02 Go to next message
anwar
Messages: 4
Registered: February 2002
Junior Member
i have installed Oracle 8.0.5 on a windows 2000 pro computer and also installed Developer 6, now i am getting this massage when i want to connect with Oracle from SQLPLUS or Developer form or report builder-------ORA-01034: ORACLE not available. How can i resolve this problem. Thank you.
Re: ORA-01034: ORACLE not available [message #101304 is a reply to message #101256] Fri, 30 July 2004 23:22 Go to previous messageGo to next message
Edwin
Messages: 5
Registered: September 2002
Junior Member
Hai,

I have installed Oracle 8i on my Windows 2000 prof. computers in LAN. Most of the computers shows ORACLE NOT AVAILABLE message when trying to enter password.

All are installed as enterprise servers.

Please tell me a remedy.
Re: ORA-01034: ORACLE not available [message #101609 is a reply to message #101304] Wed, 05 January 2005 09:10 Go to previous message
sofiane
Messages: 2
Registered: February 2002
Junior Member
This problem happen because the service is started but not the (instance) database, use these instructions they can resolve your problem :

Starting the service :
c:somearbitrarypath> oradim -startup -sid <your-sid-goes-here> -starttype srvc
Starting the instance :
c:somearbitrarypath> oradim -startup -sid <your-sid-goes-here> -starttype inst
Starting both the service and the instance :
c:somearbitrarypath> oradim -startup -sid <your-sid-goes-here> -starttype srvc,inst
Previous Topic: DOWNLOAD OF ORACLE 9i PERSONAL EDITION
Next Topic: User Info from Microsoft Active Directory
Goto Forum:
  


Current Time: Thu Apr 18 19:12:06 CDT 2024