Regarding RAC vip failover and tnsnames entry

From: sanjeev m <sanjeevorcle_at_gmail.com>
Date: Mon, 11 May 2009 09:39:31 -0700
Message-ID: <bbe2da7e0905110939k1f668db4h769a4c713dfbd48d_at_mail.gmail.com>



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

--
http://www.freelists.org/webpage/oracle-l
Received on Mon May 11 2009 - 11:39:31 CDT

Original text of this message