Re: Question about VIP failover and accepting connections
- From: Riyaj Shamsudeen <riyaj.shamsudeen@xxxxxxxxx>
- To: jure.bratina@xxxxxxxxx
- Date: Fri, 28 Feb 2014 09:36:52 -0800
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>
Other related posts:
