Re: end-of-file on communication channel

On Wed, 24 Mar 1999 10:56:22 -0800, Neelesh Jain <neelesh_at_sanjose.usweb.com> wrote:

>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
>

Hi Neelesh,

In case you run into the same problem again, try the following. Open sqlnet.ora on the server and add or change: sqlnet.expire_time = 0
This turns off the dead connection detection, which is a little buggy. The dead connection detection sends a message to the client every sqlnet.expire_time minutes. When it doesn't get a message back, it assumes that the client is dead and ends the communication channel.

Hth,

Gert. Received on Sat Mar 27 1999 - 10:28:03 CST