Home » RDBMS Server » Server Administration » Found dead shared server
Found dead shared server [message #61892] Tue, 08 June 2004 22:45 Go to next message
Arindam Saha
Messages: 15
Registered: May 2004
Junior Member
I am managing a database on NT with 10 shared servers and 2 dispatcher processes. At the peak business hours the maximum concurrent sessions are around 75. I am receiving the following messages quite frequently, Found dead shared server 's0nn' 'pid'. Could anybody tell what may be possible reasons.

 

 
Re: Found dead shared server [message #61901 is a reply to message #61892] Wed, 09 June 2004 03:29 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Please look at the logs and check for any ORA-600 Errors and post the exact message.
Re: Found dead shared server [message #61904 is a reply to message #61901] Wed, 09 June 2004 04:14 Go to previous messageGo to next message
Arindam Saha
Messages: 15
Registered: May 2004
Junior Member
The following messages are found at the log.
ORA-00600: internal error code, arguments: [[6034]], [[]], [[]], [[]], [[]], [[]], [[]], [[]]
found dead shared server 'S011', pid = (28, 16)
ORA-04030: out of process memory when trying to allocate 1451880 bytes (PLS non-lib hp,PL/SQL STACK)
Re: Found dead shared server [message #61906 is a reply to message #61904] Wed, 09 June 2004 04:53 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
ORA-00600: internal error code, arguments: [[6034]], [[]], [[]], [[]], [[]], [[]], [[]], [[]] >>> something to do with indexes

ORA-04030 >>> because low physical memory or sharedpool.

talk to OSS..bigBrothers out there are supposed to handle these..
Previous Topic: automatically gone to offline
Next Topic: MV not getting refreshed
Goto Forum:
  


Current Time: Fri Sep 20 14:30:00 CDT 2024