ORA-01034: ORACLE not available [message #101256] |
Wed, 07 July 2004 20:02 |
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 |
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 |
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
|
|
|