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

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_at_tdwaterhouse.com <JayMiller_at_tdwaterhouse.com> 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_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
>

-- 
Christo Kutrovsky
Database/System Administrator
The Pythian Group
--
http://www.freelists.org/webpage/oracle-l