end-of-file on communication channel

From: Neelesh Jain <neelesh_at_sanjose.usweb.com>
Date: Tue, 23 Mar 1999 09:13:12 -0800
Message-ID: <36F7CBA7.FD412C07@sanjose.usweb.com>

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:
2. Oracle7 Server (RDBMS) 7.3.3.0.0
3. PL/SQL V2 2.3.3.0.0
4. SQL*Plus 3.3.3.0.0
5. SQL*Net (v2) 2.3.3.0.0
6. TCP/IP Protocol Adapter (V2) 2.3.3.0.0
7. The following products were installed on the sparc-cm client machine:
8. SQL*Net (v2) 2.3.3.0.0
9. SQL*Plus 3.3.3.0.0
10. TCP/IP Protocol Adapter (V2) 2.3.3.0.0
11. Started the XYZ database on the server
12. 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 )
13. Created the sqlnet.ora and tnsnames.ora in $ORACLE_HOME/network/admin of both the server and client machines.
14. Started the listener on port 1521 of the server using $ORACLE_HOME/bin/lsnrctl start
15. 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 - 11:13:12 CST