Re: Question about VIP failover and accepting connections

From: Riyaj Shamsudeen <riyaj.shamsudeen_at_gmail.com>
Date: Fri, 28 Feb 2014 09:36:52 -0800
Message-ID: <CAA2DszzETTV9E2o7sm1NioratD9BP17gy=GmnHJaAK_EN_8v2A_at_mail.gmail.com>

AFAIK, there is no technical reason for not adding the VIP to the listener end-point, only a practical reason: Let's say VIP is added to the listener end point, and the connections flow through that listener and VIP. Then, at fail-back time, VIP need to be moved back to the original node, hence, existing connections through the VIP must be severed. So, there will be double connection failures, and the design seems to protect the double failures.

Every other reason I can think of can be mitigated easily, as the VIP failover is handled by the Grid Infrastructure.

( However, take my reasoning with a grain of salt, original designers may have something else in mind.)

Cheers

Riyaj Shamsudeen
Principal DBA,
Ora!nternals - http://www.orainternals.com - Specialists in Performance, RAC and EBS
Blog: http://orainternals.wordpress.com/ Oracle ACE Director and OakTable member <http://www.oaktable.com/>

Co-author of the books: Expert Oracle
Practices<http://tinyurl.com/book-expert-oracle-practices/> , Pro Oracle SQL, <http://tinyurl.com/ahpvms8> <http://tinyurl.com/ahpvms8>Expert
RAC Practices 12c. <http://tinyurl.com/expert-rac-12c> Expert PL/SQL practices <http://tinyurl.com/book-expert-plsql-practices>

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

Received on Fri Feb 28 2014 - 18:36:52 CET