Re: Diagnosing ORA-3113 errors

From: Gaja Krishna Vaidyanatha <gajav_at_yahoo.com>
Date: Wed, 28 Jun 2000 18:32:42 -0700 (PDT)
Message-Id: <10542.110734@fatcity.com>

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! Received on Wed Jun 28 2000 - 20:32:42 CDT