Members Members   Search Search   Help Help   Register Register   Login Login   Home Home
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
Report message to a moderator
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: 15243
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
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: 1883
Registered: April 2006
Senior Member
You can configure TAF with DBCA services page.
Report message to a moderator
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
Report message to a moderator
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: 15243
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
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
Report message to a moderator
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: 15243
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
you have to program for TAF. You can do it with OCI or JDBC (maybe .NET).
Afaik, it is not possible otherwise.

Regards
Michel
Report message to a moderator
Previous Topic:EBS R12 Installation
Next Topic:Starting service from SQLPLUS
Goto Forum:
  

[ Syndicate this forum (XML) ] [ ]

Current Time: Sat May 17 01:25:01 CDT 2008

Total time taken to generate the page: 4.43156 seconds
.:: Forum Home :: Site Home :: Wiki Home :: Contact :: Privacy ::.