OraFAQ Forum: Server Administration » ORACLE NOT AVAILABLE

Home » RDBMS Server » Server Administration » ORACLE NOT AVAILABLE

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

ORACLE NOT AVAILABLE [message #253542]

Tue, 24 July 2007 03:42

balaji1482
Messages: 312
Registered: July 2007
Location: INDIA

Senior Member

hi friends,

I have created one new database called BALA01.when i tried to connect to ORACLE im getting this error(ORA-01034: ORACLE NOT AVAILABLE).

So guys kindly help me out to solve this problem.

Regards,
Balaji

Report message to a moderator

Re: ORACLE NOT AVAILABLE [message #253549 is a reply to message #253542]

Tue, 24 July 2007 03:58

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

It seems that the database has not been started up. So - start it up!

Quote:

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.

[Updated on: Tue, 24 July 2007 03:58]

Report message to a moderator

Re: ORACLE NOT AVAILABLE [message #253686 is a reply to message #253549]

Tue, 24 July 2007 11:02

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Os?

Report message to a moderator

Re: ORACLE NOT AVAILABLE [message #253706 is a reply to message #253542]

Tue, 24 July 2007 11:58

harry07
Messages: 61
Registered: June 2007
Location: now york

Member

Hey Balaji

I know there are seniors also helping you .
But Let me also try to help you.

Do required changes in your listener.ora and tnsnames.ora

1.export ORACLE_SID ORACLE_HOME

2.sqlplus /nolog

3.conn sys as sysdba
password

4.startup

Regards

[Updated on: Tue, 24 July 2007 12:00]

Report message to a moderator

Re: ORACLE NOT AVAILABLE [message #253764 is a reply to message #253549]

Tue, 24 July 2007 15:32

balaji1482
Messages: 312
Registered: July 2007
Location: INDIA

Senior Member

on windows

Report message to a moderator

Re: ORACLE NOT AVAILABLE [message #253772 is a reply to message #253764]

Tue, 24 July 2007 15:55

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

check services?
did you pervious drop database from DBCA?
may be entry missing from registry.

Report message to a moderator

Re: ORACLE NOT AVAILABLE [message #253844 is a reply to message #253764]

Wed, 25 July 2007 01:37

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

On Windows Command prompt.

set oracle_sid=<sid>
net start OracleSerivce<SID>

Regards
Taj

PS: check windows services and change startup type "automatic".

Report message to a moderator

Previous Topic:	Error During Oracle 10g Installation
Next Topic:	adding online redo logs

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 08:19:32 CDT 2024