Unable to start 2nd db listener

From: <lazyboy_2k_at_yahoo.com>
Date: 22 Jan 2007 16:15:03 -0800
Message-ID: <1169511303.349362.226610@51g2000cwl.googlegroups.com>

Hi All,

I have installed 2 databases (9i & 10g) & configured 9i & 10g listeners on a 2 node Veritas clusters which are installed Sol 10. The 10g listener starts up & shutdowns w/o any problem, however, I'm unable to startup the 9i listener. I have already tried to replace a virtual name to a virtual ip, but it still doesn't work correctly. Does anyone know what else do I need to configure in order to get an 9i listener to work? Also as you notice, it keeps pointing over to my oracle 10g & I don't understand why? Any helps/suggestions are appreciated.

$ cat listener.ora
ora9idb_lsnr =

        (ADDRESS_LIST=
                (ADDRESS=(PROTOCOL=tcp)(HOST=ora9idb_lsnr)(PORT=1521))
        )

SID_LIST_ora9idb_lsnr =
      (SID_LIST =
                (SID_DESC =


                        (GLOBAL_DBNAME = ora9idb)

                        (ORACLE_HOME = /oraclesw/product/9.2.0.1.0)

                        (SID_NAME = ora9idb)

                )
        )

$ cat tnsnames.ora
ora9idb =

        (DESCRIPTION =
               (ADDRESS_LIST =


                        (ADDRESS = (PROTOCOL = TCP)(HOST =

ora9idb_lsnr)(PORT = 1521))
                )
                (CONNECT_DATA =


                        (SID = ora9idb)

               )
         )

$ lsnrctl start

LSNRCTL for Solaris: Version 9.2.0.1.0 - Production on 22-JAN-2007 15:00:52

Starting /oraclesw/product/9.2.0.1.0/bin/tnslsnr: please wait...

TNSLSNR for Solaris: Version 9.2.0.1.0 - Production System parameter file is
/oraclesw/product/10.2.0/network/admin/listener.ora Log messages written to
/oraclesw/product/9.2.0.1.0/network/log/listener.log Listening on:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=test-phys1)(PORT=1521)))

Connecting to (ADDRESS=(PROTOCOL=tcp)(PORT=1521)) STATUS of the LISTENER

Alias                     LISTENER
Version                   TNSLSNR for Solaris: Version 9.2.0.1.0 -
Production
Start Date                22-JAN-2007 15:00:52
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  OFF
SNMP                      OFF

Listener Parameter File
/oraclesw/product/10.2.0/network/admin/listener.ora Listener Log File
/oraclesw/product/9.2.0.1.0/network/log/listener.log Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=test-phys1)(PORT=1521))) The listener supports no services
The command completed successfully

Any helps are appreciated.

Thx,
-Chris Received on Mon Jan 22 2007 - 18:15:03 CST