Oracle-L: RE: Trolling for ideas

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Fri, 07 Feb 2003 12:07:29 -0800
Message-ID: <F001.005478BA.20030207120729@fatcity.com>

Gene - I asked the network engineer about this. No reported outages. Extremely few errors in his log. We've recreated the problem during the day. Thanks for the ideas, however.

Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Thursday, February 06, 2003 5:04 PM To: Multiple recipients of list ORACLE-L

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_at_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 <DWILLIAMS_at_LIFETOUCH.COM>
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_at_lifetouch.com
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net <http://www.orafaq.net>
--

Author: DENNIS WILLIAMS
INET: DWILLIAMS_at_LIFETOUCH.COM Fat City Network Services -- 858-538-5051 http://www.fatcity.com <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_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).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net <http://www.orafaq.net>
--

Author:
INET: dgoulet_at_vicr.com

Fat City Network Services -- 858-538-5051 http://www.fatcity.com <http://www.fatcity.com>
San Diego, California -- Mailing list and web hosting services

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: DENNIS WILLIAMS
INET: DWILLIAMS_at_LIFETOUCH.COM

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------