Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Any way to run more than listener on the same port?

RE: Any way to run more than listener on the same port?

From: <JayMiller_at_TDWaterhouse.com>
Date: Tue, 5 Apr 2005 15:59:15 -0400
Message-ID: <5B257A26B4845C469B87871B6CEFE507015EAC22@usnjc04wmx003.tdwaterhouse.com>


Thanks very much, I only just got caught up on this thread.

This example creates multiple listeners on the same port using the same listener.ora file. Can it be done with multiple listener.ora files (we have a separate binary installation for each instance to allow for asynchronous upgrades)?

Thanks,
Jay Miller
Sr. Oracle DBA

-----Original Message-----
From: Christo Kutrovsky [mailto:kutrovsky.oracle_at_gmail.com] Sent: Wednesday, March 23, 2005 3:52 PM
To: oracle-l_at_freelists.org
Subject: RE: Any way to run more than listener on the same port?

I am copy/pasting this from the archives:

>For portability reasons our Unix SAs would like us to run one listener /
>instance on the same port of each server.

Yes you can have multiple listeners listening on different VIPs on the same port.

To configure, just edit your listener.ora file and edit the ADDRESS_LIST part of each listener definition, and set your "HOST=<ip>" to the VIPs that your administrators are giving.

Example listener.ora:
LISTENER_DB1 =

  (ADDRESS_LIST =
        (ADDRESS= (PROTOCOL= IPC)(KEY= PNPKEY1))
        (ADDRESS= (PROTOCOL= TCP)(Host= 10.5.5.1)(Port= 1521))
  )

LISTENER_DB2 =

  (ADDRESS_LIST =
        (ADDRESS= (PROTOCOL= IPC)(KEY= PNPKEY2))
        (ADDRESS= (PROTOCOL= TCP)(Host= 10.5.5.2)(Port= 1521))
  )

LISTENER_DB3 =

  (ADDRESS_LIST =
        (ADDRESS= (PROTOCOL= IPC)(KEY= PNPKEY3))
        (ADDRESS= (PROTOCOL= TCP)(Host= 10.5.5.3)(Port= 1521))
  )

But with dynamic registration you dont really need to do "1 listener per database". You can have 1 listener listen on all ips, and let each database register with the listener as it starts/stops.

--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Apr 05 2005 - 16:03:33 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US