Re: ORA:03113 End of communication channel

Quinton,

In two of the projects I was involed with, it turned out to be network problem that was causing this error. Twice it was router, and once it was firewall. Although we discovered in one case it was SQL - particularily 'or exists (...' in the where clause.

Kresimir Fabijanic

Quinton McCombs wrote:

> What you are running into is one of Oracle's generic error messages much
> like the ORA-600. This message is saying that the server pocess you
> were connected to has gone away for some reason.
>
> The reason for this error message could be a trigger, it could be caused
> from trying to include too many values in an "in" clause, it could be
> pl/sql code failing.
>
> Oracle support will most likely not be very helpful until you can
> isolate the cause of the problem.
>
> Loh Hun Soo wrote:
> >
> > I am using Oracle8 runs on Window NT 4.0. Once too often this error
> > message props up while we are using application developed with
> > Developer/2000. For too long now we haven't got a clue how to solve
> > it. By the way, even Bronze Support couldn't help.
> >
> > Can anyone please shed some light on us?
Received on Mon Nov 09 1998 - 13:38:31 CET