Re: end-of-file on communication channel

From: Neelesh Jain <neelesh_at_sanjose.usweb.com>
Date: Tue, 23 Mar 1999 15:19:21 -0800
Message-ID: <36F82178.187A4A24@sanjose.usweb.com>

Thanks Sybrand for the respone.
I have changed the listener.ora to have the IPC section and am still getting the same error. I have been trying to do a loopback test by using the sqlplus on the same server.

sparc-db% ./lsnrctl start

LSNRCTL for Solaris: Version 2.3.3.0.0 - Production on 23-MAR-99 14:49:03

Starting /data/oracle/bin/tnslsnr: please wait...

TNSLSNR for Solaris: Version 2.3.3.0.0 - Production System parameter file is /var/opt/oracle/listener.ora Log messages written to /data/oracle/network/log/listener.log Listening on: (ADDRESS=(PROTOCOL=ipc)(DEV=10)(KEY=XYZ)) Listening on: (ADDRESS=(PROTOCOL=tcp)(DEV=13)(HOST=sparc-db)(PORT=1521))

Connecting to (ADDRESS=(PROTOCOL=ipc)(KEY=XYZ)) STATUS of the LISTENER

Alias                     LISTENER
Version                   TNSLSNR for Solaris: Version 2.3.3.0.0 - Production

Start Date                23-MAR-99 14:49:07
Uptime                    0 days 0 hr. 0 min. 14 sec
Trace Level               off
Security                  OFF
SNMP                      OFF
Listener Parameter File   /var/opt/oracle/listener.ora
Listener Log File         /data/oracle/network/log/listener.log
Services Summary...
  XYZ            has 31 service handler(s)

The command completed successfully
sparc-db% ./sqlplus system/manager_at_XYZ.world

SQL*Plus: Release 3.3.3.0.0 - Production on Tue Mar 23 15:14:37 1999

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-db% ./sqlplus system/manager_at_XYZ.world

SQL*Plus: Release 3.3.3.0.0 - Production on Tue Mar 23 15:14:45 1999

ERROR: ORA-03113: end-of-file on communication channel

Enter user-name: ^D
sparc-db% ./sqlplus system/manager_at_XYZ.world

SQL*Plus: Release 3.3.3.0.0 - Production on Tue Mar 23 15:14:53 1999

ERROR: ORA-03113: end-of-file on communication channel

Enter user-name:

Neelesh

Sybrand Bakker wrote:

> Hi Neelesh
>
> The strange thing here is the IPC section is missing in your listener.ora.
> I have a feeling your listener crashes.
> From the top of my head the IPC section should be
> address = (protocol=ipc)(key=<sid of database>).
> It should be included in the address list section.
> The other files seem OK.
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
>
> 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=ipc)
(KEY=XYZ)
)

>
> > (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 Tue Mar 23 1999 - 17:19:21 CST