Oracle 8i Listener and Oracle 8i Listener

From: Loadrunner <load_at_runner.com>
Date: Thu, 13 Jun 2002 11:25:27 +0100
Message-ID: <1023963786.10147.0.nnrp-13.c2d92da9@news.demon.co.uk>

I have a W2K Server with Oracle 8.1.7 installed and I have also installed Oracle 9.0.1 on to this machine.

I have two listeners now, one for Oracle 8i on port 1521 and one for Oracle 9i on port 1522.

Is it possible to have the Oracle 9i listener listen for connections to Oracle 8i databases?

Below is the listener.ora file I have for the Oracle 9i listener.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
(ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = TCP)(HOST = dboracle)(PORT = 1522))
      )

    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = d:\oracle\ora90)
(PROGRAM = extproc)

    )
    (SID_DESC =
(GLOBAL_DBNAME = SALES)
(ORACLE_HOME = c:\oracle\ora81)
(SID_NAME = SALES)

    )
  )

When I try to connect to the SALES database I get a Ora-12541 TNS: No listener error message. Received on Thu Jun 13 2002 - 05:25:27 CDT