Re: Any way to run more than listener on the same port?
- From: Christo Kutrovsky <kutrovsky.oracle@xxxxxxxxx>
- To: "JayMiller@xxxxxxxxxxxxxxxx" <JayMiller@xxxxxxxxxxxxxxxx>
- Date: Wed, 6 Apr 2005 09:20:28 -0400
Sure you can.
Keep in mind that each database must register with the correct
listener. So you have 2 options:
- define them with SID_LIST...
- use LOCAL_LISTENER database parameter to specific which listener to
use to register.
Christo
On Apr 5, 2005 3:59 PM, JayMiller@xxxxxxxxxxxxxxxx
<JayMiller@xxxxxxxxxxxxxxxx> wrote:
> 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@xxxxxxxxx]
> Sent: Wednesday, March 23, 2005 3:52 PM
> To: oracle-l@xxxxxxxxxxxxx
> 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.
> --
> //www.freelists.org/webpage/oracle-l
>
--
Christo Kutrovsky
Database/System Administrator
The Pythian Group
--
//www.freelists.org/webpage/oracle-l
Other related posts:
