Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 3 node RAC listener cross-registration question
3 node RAC listener cross-registration question...
Clients are connecting to the "hostname" of the RAC servers, not the "hostname-vip" - I am thinking this is because the listeners are allowing the public hostname into the list of available hosts that the listeners are providing - I was wondering how I would need to configure the listener to allow clients to connect to the VIPs only and not to the actual host of the public interface. The hostname (not hostname-vip) does not appear in any tnsnames.ora on any client machine so my assumption is the only place the clients could get this information is from the cross-registration of listeners to the pmon of each node...
Notice that out of the 3 nodes, there are 3 connections to the public hostname and 3 to the VIPs... I'm thinking all of the clients should connect to the vips so if they move the client will not experience the delays, etc.
on app1:
$ netstat -a | grep 1521
tcp 0 app1:43448 node1:1521 ESTABLISHED tcp 0 app1:43443 node3:1521 ESTABLISHED tcp 0 app1:43474 node3:1521 ESTABLISHED tcp 0 app1:43478 node1-vip:1521 ESTABLISHED tcp 0 app1:43428 node2-vip:1521 ESTABLISHED tcp 0 app1:43432 node2-vip:1521 ESTABLISHED
app1 is an application server
node1 is one of the 3 nodes in the RAC, same for node2 and node3.
How do I prevent the listener from handing out connections that aren't the VIP for each node?
Linux RHAS4 64bit/Opteron, Oracle 10.2.0.2.
Thanks
-- http://www.freelists.org/webpage/oracle-lReceived on Mon May 08 2006 - 09:36:29 CDT
![]() |
![]() |