One Listener for two differerent oracle home

From: Gabriele Lamon <g.lamon.UGO_at_mcg-econ.it>
Date: Thu, 25 Sep 2003 16:31:31 +0200
Message-ID: <bkutp0$r30$1@grillo.cs.interbusiness.it>

Is it possible to use the listener of the Oracle9iR2 (9.2.0.4.0) database with another database in another ORACLE_HOME with different version (9.0.2.0.4)?
I've tryed this configuration but with the second db I always get:

ERROR:
ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor

listener.ora
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
(ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )


      (ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = TCP)(HOST = oraclex.mcg-econ.it)(PORT =
1521))
      )

    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /opt/oracle/DataBase/DBS/9.2.0.1.0)
(PROGRAM = extproc)

    )
    (SID_DESC =
(GLOBAL_DBNAME = iasdb.oraclex.mcg_econ.it)
(ORACLE_HOME = /opt/oracle/iAS/9.0.2.0.1)
(SID_NAME = iasdb)

    )
    (SID_DESC =
(GLOBAL_DBNAME = econ3k.oraclex.mcg_econ.it)
(ORACLE_HOME = /opt/oracle/DataBase/DBS/9.2.0.1.0)
(SID_NAME = econ3k)

    )
  )

Ni hao, Lelle. Received on Thu Sep 25 2003 - 09:31:31 CDT