OraFAQ Forum: Server Administration » ORACLE not available

Home » RDBMS Server » Server Administration » ORACLE not available (oracle 10gR1)

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

ORACLE not available [message #305189]

Mon, 10 March 2008 01:34

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

Report message to a moderator

Re: ORACLE not available [message #305190 is a reply to message #305189]

Mon, 10 March 2008 01:40

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: ORACLE not available [message #305191 is a reply to message #305189]

Mon, 10 March 2008 01:41

varu123
Messages: 754
Registered: October 2007

Senior Member

Is your database open?

select status from v$instance;

any erroneuos last lines in alertlog file?

Report message to a moderator

Re: ORACLE not available [message #305476 is a reply to message #305191]

Mon, 10 March 2008 23:42

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>

Report message to a moderator

Re: ORACLE not available [message #305477 is a reply to message #305189]

Mon, 10 March 2008 23:52

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;

Report message to a moderator

Re: ORACLE not available [message #305638 is a reply to message #305477]

Tue, 11 March 2008 07:51

adit_me1
Messages: 49
Registered: October 2007
Location: BANGALORE

Member

hi.. the issue got resolved..
thanks for all your support...

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 03:12:08 CST 2024