Re: how can listener list on two ports for the same db?

From: Suzy Vordos <lvordos_at_qwest.com>
Date: Wed, 29 May 2002 07:48:34 -0800
Message-ID: <F001.0046E3E1.20020529074834@fatcity.com>

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: lvordos_at_qwest.com

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: ListGuru_at_fatcity.com (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).

Received on Wed May 29 2002 - 10:48:34 CDT