Re: end-of-file on communication channel

Thanks Kelley,
Well, everytime I get the end-of-file on communication error one of the shadow processes dies.
sparc-db% ps -ef | grep oracleAV | grep -v grep | wc -l

      14
..
..
sparc-db% ps -ef | grep oracleAV | grep -v grep | wc -l

       5
sparc-db% ps -ef | grep oracleAV | grep -v grep | wc -l

       4

Also, there were no trace files generated in $ORACLE_BASE/admin/<SID>/bdump.
But there was a memory dump in $ORACLE_BASE/admin/<SID>/udump, looking at which I get no clues as to why the shadow process should die every alternate time I try to connect to the server.

Neelesh

Kelly Young wrote:

> Neelesh Jain wrote:
> >
> > Hi,
> > I have been having problems connecting to the oracle server
> > at random intervals.
> > I get the
> > ERROR: ORA-03113: end-of-file on communication channel
> > at the client machine. Does anybody have any idea as to
> > how I could resolve this?
> (SNIP)
>
> This is an indication that the server process encountered some kind of
> an error. There should have been a trace file produced in
> $ORACLE_BASE/admin/XYZ/bdump. If so, check that file for a clue as to
> what's happening.
> --
> Kelly Young
> Maricopa Community Colleges
> young_at_maricopa.edu
Received on Wed Mar 24 1999 - 12:35:20 CST