OraFAQ Forum: RAC & Failsafe » How to Configure TAF in Oracle 10g RAC

Home » Server Options » RAC & Failsafe » How to Configure TAF in Oracle 10g RAC (Oracle 10g RAC, 10.2.0.1.0, Windows 2003 Server.)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to Configure TAF in Oracle 10g RAC [message #317668]

Fri, 02 May 2008 07:24

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

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

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

ebrian
Messages: 2794
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

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

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

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

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

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

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Previous Topic:	EBS R12 Installation
Next Topic:	Starting service from SQLPLUS

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 18 01:03:17 CST 2024