Home » Server Options » RAC & Failsafe » How to Configure TAF in Oracle 10g RAC (Oracle 10g RAC, 10.2.0.1.0, Windows 2003 Server.)
icon8.gif  How to Configure TAF in Oracle 10g RAC [message #317668] Fri, 02 May 2008 07:24 Go to next message
sushil.krishn
Messages: 7
Registered: October 2007
Location: Bangalore
Junior Member

hi,
I have a problem.
I have configured 10g RAC with 2 nodes.I want to test TAF.
I made a connection using client machine that was connected to node-1, and tried to shutdown the node-1 while running a long sql query.
As the node got down the client got disconnected.
My TNSNAMES.ORA entry for client is-
RAC =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac-1)(PORT = 1521)
(ADDRESS = (PROTOCOL = TCP)(HOST = rac-2)(PORT = 1521)
(LOAD_BALANCE = YES)
(CONNECT_DATA =
(SERVICE_NAME = rac.world)
)
)

Please reply with your suggestion...
Thanks in advance Smile
Re: How to Configure TAF in Oracle 10g RAC [message #317675 is a reply to message #317668] Fri, 02 May 2008 08:04 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In order to to use TAF you must have "(FAILOVER = ON)" in your tnsnames entry description and define FAILOVER_MODE.

Regards
Michel

[Updated on: Fri, 02 May 2008 08:06]

Report message to a moderator

Re: How to Configure TAF in Oracle 10g RAC [message #317676 is a reply to message #317668] Fri, 02 May 2008 08:08 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
You can configure TAF with DBCA services page.
Re: How to Configure TAF in Oracle 10g RAC [message #317695 is a reply to message #317676] Fri, 02 May 2008 10:49 Go to previous messageGo to next message
sushil.krishn
Messages: 7
Registered: October 2007
Location: Bangalore
Junior Member

Hi Michel,
I have modified client's TNSNAMES.ORA with following entry.
(FAILOVER=on)
(FAILOVER_MODE =
(TYPE=select)
(METHOD=basic)
(RETRIES=120)
(DELAY=5))

Now the existing session is not disconnecting, but after shutting down the active node to which client is connect, the query halts and it never continues...

What may be the problem???
Thanks for your support... Confused
Re: How to Configure TAF in Oracle 10g RAC [message #317700 is a reply to message #317695] Fri, 02 May 2008 11:43 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Did you program a callback to know when fail over is finished and then you are able to continue to fetch the query?

Regards
Michel
Re: How to Configure TAF in Oracle 10g RAC [message #317707 is a reply to message #317700] Fri, 02 May 2008 12:12 Go to previous messageGo to next message
sushil.krishn
Messages: 7
Registered: October 2007
Location: Bangalore
Junior Member

I never programmed any callback to check failover status.

But after halting for a long time my SQL query terminated and the session has been disconnected, according to TAF concept it should continue fetching rows automatically.
I will try to do so if you could provide some hint, then it will be very helpful for me, because I am doing it very first time.

Thanks...
Sushil Sad

[Updated on: Fri, 02 May 2008 12:15]

Report message to a moderator

Re: How to Configure TAF in Oracle 10g RAC [message #317711 is a reply to message #317707] Fri, 02 May 2008 13:04 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
you have to program for TAF. You can do it with OCI or JDBC (maybe .NET).
Afaik, it is not possible otherwise.

Regards
Michel
Previous Topic: EBS R12 Installation
Next Topic: Starting service from SQLPLUS
Goto Forum:
  


Current Time: Thu Mar 28 18:12:51 CDT 2024