ORA-03113 end of file on communication channel

  • From: "Craig Healey" <c.healey@xxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 30 Mar 2004 15:41:08 +0100

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
-----------------------------------------------------------------

Other related posts: