Home » RDBMS Server » Networking and Gateways » ORA-01034: ORACLE not available  () 1 Vote
icon14.gif  ORA-01034: ORACLE not available [message #241028] Mon, 28 May 2007 04:05 Go to next message
sam4all
Messages: 29
Registered: August 2006
Location: Bangalore
Junior Member
My OS windows XP ,Oracle is 8.1.5 enterprise edition.
I cannot connect using sql*plus to oracle and error is "ORA-01034: ORACLE not available "
Re: ORA-01034: ORACLE not available [message #241035 is a reply to message #241028] Mon, 28 May 2007 04:12 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
ORA-01034: ORACLE not available
Cause: Oracle was not started up. Possible causes include the following:
- The SGA requires more space than was allocated for it.

- The operating-system variable pointing to the instance is improperly defined.

Action: Refer to accompanying messages for possible causes and correct the problem mentioned in the other messages. If Oracle has been initialized, then on some operating systems, verify that Oracle was linked correctly. See the platform specific Oracle documentation.
Re: ORA-01034: ORACLE not available [message #241039 is a reply to message #241028] Mon, 28 May 2007 04:17 Go to previous messageGo to next message
sujeetsaxena16
Messages: 9
Registered: May 2007
Location: mumbai
Junior Member

just connect to the oracle

connect internal
sqlplus "/as sysdba"
startup


its shows this error cause ur database is shutdown. plz try this and revert back.
Re: ORA-01034: ORACLE not available [message #241042 is a reply to message #241039] Mon, 28 May 2007 04:20 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
whats your sga size??
oracle service is running??
Previous Topic: HTTP Server issue
Next Topic: ORA-12571
Goto Forum:
  


Current Time: Tue Dec 06 16:28:19 CST 2016

Total time taken to generate the page: 0.06051 seconds