Sanjeev, When a node fails, the VIP associated with failed node is automatically fail over to one of other nodes exists in the cluster. The existing connections will typically receive ORA-3113 errors and the new connections using address list will select the next entry in the list. On Mon, May 11, 2009 at 9:39 AM, sanjeev m <sanjeevorcle@xxxxxxxxx> wrote: > 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 > -- Best Regards, Syed Jaffar Hussain Oracle Certified Master (10g) http://www.oracle.com/technology/ocm/shussain.html Oracle ACE http://apex.oracle.com/pls/otn/f?p=19297:4:1579866181463918::NO:4:P4_ID:126 OCP 8i,9i & 10g DBA RAC Certified Expert Official Oracle RAC SIG Representative for Saudi Arabian region ( http://www.oracleracsig.org/) I blog at http://jaffardba.blogspot.com/ -------------------- "Winners don't do different things. They do things differently."