TAF connectivity [message #650149] |
Sun, 17 April 2016 08:34 |
zeeshan047
Messages: 99 Registered: June 2010 Location: PAKISTAN
|
Member |
|
|
hi,
I am using oracle 11g r2 (rac 2 nodes ), i have configured TAF for client connectivity. I have found that whenever a network failure occur in any one node or if one node get down , my TAF connections are unable to switch to available node. Is this TAF default behavior or did i am missing any parameter in TAF configuration , kindly assist me.
srvctl add service -d db -s billing -r "db3,db4" -P PRECONNECT
service_billing =
(DESCRIPTION =
(LOAD_BALANCE=on)
(FAILOVER=ON)
(ADDRESS = (PROTOCOL = TCP)(HOST = crs-scan)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = billing)
(FAILOVER_MODE =
(TYPE = SELECT)
(METHOD = PRECONNECT)
(RETRIES = 1)
(DELAY = 1)
)
)
)
Regards
zeeshan
|
|
|
|
|
|
|
|
|
Re: TAF connectivity [message #650161 is a reply to message #650160] |
Sun, 17 April 2016 14:39 |
|
Michel Cadot
Messages: 68665 Registered: March 2007 Location: Nanterre, France, http://...
|
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: 8938 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.
|
|
|