OraFAQ Forum: Server Administration » Oracle Service fails to respond

Home » RDBMS Server » Server Administration » Oracle Service fails to respond

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

Oracle Service fails to respond [message #61562]

Wed, 05 May 2004 09:31

Brad
Messages: 12
Registered: April 1999

Junior Member

We have an Oracle 8.1.7 Enterprise Edition instance running on a W2k Server Box where the instance will stop responding for no aparent reason. Client connections recieve TNS errors that the shared memory realm doesnt exist. The oracle service appears as if it is still running, but if you stop and restart the service everything works fine again. This is happening at a remote site every 2 weeks or so. Everything else on the box looks healthy, nothing suspicious in the event logs.

I apologize for the lack of detail, but we've tried all we can think of and keep on coming up blank.

Any one had a similair problem with Oracle 8. We're considering upgrading them to Oracle 9, but that's just a shot in the dark

Thanks in advance.

Report message to a moderator

Re: Oracle Service fails to respond [message #61583 is a reply to message #61562]

Thu, 06 May 2004 12:01

Frank Naude
Messages: 4580
Registered: April 1998

Senior Member

Hi,

Here are a couple of things to check next time it happens:

- Any errors/ strange messages in Oracle's ALERT.LOG and LISTENER.LOG files?
- Any trace/core files in Oracle's UDUMP, BDUMP and CDUMP directories?
- Is the machine is under stress (Windows performance monitor)?
- Is the "oracle" process still running?
- Can you still connect using sqlplus?
- Any database locks/ latches (check with OEM or SQL scripts)?

If all else fails, you should take 3 successive SYSTEMSTATE dumps, with 10 minute intervals, and log a TAR with Oracle Support for assistance.

Procedure to take a SYSTEMSTATE dump from sqlplus:

SQL> connect internal 
SQL> alter session set events 'immediate trace name SYSTEMSTATE level 10';

Best regards.

Frank

Report message to a moderator

shared realm memory doesnt exist [message #117061 is a reply to message #61583]

Sun, 24 April 2005 03:45

ptuladhar
Messages: 1
Registered: April 2005
Location: nepal

Junior Member

how to solve this problem
'shared realm memory does not exist'
ora-27101

Report message to a moderator

Re: shared realm memory doesnt exist [message #117432 is a reply to message #117061]

Wed, 27 April 2005 06:04

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

Pls do provide snapshot of alert log for the time when u get this error.

Also, when this error comes, have you tried logging into Oracle using any username, other then Internal. What error do you get there?

Report message to a moderator

Previous Topic:	SQLLOADER Problem.....
Next Topic:	OMF benefit???

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 27 02:26:35 CDT 2024