Re: ORA-03113 error

It looks like the OLEDB to SQLNet interface is sometimes a bit flakey. The message denotes that OLEDB can't see the database anymore. You usually see this when e.g. a network problem occurs. I suppose you can simulate this error by performing a query and while it is going unplug your network cable.

Here is what my OraCodes help file explains what the error is. OraCodes can be downloaded for free from http://www.oraxcel.com It contains all the Oracle messages and codes.

ORA-03113 ORA-03113end-of-file on communication channel

Cause:An unexpected end-of-file was processed on the communication channel; bug could not be handled by the SQL*Net (two task) software. This message could occur if the shadow two-task process associated with a SQL*Net connect has terminated abnormally or there is a physical failure of the interprocess communication vehicle (that is, the network or server machine went down).

Action:If this message occurs during a connection attempt, check the setup files for the appropriate SQL*Net driver and confirm SQL*Net software is correctly installed on the server. If the message occurs after a connection is well established and the error is not due to a physical failure, check if a trace file was generated on the server at failure time. Existence of a trace file may suggest an ORACLE internal error that requires the assistance of Worldwide Customer Support.

--
Gerrit-Jan Linker

web:     http://www.oraxcel.com
email:  gjlinker_at_oraxcel.com

Oraxcel: Linking Oracle to Excel
OraCodes: Explaining ORA- error codes
OraSQL: Explaining Oracle SQL syntax
OraDebug: PL/SQL debugger
OraWeb: Oracle access from IE

Dana Jian <dana_jian_at_hotmail.com> wrote in message
news:38f248d1$0$25409_at_news.choice.net...


> Hi,

>

> I got the ORA-03113 error in the application, we're using Oracle8i, OLEDB

> driver and VB.

>

> This error appears sometimes, and other times the system is just running

> fine.

>

> Any idea on this?

>

> Thank a lot for any help!!

>

> Dana

> dana_jian_at_hotmail.com

>

>