Home » Server Options » RAC & Failsafe » TAF connectivity (oracle 11g r2, OEL 5)
|
|
|
|
|
|
|
Re: TAF connectivity [message #650161 is a reply to message #650160] |
Sun, 17 April 2016 14:39   |
 |
Michel Cadot
Messages: 68757 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
When a node shuts down, yes.
When network fails, if the client can't reach the server, any server, then no, of course.
Didn't you say it works with SQL*Plus?
If so, it should work with your application, otherwise your application is not TAF aware.
[Updated on: Sun, 17 April 2016 14:44] Report message to a moderator
|
|
|
|
Re: TAF connectivity [message #650172 is a reply to message #650166] |
Mon, 18 April 2016 08:23  |
John Watson
Messages: 8976 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
zeeshan047 wrote on Mon, 18 April 2016 08:27found the solution by setting host name to virtual ip , now my new connection can also connect even if there one of node shutdown down or network failure.
Thanks
Regards
Zeeshan No, that is not correct. The tnsnames.ora entry you are using should be pointing to the SCAN hostname, which is already a virtual IP (by default, three of them). There is no way a user session should ever point to a node IP or VIP. In fact, if you are using GPnP (as everyone should) you do not know what the virtual host names and IP addresses are.
You may need to investigate further to be sure you have a robust solution.
|
|
|
Goto Forum:
Current Time: Sat May 03 23:00:37 CDT 2025
|