Regarding RAC vip failover and tnsnames entry

  • From: sanjeev m <sanjeevorcle@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Mon, 11 May 2009 09:39:31 -0700

All,

We have two node RAC environment with the applications connections going to
first node.
(No reference to the second node in tnsnames.ora). We are not using load
balancing or failover.

If case of nic failure on first node CRS on the other node will failover the
vip (raising event and bringing up the resource online on second node)
and re-arp the machine address on the network.

Question:

(a) Existing connections: They will get an errors saying the instance is
down.
(b) New connections:  They will be able to connect to vip on second node
(with reference to firsthostname-vip entry in tnsnames.ora).

Are both (a) and (b) true. Is it required to have second node entry in
tnsnanames.ora for connection to work after vip failover.

Regards

Other related posts: