Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Diagnosing ORA-3113 errors

Re: Diagnosing ORA-3113 errors

From: <>
Date: Thu, 29 Jun 2000 09:33:58 -0700
Message-Id: <>

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


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

Please respond to

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

Subject: Re: Diagnosing ORA-3113 errors


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

Stephane Paquette
DBA Oracle
(33) 01 53 93 06 50

Do You Yahoo!?
Get Yahoo! Mail - Free email you can access from anywhere!
Author: =3D?iso-8859-1?q?paquette=3D20stephane?=3D

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: (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

Original text of this message