OraFAQ Forum: Networking and Gateways » ORA-01034: ORACLE not available

Home » RDBMS Server » Networking and Gateways » ORA-01034: ORACLE not available (

) 1 Vote

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-01034: ORACLE not available [message #241028]

Mon, 28 May 2007 04:05

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 "

Report message to a moderator

Re: ORA-01034: ORACLE not available [message #241035 is a reply to message #241028]

Mon, 28 May 2007 04:12

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.

Report message to a moderator

Re: ORA-01034: ORACLE not available [message #241039 is a reply to message #241028]

Mon, 28 May 2007 04:17

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.

Report message to a moderator

Re: ORA-01034: ORACLE not available [message #241042 is a reply to message #241039]

Mon, 28 May 2007 04:20

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

whats your sga size??
oracle service is running??

Report message to a moderator

Previous Topic:	HTTP Server issue
Next Topic:	ORA-12571

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 01:07:26 CST 2024