Sqlplus using Listener - ORA-03113: end-of-file on communication channel

From: Tim Smith <timasmith_at_hotmail.com>
Date: 8 Jan 2002 12:19:24 -0800
Message-ID: <a7234bb1.0201081219.5433c8ed@posting.google.com>

Hi,
  I have a Solaris (5.6) with two versions of Oracle: 7.3.2 and 8.1.7

A 8.1.7 database was recently added.
I can access the database instance via sqlplus user/pass or svrmgrl but using sqlplus user/pass_at_mydb produces: ORA-03113: end-of-file on communication channel

The error is produce whether I am logged in as an Oracle 8i user or Oracle73

I can access all 7.3 instances via the listener logged in as either of the users.

tnsnames.ora 7.3 or 8i
MYDB =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = myhost)(PORT = 1521))     )
    (CONNECT_DATA =
      (SERVICE_NAME = mydb)
    )
  )

listener.ora 7.3
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_LIST =
    (SID_DESC =

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

    )
  ) Received on Tue Jan 08 2002 - 14:19:24 CST