Re: Regarding RAC vip failover and tnsnames entry

From: Syed Jaffar Hussain <sjaffarhussain_at_gmail.com>
Date: Mon, 11 May 2009 10:08:30 -0700
Message-ID: <97b7fd2f0905111008o6fb1334dt4ca39fa373c73b12_at_mail.gmail.com>

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_at_gmail.com> 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."

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

Received on Mon May 11 2009 - 12:08:30 CDT