Q
Problem solve Get help with specific problems with your technologies, process and projects.

Configuring TAF parameters in RAC

I have a question regarding Oracle 9i RAC database. We have two nodes that are concurrently accessing the same database in a RAC environment on Sun boxes, and we have a total of 300 users. We want to use the RAC feature to call Transparent Application Failover (TAF). Should I configure the TAF parameters in tnsnames.ora on each client workstation so they can access the database without any interruption?

I am an Oracle DBA and I have a question regarding Oracle 9i RAC database. We have two nodes that are concurrently accessing the same database in a RAC environment on Sun boxes, and we have a total of 300 users. 100 users out of 300 are connected to node1 and the rest of the users are connected to node2. Here we want to use the RAC feature to call (availability) Transparent Application Failover (TAF). Our primary node is node1 and the secondary node is node2. In case node1 fails, then those users who were accessing the database through node1 can access the database through node 2 by using the TAF feature. So please tell me, should I configure the TAF parameters in tnsnames.ora on each client workstation so they can access the database without any interruption? Or is there any other efficient way to do that?
As far as I know, the TAF parameters must be defined in all tnsnames.ora files that are required to access the database and instances. This means that any clients accessing your system will require these parameters defined in their tnsnames.ora files. If there is a more efficient way of doing this, I am not aware of it.

Dig Deeper on Oracle database installation, upgrades and patches

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close