found dead shared server

From: Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org>
Date: Fri, 27 Aug 2004 11:56:59 -0400
Message-Id: <s12f21a8.091@gcrta.org>

Implemented MTS in Production Oracle Applications database this morning. A few hours after startup, I see a message about a dead server. What would cause this? No trace file generated other than this alert log entry.
SMON: enabling cache recovery
SMON: enabling tx recovery
Fri Aug 27 07:17:12 2004
Updating 8.1.7.4.1 NLS parameters in sys.props$
-- adding 8.1.7.4.1 NLS parameters.

Fri Aug 27 07:17:23 2004
Completed: ALTER DATABASE OPEN
Fri Aug 27 10:23:43 2004
found dead multi-threaded server 'S001', pid = (12, 1)  

It appears it was restarted????
SQL> select * from v$shared_server;
NAME PADDR STATUS MESSAGES BYTES BREAKS CIRCUIT
---- -------- ---------------- ---------- ---------- ----------

---

IDLE BUSY REQUESTS
---------- ---------- ----------

S000 90176268 EXEC 23396 2881948 249 908492F0 73449 1427871 11129
S001 90176590 EXEC 191058 32058148 107 908493F4 329675 122347 91467
S002 901768B8 WAIT(COMMON) 143738 20750841 195 00 1488440 64423 68578
S003 90176BE0 WAIT(COMMON) 22073 3309922 81 00 1497817 2054 10619
S004 90176F08 WAIT(COMMON) 1158 216230 56 00 1488329 2668 529  

Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority 1240 W. 6th Street
Cleveland, Ohio 44113

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Fri Aug 27 2004 - 12:21:20 CDT