Home » RDBMS Server » Server Administration » ORACLE not available (oracle 10gR1)
ORACLE not available [message #305189] Mon, 10 March 2008 01:34 Go to next message
adit_me1
Messages: 49
Registered: October 2007
Location: BANGALORE
Member
I see the error messages for one of our application services:

ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
No such file or directory

The database seems to be mounted correctly and the listener is running. I have followed the various advice on bouncing the database but nothing seems to help. Does anybody who may have experienced the same problem have any thoughts or suggestions?

Any help is greatly appreciated.

Thanks,
aditya
Re: ORACLE not available [message #305190 is a reply to message #305189] Mon, 10 March 2008 01:40 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Does anybody who may have experienced the same problem

Yes many have experienced this.
Had you any error during startup?
Did you query v$database and v$instance to know in what state is your database/instance?
Did you search in alert.log to know if there is any error?

Regards
Michel
Re: ORACLE not available [message #305191 is a reply to message #305189] Mon, 10 March 2008 01:41 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
Is your database open?

select status from v$instance;

any erroneuos last lines in alertlog file?
Re: ORACLE not available [message #305476 is a reply to message #305191] Mon, 10 March 2008 23:42 Go to previous messageGo to next message
sarava20
Messages: 11
Registered: February 2008
Junior Member
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist

Try this...i faced the same problem in oracle 8i....
Not sure abt in 10g....

C:>sqlplus /nolog
SQL> connect /as sysdba
Connected to an idle instance.
SQL> STARTUP PFILE=D:\oracle\admin\orcl\pfile\init.ora
ORACLE instance started.

Total System Global Area 237856796 bytes
Fixed Size 75804 bytes
Variable Size 80416768 bytes
Database Buffers 157286400 bytes
Redo Buffers 77824 bytes
Database mounted.
Database opened.
SQL>connect scott/tiger
connected
SQL>
Re: ORACLE not available [message #305477 is a reply to message #305189] Mon, 10 March 2008 23:52 Go to previous messageGo to next message
gopu_g
Messages: 54
Registered: March 2008
Location: mumbai
Member

Hi
I faced the same problem in Oracle9i.

Try this...

Set the ORACLE_SID
startup the database using the spfile or pfile.
select name,open_mode from v$database;

Re: ORACLE not available [message #305638 is a reply to message #305477] Tue, 11 March 2008 07:51 Go to previous message
adit_me1
Messages: 49
Registered: October 2007
Location: BANGALORE
Member
hi.. the issue got resolved..
thanks for all your support...
Previous Topic: How to Find the user tables that are not referenced by any DB object
Next Topic: Which session generate archive redo log
Goto Forum:
  


Current Time: Thu Dec 08 08:37:02 CST 2016

Total time taken to generate the page: 0.10673 seconds