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

From: Tim Smith <timasmith_at_hotmail.com>
Date: 22 Jan 2002 12:00:20 -0800
Message-ID: <a7234bb1.0201221200.5216069d@posting.google.com>

Hi, I get an error using sqlplus user/pass_at_dbinst - though it is fine accessing the database directly. May be that we have two versions of Oracle and the listener is on an older version.

Any ideas/help would be gratefully received.

Here are the details:

Platform: SunOS 5.6 Generic_105181-07 sun4u sparc SUNW,Ultra-4 Oracle Version: 8.1.7

                The listener is running under 7.3.2

Logged in under 8.1.7 user
$sqlplus user/pass_at_mydb
SQL*Plus: Release 8.1.7.0.0 - Production on Tue Jan 22 14:45:05 2002 ERROR:
ORA-03113: end-of-file on communication channel

Logging in without the listener works fine: $sqlplus user/pass

lsnrctl stat
...
  mydb has 1 service handler(s) ...
listener.ora
LISTENER =
  (ADDRESS_LIST =

        (ADDRESS = 


          (COMMUNITY = )

          (PROTOCOL = TCP)

          (HOST = genetics)

          (Port = 1521)

        )
        (ADDRESS = 


          (COMMUNITY = )

          (PROTOCOL = TCP)

          (HOST = genetics)

          (Port = 1526)

        )

  )
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 0
TRACE_LEVEL_LISTENER = OFF
LOG_DIRECTORY_LISTENER = /export/home/oracle SID_LIST_LISTENER =
...

    (SID_DESC =

     (SID_NAME = heat)
     (ORACLE_HOME = /mydisk/app/oracle/product/8.1.7)

    )
...

tnsnames.ora
mydb=

   (DESCRIPTION =

     (ADDRESS_LIST =
         (ADDRESS = 
           (PROTOCOL = TCP)
           (Host = genetics)
           (Port = 1521)
         )
     )
     (CONNECT_DATA = 
        (SID = mydb)
     )

   )

thanks!

Tim Received on Tue Jan 22 2002 - 14:00:20 CST