If this is 8i, the SID_LIST isn't needed. Here's an example of two
listeners (lsnr01 & lsnr02) each listening on a diff port for logical
names:
LSNR01 =
(ADDRESS_LIST =
(ADDRESS= (PROTOCOL= IPC)(KEY=lsnr01))
(ADDRESS= (PROTOCOL= TCP)(Host= kfplcmdb)(Port= 1521))
(ADDRESS= (PROTOCOL= TCP)(Host= kfalcmdb)(Port= 1521))
)
STARTUP_WAIT_TIME_LSNR01 = 0
CONNECT_TIMEOUT_LSNR01 = 10
TRACE_LEVEL_LSNR01 = OFF
LSNR02 =
(ADDRESS_LIST =
(ADDRESS= (PROTOCOL= IPC)(KEY=lsnr02))
(ADDRESS= (PROTOCOL= TCP)(Host= kfplcmdb)(Port= 1526))
(ADDRESS= (PROTOCOL= TCP)(Host= kfalcmdb)(Port= 1526))
)
STARTUP_WAIT_TIME_LSNR02 = 0
CONNECT_TIMEOUT_LSNR02 = 10
TRACE_LEVEL_LSNR02 = OFF
> "Daiminger, Helmut" wrote:
>
> Hi!
>
> We have a db server (in a cluster) with two NICs and two IP-Adresses
> (i.e. logical names in the cluster). How do I configure the listener
> so that it listenes for both logical names of the machine?
>
> LISTCMDB =
> (DESCRIPTION_LIST =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = kfplcmdb)(PORT = 1522))
> )
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = kfalcmdb)(PORT = 1522))
> )
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_CMDB))
> )
> )
> )
>
> SID_LIST_LISTCMDB =
> (SID_LIST =
> (SID_DESC =
> (SID_NAME = PLSExtProc_CMDB)
> (ORACLE_HOME = /cmdb/u0x/u01/app/oracle/product/8.1.7)
> (PROGRAM = extproc)
> )
> (SID_DESC =
> (GLOBAL_DBNAME = CMDB)
> (ORACLE_HOME = /cmdb/u0x/u01/app/oracle/product/8.1.7)
> (SID_NAME = CMDB)
> )
> )
>
> Sitting on our RMAN database machine, pinging kfplcmdb does not work
> but pinging kfalcmdb works fine.
>
> On th emachine to be backed up: why can't I use kfalcmdb in the
> listener.ora file? The listener works fine when using kfplcmdb.
>
> This is 8.1.7 on Solaris 8.
>
> Thanks,
> Helmut
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Suzy Vordos
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
