Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Why do we have a Virtual IP (VIP) in 10g? Why does it just return a dead connection when its primary node fails?

April 26, 2017connection dead fails IP Node primary Return VIP virtual

0

Posted

Why do we have a Virtual IP (VIP) in 10g? Why does it just return a dead connection when its primary node fails?

1 Answer

0

Posted

Its all about availability of the application.When a node fails, the VIP associated with it is automatically failed over to some other node. When this occurs, the following things happen.(1) VIP detects public network failure which generates a FAN event.(2) the new node re-arps the world indicating a new MAC address for the IP.(3) Old clients subscribing to FAN immediately receive ORA-3113 error or equivalent. Those not subscribing to FAN will eventually time out.(4) New connection requests rapidly traverse the tnsnames.ora address list skipping over the dead nodes, instead of having to wait on TCP-IP timeoutsWithout using VIPs or FAN, clients connected to a node that died will often wait a 10 minute TCP timeout period before getting an error.As a result, you don’t really have a good HA solution without using VIPs and FAN.