Home » Server Options » RAC & Failsafe » TAF connectivity (oracle 11g r2, OEL 5)
TAF connectivity [message #650149] Sun, 17 April 2016 08:34 Go to next message
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 #650152 is a reply to message #650149] Sun, 17 April 2016 09:44 Go to previous messageGo to next message
Michel Cadot
Messages: 65203
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Is your application TAF aware?

Re: TAF connectivity [message #650156 is a reply to message #650152] Sun, 17 April 2016 13:52 Go to previous messageGo to next message
zeeshan047
Messages: 99
Registered: June 2010
Location: PAKISTAN
Member

hi,

I am connecting TAF connection using same database server.

Regards
Zeeshan
Re: TAF connectivity [message #650157 is a reply to message #650156] Sun, 17 April 2016 13:55 Go to previous messageGo to next message
Michel Cadot
Messages: 65203
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

This does not answer my question.
More I don't see which question you are answering and what you mean.

Re: TAF connectivity [message #650158 is a reply to message #650157] Sun, 17 April 2016 13:58 Go to previous messageGo to next message
zeeshan047
Messages: 99
Registered: June 2010
Location: PAKISTAN
Member

I am testing TAF connection using SQLPLUS prompt on same database server.

Re: TAF connectivity [message #650159 is a reply to message #650158] Sun, 17 April 2016 13:59 Go to previous messageGo to next message
Michel Cadot
Messages: 65203
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

SQL*Plus is TAF aware.
Is your application too?

Re: TAF connectivity [message #650160 is a reply to message #650159] Sun, 17 April 2016 14:16 Go to previous messageGo to next message
zeeshan047
Messages: 99
Registered: June 2010
Location: PAKISTAN
Member

Yes my application is TAF aware, TAF service working fine when oracle instance down i.e it connects to available instance , but in the case when server shutdown or network down of any one node in a cluster, connection hangs and it cant connect to available instance `. My question is did TAF service work when one node in a cluster is shutdown or network service fails.
Re: TAF connectivity [message #650161 is a reply to message #650160] Sun, 17 April 2016 14:39 Go to previous messageGo to next message
Michel Cadot
Messages: 65203
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 #650166 is a reply to message #650161] Mon, 18 April 2016 02:27 Go to previous messageGo to next message
zeeshan047
Messages: 99
Registered: June 2010
Location: PAKISTAN
Member

found 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
Re: TAF connectivity [message #650172 is a reply to message #650166] Mon, 18 April 2016 08:23 Go to previous message
John Watson
Messages: 7150
Registered: January 2010
Location: Global Village
Senior Member
zeeshan047 wrote on Mon, 18 April 2016 08:27
found 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.
Previous Topic: Help: crsinstall.pm line 941
Next Topic: unnamed_instance_4
Goto Forum:
  


Current Time: Thu Nov 23 20:00:51 CST 2017

Total time taken to generate the page: 0.01639 seconds