Re: end-of-file on communication channel

Well, looks like my problem is temporarily resolved. I dont get the end-of-file on communication channel error after all the oracle<SID> processes were killed. sparc-db% ps -ef | grep oracle<SID> | grep -v grep   oracle 5127 1 0 10:50:18 ? 0:01 oracle<SID> (LOCAL=NO)

Thanks everybody for your help.

Neelesh

Neelesh Jain wrote:

> 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:56:22 CST