RE: BROKEN_PIPE from Weblogic

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.
dwilliams_at_lifetouch.com

-----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 <DWILLIAMS_at_LIFETOUCH.COM>
> Date: 2003/10/08 Wed PM 11:34:24 EDT
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> 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.
> dwilliams_at_lifetouch.com
>
>
> -----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
> ian_at_SLAC.Stanford.edu
>
>
> -----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.
> dwilliams_at_lifetouch.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: DENNIS WILLIAMS
> INET: DWILLIAMS_at_LIFETOUCH.COM
>
> 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: ListGuru_at_fatcity.com (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: ian_at_SLAC.Stanford.EDU
>
> 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: ListGuru_at_fatcity.com (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: DWILLIAMS_at_LIFETOUCH.COM
>
> 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: ListGuru_at_fatcity.com (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: <rgaffuri_at_cox.net
  INET: rgaffuri_at_cox.net

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: ListGuru_at_fatcity.com (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: DWILLIAMS_at_LIFETOUCH.COM

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: ListGuru_at_fatcity.com (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).