Hi Stefan ORA-3113 means that the thing at the other end of your client's sqlnet connection has died, i.e. the user process. On unix with dedicated server, its an oracle executable, on windows I guess it's a thread, I'm not sure what it would be on MTS. This is not the same as the database being down. Usually there will be an ORA-600 or 7445 in the alert log and an associated trace or core dump in the user, background or core dump destinations. However, I have seen occasions where it looks like the dying process cannot find the dump dests and so sticks a core dump in $ORACLE_HOME or somewhere under it.
-- David Lord > -----Original Message----- > From: Stefan Jahnke [mailto:[EMAIL PROTECTED] > Sent: 14 November 2003 10:06 > To: Multiple recipients of list ORACLE-L > Subject: AW: End of communication channel > > > 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). > *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** This e-mail and its attachments are intended for the author's addressee only and may be confidential. If they have come to you in error you must take no action based on them, nor must you copy or show them to anyone; please reply to this e-mail and highlight the error. Please note that this e-mail has been created in the knowledge that Internet e-mail is not a 100% secure communications medium. We advise that you understand and observe this lack of security when e-mailing us. Steps have been taken to ensure this e-mail and attachments are free from any virus, but advise the recipient to ensure they are actually virus free. The views, opinions and judgments expressed in this message are solely those of the author. The message contents have not been reviewed or approved by Iron Mountain. *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Lord David 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).
