Re: Configuring multiple listeners/ports for one RAC database

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Wed, 3 Jun 2015 12:14:22 -0500
Message-Id: <5DC1AD5A-CBC9-4E30-A078-BA5FE97B9454_at_gmail.com>

You just do something like this if you really want to use multiple ports rather than multiple services:  

Tnsnames:
LISTENER_EG =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = vmrh65node1)(PORT = 1520))
(ADDRESS = (PROTOCOL = TCP)(HOST = vmrh65node1)(PORT = 1522))
(ADDRESS = (PROTOCOL = TCP)(HOST = vmrh65node1)(PORT = 1523))
(ADDRESS = (PROTOCOL = TCP)(HOST = vmrh65node1)(PORT = 1524))
(ADDRESS = (PROTOCOL = TCP)(HOST = vmrh65node1)(PORT = 1525))
)  

Listener.ora:
LISTENER_EG =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1522))
(ADDRESS = (PROTOCOL = TCP)(HOST = vmrh65node1)(PORT = 1520))
(ADDRESS = (PROTOCOL = TCP)(HOST = vmrh65node1)(PORT = 1522))
(ADDRESS = (PROTOCOL = TCP)(HOST = vmrh65node1)(PORT = 1523))
(ADDRESS = (PROTOCOL = TCP)(HOST = vmrh65node1)(PORT = 1524))
(ADDRESS = (PROTOCOL = TCP)(HOST = vmrh65node1)(PORT = 1525))
)
 Lsnrctl start listener_eg
SQL> Alter system set local_listener=listener_eg;

Sent from my iPad

> On Jun 3, 2015, at 10:56 AM, Sundar Mahadevan <sundarmahadevan82_at_gmail.com> wrote:
> 
> Hi All,
> Greeting. I am trying to configure multiple listeners (atleast 4) for one RAC database. The requirement is that 4 applications/users will be configured to use different listeners/ports and I must be able to bring down one listener/port and the others will still be able to function. I read oracle support note 1585786.1 (Note 5 on Adding additional node listeners to the system using different ports) which suggests to add a node listener on a different port and set the local listener. If i set local_listener to use port 1522 (lets assume current is 1521) and register the database with the listener on port 1522, will i still be able to connect to 1521? And can i do this for 4 listeners and be able to achieve my requirement. Many thanks for your time and help. Appreciate it.

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Jun 03 2015 - 19:14:22 CEST