Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: end-of-file on communication channel

Re: end-of-file on communication channel

From: Neelesh Jain <neelesh_at_sanjose.usweb.com>
Date: Wed, 24 Mar 1999 10:00:08 -0800
Message-ID: <36F92827.8BE274DC@sanjose.usweb.com>


Thanks Mick,
I tried increasing the swap space with the same result. sparc-db% prtconf | head -2
System Configuration: Sun Microsystems sun4m Memory size: 32 Megabytes
sparc-db% swap -l

swapfile             dev  swaplo blocks   free
/dev/dsk/c0t3d0s4   32,28      8  82648  58312
/swap/swap01          -        8  10232   6040
/swap/swap02          -        8  10232   5072
/swap/swap03          -        8  40952  37696
sparc-db% ps -ef | grep oracleXYZ | grep -v grep | wc -l
      14

Now the probablity that I connect to the server has decreased to 50%.

Neelesh.

MickM wrote:

> Hi,
>
> I had a similar problem sometime ago.
>
> A reason for this to occur is when the server shadow process dies.
> If you start an sqlplus session, the server will have some process
> called ;
> oracleSID (DESCRIPTION=(......etc....)
>
> If you kill this process and then issue some sql from your client
> sqlplus session you will receive the 3113 error.
>
> For some reason your shadow process is dying. A possible cause of this
> is not having enough swap space. I did have several instances on the
> same box and memory was limited. We increased our swap space from (2 x
> physical RAM) to (3 x physical RAM) and the problem rarely occured
> again.
>
> Hope this helps
>
> Mick
>
> 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? Here's how I did the installation:
> >
> > 1. Installed Oracle 7.3.3.0 on the sparc-db solaris server.
> > The list of products that were installed are:
> > a. Oracle7 Server (RDBMS) 7.3.3.0.0
> > b. PL/SQL V2 2.3.3.0.0
> > c. SQL*Plus 3.3.3.0.0
> > d. SQL*Net (v2) 2.3.3.0.0
> > e. TCP/IP Protocol Adapter (V2) 2.3.3.0.0
> > 2. The following products were installed on the sparc-cm
> > client machine:
> > a. SQL*Net (v2) 2.3.3.0.0
> > b. SQL*Plus 3.3.3.0.0
> > c. TCP/IP Protocol Adapter (V2) 2.3.3.0.0
> > 3. Started the XYZ database on the server
> > 4. The listener.ora file was stored in /var/opt/oracle
> > directory of server and $ORACLE_HOME/network/admin directory
> > of the client ( listener.ora file is attached )
> > 5. Created the sqlnet.ora and tnsnames.ora in
> > $ORACLE_HOME/network/admin of both the server
> > and client machines.
> > 6. Started the listener on port 1521 of the server
> > using $ORACLE_HOME/bin/lsnrctl start
> > 7. Executing the sqlplus system/manager_at_XYZ.world
> > on the client machine gives the following error
> > during 1 in 3 attempts to connect to the server:
> > ERROR: ORA-03113: end-of-file on communication channel
> >
> > PS: It does succeed to connect to the server on a
> > successive attempt.
> > Here's the list of attempts and the client fails to
> > connect almost 1 in 3 times the connection is attempted.
> > ---begin
> > sparc-cm% ./sqlplus system/manager_at_XYZ.world
> >
> > SQL*Plus: Release 3.3.3.0.0 - Production on Mon Mar 22 10:23:22 1999
> >
> > Copyright (c) Oracle Corporation 1979, 1996. All rights reserved.
> >
> > Connected to:
> > Oracle7 Server Release 7.3.3.0.0 - Production Release
> > PL/SQL Release 2.3.3.0.0 - Production
> >
> > SQL> exit
> > Disconnected from Oracle7 Server Release 7.3.3.0.0 - Production Release
> > PL/SQL Release 2.3.3.0.0 - Production
> > sparc-cm% ./sqlplus system/manager_at_XYZ.world
> >
> > SQL*Plus: Release 3.3.3.0.0 - Production on Mon Mar 22 10:23:46 1999
> >
> > Copyright (c) Oracle Corporation 1979, 1996. All rights reserved.
> >
> > Connected to:
> > Oracle7 Server Release 7.3.3.0.0 - Production Release
> > PL/SQL Release 2.3.3.0.0 - Production
> >
> > SQL> exit
> > Disconnected from Oracle7 Server Release 7.3.3.0.0 - Production Release
> > PL/SQL Release 2.3.3.0.0 - Production
> > sparc-cm% ./sqlplus system/manager_at_XYZ.world
> >
> > SQL*Plus: Release 3.3.3.0.0 - Production on Mon Mar 22 10:23:50 1999
> >
> > Copyright (c) Oracle Corporation 1979, 1996. All rights reserved.
> >
> > ERROR: ORA-03113: end-of-file on communication channel
> >
> > Enter user-name:
> > ----end
> >
> > listener.ora:
> > ---------
> >
> > LISTENER=
> > (ADDRESS_LIST=
> >
> > (ADDRESS=
> > (PROTOCOL=tcp)
> > (Host = sparc-db)
> > (Port=1521)
> > )
> > )
> >
> > STARTUP_WAIT_TIME_LISTENER = 0
> > CONNECT_TIMEOUT_LISTENER = 0
> >
> > SID_LIST_LISTENER=
> > (SID_LIST=
> > (SID_DESC=
> > (SID_NAME=XYZ)
> > (ORACLE_HOME=/data/oracle)
> > (PRESPAWN_MAX=99)
> > (PRESPAWN_LIST=
> > (PRESPAWN_DESC=
> > (PROTOCOL=tcp)
> > (POOL_SIZE=30)
> > (TIMEOUT=0)
> > )
> > )
> > )
> > )
> >
> > TRACE_LEVEL_LISTENER = OFF
> > PASSWORD_LISTENER = (4B1B9D23CBF62170)
> >
> > sqlnet.ora:
> > --------
> > TRACE_LEVEL_CLIENT = OFF
> > sqlnet.expire_time = 60 # The number of seconds between client
> > checks.
> > names.default_domain = world
> > name.default_zone = world
> >
> > tnsnames.ora:
> > -----------
> > XYZ.world =
> > (DESCRIPTION =
> > (ADDRESS_LIST =
> > (ADDRESS =
> > (COMMUNITY = tcp.world)
> > (PROTOCOL = tcp)
> > (Host = sparc-db)
> > (Port = 1521)
> > )
> > )
> > (CONNECT_DATA = (SID = XYZ)
> > )
> > )
> >
> > Thanks,
> > Neelesh
Received on Wed Mar 24 1999 - 12:00:08 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US