Re: Diagnosing ORA-3113 errors

My first step is to try the offending query from a local connection at the server (I do the same with ORA-12571's). Just make sure TWO_TASK or LOCAL isn't set! Makes it really easy to rule out network issues.

Just my $.02

• Anita
  • Gaja Krishna Vaidyanatha <gajav_at_yahoo.com> wrote:
    > Bill,
    >
    > You can turn on SQL*Net/Net 8 trace on the client
    > and the server
    > side and the tracefile usually points at the
    > culprit. Most of
    > the time, it is a network/router problem, an
    > incompatible
    > protocol stack or a version of SQL*Net that is
    > buggy. I have
    > also seen a flavor of this problem, when the version
    > of SQL*Net
    > on the client side is higher than the version of the
    > listener.
    > This was in the SQL*Net 2.2/2.3 days.
    >
    > If the problem is re-produceable with a certain
    > amount of
    > accuracy and predictability, then turn trace on
    > during a time of
    > day, when not much is going on, so that you don't
    > bottleneck
    > your system/network by the tracing effort. You
    > might want to
    > set the trace at level - 16, so that you can get
    > packet dumps to
    > tell you in detail, what is going on. If you need
    > help with
    > reading the trace file, please post it (a part of it
    > should be
    > sufficient) and we could look at it.
    >
    > Hope that helps,
    >
    > Gaja.
    >
    > --- Bill Wagman <wjwagman_at_ucdavis.edu> wrote:
    > > 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).
    >
    >
    > =====
    > Gaja Krishna Vaidyanatha
    > Director, I-O Management Products
    > Quest Software Inc.
    > (972)-304-1170
    > gajav_at_yahoo.com
    >
    > "Opinions and views expressed are my own and not of
    > Quest"
    >
    > __________________________________________________
    > Do You Yahoo!?
    > Get Yahoo! Mail - Free email you can access from
    > anywhere!
    > http://mail.yahoo.com/
    > --
    > Author: Gaja Krishna Vaidyanatha
    > INET: gajav_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).
    

    ---