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

From: Bernard, Gilbert <Gilbert.Bernard_at_caissedesdepots.fr>
Date: Wed, 29 May 2002 01:58:34 -0800
Message-ID: <F001.0046DB37.20020529015834@fatcity.com>

look  

db_name.WORLD =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (COMMUNITY = tcp.world)(PROTOCOL = TCP)(Host =
host_name)(Port = 1521))

(ADDRESS = (COMMUNITY = tcp.world)(PROTOCOL = TCP)(Host =
host_name)(Port = 1526))

(ADDRESS = (COMMUNITY = tcp.world)(PROTOCOL = TCP)(Host =
host_name)(Port = 1555))

    )
    (CONNECT_DATA = (SID = db_name))
  )

-----Message d'origine-----
De: Daiminger, Helmut [mailto:Helmut.Daiminger_at_KirchGruppe.de] Date: mercredi 29 mai 2002 11:28
À: Multiple recipients of list ORACLE-L
Objet: how can listener list on two ports for the same db?

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: Bernard, Gilbert
  INET: Gilbert.Bernard_at_caissedesdepots.fr

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 - 04:58:34 CDT