Re: ORA-03113: End-of-File on communication channel

Thomas:

There are lots of reasons for the 3113 errors. Check the metalink web site for a bulletin on
dealing with the ORA-03113 error.

Try running the query using sqlplus on the server and see if the problem reccurs.

I have run across the same problem that you describe within sqlplus running Oracle8.0.4.2.1 on HP-UX.
Check your core/user dump destination areas for any trace files and core dumps.
Call Oracle Support and they will arrange to have you ftp the files to their ftp server.

I have observed that the 3113 error can happen on queries that are structured in a particular way that
highlights an Oracle bug of some sort. This error seems to pop up on queries from large tables
If you were to restructure the query (in some cases) the error can be eliminated. (e.g. replace join with correlated sub query, or vice versa).

Make sure you also provide your server parameters:

SVRMGRL>  spool params.out
SVRMGRL>  show parameters
SVRMGRL>  exit;

I would also try, for each table in the from clause: analyze table <table_name in query> delete statistics; and then re-execute the query.

-dave fischer / Oracle Certified DBA
davefischer_at_home.com

Thomas Tsang wrote in message <368F8CFD.8E47AA0_at_hkc.net>...
>Hi all,
>
> I am currently developing a system using Oracle as the database.
>The development tool is MS Visual Basic 5.0 (SP3) and the Oracle is
>version 8.0.4.0.0 for Windows NT, and I am using the Oracle ODBC Driver
>8.00.400 for connection . However, the system sometimes will product
>the following error:
>
> 40002: S1000: [ORACLE][ODBC][ORA]ORA-03113: End-of-file on
>communication channel
>
> This error occur when the system processes a SQL statement, it can be
>a 'select' or 'update' statement, as there is only very few record in
>the database, but the system still wait a very long time and then
>displays this error, then the connection with the database is closed.
>
> However, the error occurs randomly. For the same statement, the
>error may be generated at the first time, when I close the system and
>re-connect again, there may be no error. And I have run the system in
>difference client pc (win95 and win nt), the same error is still exist.
>
> I am very sure that it is not due to my developing system, but i am
>not know whether there is hardware problem in the server or there is
>system error in the Oracle database. I wonder if the error can not be
>solved after i re-installed the Oracle (I can do so now as it is only
>testing phase for my system, but later I can't).
>
> One important thing is that there is no error in the begining, but
>after I re-installed the Windows NT in the server, this error exists.
>
> Would anyone pls tell me to the reason for this error and how to
>solve it? Thank you in advance!
>
>
>Thomas Tsang
>
Received on Mon Jan 04 1999 - 00:00:00 CET