Re: end-of-file on communication channel

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=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 - 16:23:17 CST