Re: Diagnosing ORA-3113 errors

From: <Winnie_Liu_at_infonet.com>
Date: Thu, 29 Jun 2000 09:33:58 -0700
Message-Id: <10543.110797@fatcity.com>

--0__=besmnotk2Mx4eXlE640ASUY5Wf4aDl9sQYQ4ffY8GK2IzIyBhfMTwR7i Content-type: text/plain; charset=us-ascii Content-Disposition: inline

Just another couple of thoughts as I just finish dealing with ORA-3113 error myself (that is a bug on dynamic SQL, which is not fixed in any version available so far in Oracle.. Oracle still working to get it fixed in 817!! :P)

ORA-3113 is not a pure error that a user receive from the client side. Most of the time, it points to some errors in the network connection, or the packet being lost, session is lost etc. But other time, it will also generate dumps and trace files on the server also (as this is my case this time, trace files and dumps are generated in the server side, that is how I nail it down this time!)

Metalink had a real good article of what to check when you get the ORA-3113 error. Check it out.

Winnie

paquette stephane <stephane_paquette_at_yahoo.com> on 06/29/2000 05:47:01 AM

Please respond to ORACLE-L_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: (bcc: Winnie Liu/HQ/ISC)

Subject: Re: Diagnosing ORA-3113 errors

--0__=besmnotk2Mx4eXlE640ASUY5Wf4aDl9sQYQ4ffY8GK2IzIyBhfMTwR7i

Content-type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-transfer-encoding: quoted-printable

ORA-3113 is a catchy one.
Recently I had 2 series of ORA-3113, one was a network ing problem, the network guys has changed some setttings on some components of the network. The other was a query using Intermedia that was crashing with ORA-3113 each time we query "milk". I tested it on 8.1.6 and the ORA-3113 went away. In each case, Oracle could find out why even with tracing at a low level.
ORA-3113 seems pretty difficult to deal with. Good luck

Bill Wagman <wjwagman_at_ucdavis.edu> a =E9crit=A0:<br> > Hi,
>
> An application running on an NT workstation is
> experiencing ORA-3113
> errors. I have never really been able to get a
> conclusive answer from
> Oracle on how to diagnose the problem causing these
> errors. If anyone has
> any suggestions they would be most appreciated.
>
> Thanks.
>
> Bill Wagman
> Univ. of California at Davis
> Information Resources
> wjwagman_at_ucdavis.edu
> (530) 754-6208
>
>
-----------------------------------------------------------------------=
--
> Why is it that when you're driving and looking for
> an address, you turn
> down the volume on the radio?
>
> --
> Author: Bill Wagman
> INET: wjwagman_at_ucdavis.edu
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>

> 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).

=3D=3D=3D=3D=3D
Stephane Paquette
DBA Oracle
stephane_paquette_at_yahoo.com
spaquette_at_houra.fr
(33) 01 53 93 06 50

Do You Yahoo!?
Get Yahoo! Mail - Free email you can access from anywhere! http://mail.yahoo.com/

--
Author: =3D?iso-8859-1?q?paquette=3D20stephane?=3D
  INET: stephane_paquette_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).

Received on Thu Jun 29 2000 - 11:33:58 CDT