Re:Trolling for ideas

[Gene Sais]

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.

>>> [EMAIL PROTECTED] 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 <[EMAIL PROTECTED]>
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.
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).