dead multi-threaded server

[ann1]

Occasionally, when I refresh snapshots in Ora8i (817) database, I got the end-of-communication channel error. The trace file says

"found dead multi-threaded server 'S000', pid = (12, 1)" at the end and "600 internal error" at the beginning.

Does it ring a bell to anyone as to what's causing it? It doesn't happen all the time. Thanks.

[jason]

The ORA-600 means that the MTS dispatcher encountered an error. Oracle is expecting half-duplex protocol in MTS, which means that only the client or the server can be sending information at any given time. The application programs should be examined to see if this is being violated. In the client programs, check if:

1. the client sends new data or a new request without waiting for
completion of previous request

2. multiple clients use the same socket

3. the SQL statements are not serialized

4. 'exec sql commit release' is used

For repeated occurrances, and to further debug the issue setup sqlnet client tracing
and send in the alert.log and associated trace files to Oracle Support

Jason

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~Oracle DB Resources ( http://oracle.dbresources.com)

- Online community for Oracle DBAs and Developers -
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~