Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id h173eTn10545 for ; Thu, 6 Feb 2003 21:40:29 -0600 X-ClientAddr: 209.68.248.164 Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164]) by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id h173eTQ10540 for ; Thu, 6 Feb 2003 21:40:29 -0600 Received: from fatcity.UUCP (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id QAA62952; Thu, 6 Feb 2003 16:23:53 -0800 (PST) Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 0054681D; Thu, 06 Feb 2003 15:03:50 -0800 Message-ID: Date: Thu, 06 Feb 2003 15:03:50 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: "Gene Sais" Sender: root@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: "Gene Sais" Subject: Re:Trolling for ideas Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="=_4E113FB2.3F5E4B68" --=_4E113FB2.3F5E4B68 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable Sounds like a network problem, beware of the network outages during off = hours. Re-write in perl and run on the db server :). Change the times it = runs and see if you can recreate the problem. >>> dgoulet@vicr.com 02/06/03 05:14PM >>> Dennis, I have been plagued by a similar problem and have a fix if it fits. = Check the statements where the 3113 is coming from. Are they going to a remote database? And if so, are the tables on the remote database analyzed while = the local tables are not? Then the fix is to delete the statistics on the = remote database. I believe it to be a bug in 8.1.6. Dick Goulet ____________________Reply Separator____________________ Author: DENNIS WILLIAMS Date: 2/6/2003 1:18 PM I have a developer that wrote a VB program using ADO, connecting to Oracle 8.1.6 on a Compaq Tru64 server. One program of his runs for hours each night, and sometimes receives an ORA-03113 end-of-file on communication channel. Not consistently, just sporadically, and at varying amounts of time. I have been unable to find anything in the server logs. We have = traced the program and the error occurs during different SQL statements. Followed most of the tips I've located on solving ORA-03113 errors. I am coming to the conclusion that maybe the only solution will be to upgrade Oracle and hope that solves the problem. Unfortunately we can only upgrade to Oracle 8.1.7.4. Does anyone have any other ideas? Thanks. Dennis Williams DBA, 40%OCP Lifetouch, Inc. dwilliams@lifetouch.com=20 --=20 Please see the official ORACLE-L FAQ: http://www.orafaq.net --=20 Author: DENNIS WILLIAMS INET: DWILLIAMS@LIFETOUCH.COM Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@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). --=20 Please see the official ORACLE-L FAQ: http://www.orafaq.net --=20 Author:=20 INET: dgoulet@vicr.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@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). --=_4E113FB2.3F5E4B68 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Description: HTML Sounds = like a=20 network problem, beware of the network outages during off hours.  = Re-write=20 in perl and run on the db server :).  Change the times it runs = and see=20 if you can recreate the problem.

>>> dgoulet@vicr.com = 02/06/03=20 05:14PM >>>
Dennis,

    I have been = plagued by=20 a similar problem and have a fix if it fits.  Check
the statements = where=20 the 3113 is coming from.  Are they going to a remote
database? = ; And=20 if so, are the tables on the remote database analyzed while the
local = tables=20 are not?  Then the fix is to delete the statistics on the=20 remote
database.  I believe it to be a bug in 8.1.6.

Dick=20= Goulet

____________________Reply Separator____________________
Au= thor:=20 DENNIS WILLIAMS=20 <DWILLIAMS@LIFETOUCH.COM>
Date:      = ;=20 2/6/2003 1:18 PM

I have a developer that wrote a VB program using = ADO,=20 connecting to Oracle
8.1.6 on a Compaq Tru64 server. One program of his = runs=20 for hours each
night, and sometimes receives an ORA-03113 end-of-file = on=20 communication
channel. Not consistently, just sporadically, and at = varying=20 amounts of
time. I have been unable to find anything in the server = logs. We=20 have traced
the program and the error occurs during different SQL = statements.=20 Followed
most of the tips I've located on solving ORA-03113 errors. I = am=20 coming to
the conclusion that maybe the only solution will be to = upgrade=20 Oracle and
hope that solves the problem. Unfortunately we can only = upgrade to=20 Oracle
8.1.7.4. Does anyone have any other ideas? Thanks.

Dennis= =20 Williams
DBA, 40%OCP
Lifetouch, Inc.
dwilliams@lifetouch.com =
--=20
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: = DENNIS=20 WILLIAMS
  INET: DWILLIAMS@LIFETOUCH.COM

Fat City Network=20= Services    -- 858-538-5051 http://www.fatcity.com
San = Diego,=20 California        -- Mailing list and = web=20 hosting=20 services
---------------------------------------------------------------= ------
To=20 REMOVE yourself from this mailing list, send an E-Mail message
to:=20 ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
the = message=20 BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing = list=20 you want to be removed from).  You may
also send the HELP command = for=20 other information (like subscribing).

--
Please see the = official=20 ORACLE-L FAQ: http://www.orafaq.net--=20
Author:
  INET: dgoulet@vicr.com

Fat City Network=20 Services    -- 858-538-5051 http://www.fatcity.com
San = Diego,=20 California        -- Mailing list and = web=20 hosting=20 services
---------------------------------------------------------------= ------
To=20 REMOVE yourself from this mailing list, send an E-Mail message
to:=20 ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
the = message=20 BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing = list=20 you want to be removed from).  You may
also send the HELP command = for=20 other information (like subscribing).

--=_4E113FB2.3F5E4B68-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gene Sais INET: Gsais@co.palm-beach.fl.us Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@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).