Home » RDBMS Server » Server Administration » ORACLE NOT AVAILABLE
ORACLE NOT AVAILABLE [message #253542] Tue, 24 July 2007 03:42 Go to next message
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
Re: ORACLE NOT AVAILABLE [message #253549 is a reply to message #253542] Tue, 24 July 2007 03:58 Go to previous messageGo to next message
Littlefoot
Messages: 20894
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 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Os?
Re: ORACLE NOT AVAILABLE [message #253706 is a reply to message #253542] Tue, 24 July 2007 11:58 Go to previous messageGo to next message
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 Go to previous messageGo to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

on windows
Re: ORACLE NOT AVAILABLE [message #253772 is a reply to message #253764] Tue, 24 July 2007 15:55 Go to previous messageGo to next message
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.
Re: ORACLE NOT AVAILABLE [message #253844 is a reply to message #253764] Wed, 25 July 2007 01:37 Go to previous message
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".
Previous Topic: Error During Oracle 10g Installation
Next Topic: adding online redo logs
Goto Forum:
  


Current Time: Mon Dec 05 11:01:59 CST 2016

Total time taken to generate the page: 0.18707 seconds