Re: Oracle 8i Listener and Oracle 8i Listener

From: George Barbour <gbarbour_at_csc.com>
Date: Thu, 13 Jun 2002 16:20:17 +0100
Message-ID: <3d08b7b3$1@pull.gecm.com>

"Loadrunner" <load_at_runner.com> wrote in message news:1023963786.10147.0.nnrp-13.c2d92da9_at_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.
>

I think you need another port address identified for the SALES database. e.g. add the line.

    (DESCRIPTION =

      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = dboracle)(PORT = 1521))
     )

I have/had Oracle 9i listener working for O8.1.5, O8.1.7 * O9i. George Barbour. Received on Thu Jun 13 2002 - 10:20:17 CDT