RE: Diagnosing ORA-3113 errors

From: Christine Turner <Christine.Turner_at_IPS-Sendero.com>
Date: Thu, 29 Jun 2000 07:19:19 -0000
Message-Id: <10543.110780@fatcity.com>

We sometimes see the ORA-3113 errors on our NT machines as well. I got the same response from Oracle support as well. Usually rebooting the machine, deleting and re-creating services and restarting everything does the trick.  If by chance you have a 95 machine, you could check the SQLNTTT.DLL.  There is a zip file called SQLNTTT.zip that you can get from Oracle that replaces that particular dll. I have never tried it on NT...have no idea if it would work.

Good Luck!

Christine Turner
Database Administrator
IPS-Sendero
Scottsdale, Arizona
Phone: (800) 321-6899 ext. 3286
Fax: (480) 946-8224
E-mail: christine.turner_at_ips-sendero.com

-----Original Message-----

From:	paquette stephane [SMTP:stephane_paquette_at_yahoo.com]
Sent:	Thursday, June 29, 2000 5:47 AM
To:	Multiple recipients of list ORACLE-L
Subject:	Re: Diagnosing ORA-3113 errors

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

  ---

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: =?iso-8859-1?q?paquette=20stephane?=
  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

Received on Thu Jun 29 2000 - 02:19:19 CDT