Re: ORA-03113: end-of-file on communication channel --- what causes it??

Hi Fred:

Indeed this was the case:

On following the server alert log when the select statement was issued, I get:
Thu Dec 2 11:41:02 1999
Errors in file /tmp/ora_17205.trc:
ORA-07445: exception encountered: core dump [11] [0] [0] [0] [] []

SQL> ! oerr ora 7445
07445, 00000, "exception encountered: core dump [%s] [%s] [%s] [%s] [%s] [%s]"

// *Cause: An OS exception occurred which should result in the creation of a
//         core file.  This is an internal error.
// *Action: Contact your customer support representative.

SQL> Core file is generated by Oracle indeed, but it is of not much use to me since I can't read it.

Regards,
Cheong

Fred Petillot <fpetillo_at_fr.oracle.com> wrote in message <38465BCE.A7978962_at_fr.oracle.com>...
> 3113 is usually the client response to server's 7445 or 600. You should
have a
> look at
> your alert.log, which probably has one of those errors listed. If this is
the
> case, it
> will point to a trace file containing detailed trace of the error. I might
be
> able to
> help you.
>
>
Received on Thu Dec 02 1999 - 20:01:33 CST