Hi Dennis According to Metalink, an ora-03113 on an already established connection points to a terminated Oracle executable. This is not the case, Oracle is still up and running. Unfortunately, it's windows, so I still have to figure out how to see wether the user process has been terminated (should be a thread running within the same process on win ?!).
Stefan -----Ursprüngliche Nachricht----- Von: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 13. November 2003 18:00 An: Multiple recipients of list ORACLE-L Betreff: RE: End of communication channel Stefan - I'm assuming this is the notorious ORA-3113 error? (the text is end of channel) You might start with Note 1020463.3 on Metalink. It covers the obvious stuff that should be checked out before digging deeper. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -----Original Message----- Sent: Thursday, November 13, 2003 5:19 AM To: Multiple recipients of list ORACLE-L Hi list I'm looking for further hints on where to look for problems which may lead to an "end of communication channel" error. Any input (especially networking or operating system problems) appreciated. The server runs 9.0.1.0.1 on Win2k. Not my box, a coworker has trouble with the network/sys admins stating that it can't be a network/system problem. I highly doubt that, since the Oracle service and the listener are both constantly available. No memory problems either. It's just that in the middle of the session, the connection goes down the drain. Any ideas ? TIA, Stefan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stefan Jahnke INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stefan Jahnke INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
