887400 wrote:It cannot fail over. It is static.
How regular host ip address differs from VIP ??
887400 wrote:Just to give you clear answers:
Hi Billy and All ,
I am replying too late. sorry for that .I am still not geeing clear picture on VP
" A virtual address is just that - virtual. It can also exist on another node in the cluster, as its "owner" node is not up and running. So this node services that virtual IP until the owner is able to "reclaim ownership" of that virtual IP"
2 node RAC 10g R2 (so no SCAN)
Let say host 1 : abc.lmn.com ;
Host 1 ip: let say 18.104.22.168 ; and vip 1 as abc.lmn-vip.com-> 22.214.171.124
host 2 : efg:xyz.com
with IP 126.96.36.199 and vip 2 as efg.xyz-vip.com -> 188.8.131.52 ;
The ip and VIp s as just for example only.i did not follow any standard conventions.
Scenario : client tried to connect to instance and lets assume host 1 is down so host 1 (abc.lmn.com ) cannot serve the client request.
So the connection should fail over to host 2. And host 1 can not fail over as its already down .
And VIP 1 is the address assigned to physical host 1.
MY Question is : as the physical host 1 itself is down how the VIP 1 that is assigned to host 1 helps in fail over.
I hope your next reply will clarify all my doubts.
user13086932 wrote:If you are using only one VIP Address the connection will not failover to another node, because your connecting string does not know if another VIP Adress exists.
Just have one more doubt -
In the above scenario assume user is connecting to node 1 with a tns entry for node-1 only there is no mentioned for node-2 in the tns entry. Will then be user able to connect to node -2 whenever node -1 is down ?