RE: ORA-03113 end of file on communication channel
- From: DENNIS WILLIAMS <DWILLIAMS@xxxxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 30 Mar 2004 08:57:56 -0600
Craig
You have my total sympathy. I'm hoping you get some magical replies so
and if you do I'll be saving those replies myself. You might try turning on
tracing on the client. I believe (haven't tried this myself) that if you
have a sqlnet.ora file on the client, you can set trace_level_client to turn
on tracing. The reason that server side tracing often doesn't help much is
that from the perspective of the server the client just never showed up
again.
Other things to consider are just randomly changing stuff (one thing at a
time) like Oracle client version.
The other thing you should consider is to start preparing others for the
fact that you may never solve this problem, or certainly won't solve it
easily. Press the Microsoft developers for whatever they can do.
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams@xxxxxxxxxxxxx
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Craig Healey
Sent: Tuesday, March 30, 2004 8:41 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: ORA-03113 end of file on communication channel
Any help would be appreciated.
Oracle 8.1.7 on Windows 2000 Server.
We have a complex process here, written in VB. It takes about 4 hours to
run. Last week it crashed with ORA-03113 showing on the user's screen, but
no trace or log files. It's crashed twice today, again with no files
generated. This is a major process and I'm under pressure to come up with a
solution. I've googled, and checked Metalink, but the error is so general
that without an error file I don't know where to start, other than blindly
applying "solutions" and hoping one works. I tried tracing the session, but
I ended up with 5Mb of FETCH/EXEC in a cursor loop within seconds. There is
a lot of VB code, cursors and temporary tables used, and it's politically
difficult to re-write. Anyone have any idea where I can start looking for
the problem?
Craig Healey
****************************************************************************
*********************
DISCLAIMER
The information on this e-mail is confidential and may be legally
privileged. It is intended
solely for the addressee and others authorised to receive it. If you are not
the intended
recipient, any disclosure, copying, distribution or action taken in reliance
on its contents
is prohibited and may be unlawful.
Any views or opinions expressed in this message are those of the individual
sender.
No contract may be construed by this e-mail.
NOTIFICATION WITH REGARD TO PRIVACY
Every E-mail in and out of the HHS Domain passes through a moderator. Any
email
Quarantined within that checker will be subject to scrutiny and may be
investigated
further in the interest of protecting the everyday activities of this
company.
Any queries regarding this message please notify
system.administrator@xxxxxxxxxx
Swept by MIMESweeper for the presence of computer viruses
(www.mimesweeper.com)
****************************************************************************
******************
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
