Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

VIP failed over behavior

André Vila CovaMar 16 2015 — edited Mar 16 2015

My application is using RAC VIP's in connection string. Currently because of an hardware issue, one of the instances is down, VIP for that node is INTERMEDIATE / FAILED OVER.

Considering the following note in oracle official documentation:

A VIP address is an alternate public address that client connections use instead of the standard public IP address. If a node fails, then the node's VIP address fails over to another node but there is no listener listening on that VIP, so a client that attempts to connect to the VIP address receives a connection refused error (ORA-12541) instead of waiting for long TCP connect timeout messages. This error causes the client to quickly move on to the next address in the address list and establish a valid database connection. New client connections can initially try to connect to a failed-over-VIP, but when there is no listener running on that VIP the "no listener" error message is returned to the clients. The clients traverse to the next address in the address list that has a non-failed-over VIP with a listener running on it.


I would like to know if in this situation: This error causes the client to quickly move on to the next address in the address list and establish a valid database connection is something automatic or I need to catch Exception to repeat execution?


Thanks a lot



Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 13 2015
Added on Mar 16 2015
1 comment
1,501 views