Agreed. By the way, since my original posting, this error has occurred several more times. Yes, it is a catch-all error that sounds a lot like an ORA-3113. Since they using the Oracle thin JDBC driver, which talks directly to the listener, Net8 isn't involved. If the server is shut down or crashes, apparently this error is also returned, like an ORA-3113. But the server hasn't crashed or shut down. This is a catch-all error and BEA has a long list of things that can cause this error. The database can cause this error under a few circumstances. Like "the database closed the connection". Naturally the developers turn to the DBA at that point. At this point I just want to know what to say when they ask "did the Oracle server close the connection?" In my years of working with Oracle I haven't found it to spontaneously close connections. But how can I prove that Oracle isn't closing the connection? Can anyone think of a log that would be written to if it did? Should the developers be capturing more information in their Java code? I can recall back in the days of novice C programmers writing Oracle database calls that new programmers would not check error conditions and if an error occurred the program would continue merrily along, processing garbage. Apparently some of our other Java programs are coded to retry the connection if this occurs.
Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -----Original Message----- Sent: Thursday, October 09, 2003 7:41 AM To: Multiple recipients of list ORACLE-L do they mean the ora -03113 end of file communication error(number may be off)? Alot of stuff causes that error. that is a very vague response on their part. > > From: DENNIS WILLIAMS <[EMAIL PROTECTED]> > Date: 2003/10/08 Wed PM 11:34:24 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: BROKEN_PIPE during Weblogic J2EE deployment > > Apparently BROKEN_PIPE is a pretty generic error. Quite a few problems can > cause this error. One problem BEA mentions is "if the database closes the > connection". Does anyone have a suggestion for what I should reply to this? > Are there any situations under which Oracle would close a connection? Would > that event appear in any log? > > Dennis Williams > DBA, 80%OCP, 100% DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > > -----Original Message----- > Sent: Monday, October 06, 2003 1:34 PM > To: Multiple recipients of list ORACLE-L > > > As Weblogic is not an Oracle product, it is not surprising that Metalink > returned nothing. Try your query on Google. > > Ian MacGregor > Stanford Linear Accelerator Center > [EMAIL PROTECTED] > > > -----Original Message----- > Sent: Monday, October 06, 2003 10:19 AM > To: Multiple recipients of list ORACLE-L > > > Our web administrator was deploying a new J2EE application to production and > received the error broken_pipe. We are using the thin client. Apparently > Weblogic tries to verify existence the tables the application uses. The > deployment was otherwise successful in that the error occurred several times > when deployment was retried but testing the app worked fine. They feel it > was a database error, but I don't see anything on my end. Naturally they are > nervous about this error just going into a critical new application. > Apparently if the database was down, this is the error returned on the > Weblogic side, but the database was fine and I couldn't find any errors. I > searched for broken_pipe on Metalink and the search returned empty. Has > anyone had any experience with this Weblogic error? > > Dennis Williams > DBA, 80%OCP, 100% DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > -- > 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: MacGregor, Ian A. > 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: <[EMAIL PROTECTED] 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).
