Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

RAC TNS Entry for FAILOVER

540301Jun 5 2009 — edited Jun 6 2009

Hi DBAs,

We have a 4 node RAC Database (10.2.0.4) on Solaris 5.10. Sometime for maintenance we brought 2 nodes down. And using a service (which include all the VIPs for all oracle instances) If I try to connect to the database, I get error TNS Service not available and after 3-4 tries it automatically connect.

I have not specified the FAILOVER parameter in the TNSNAMES.ORA. Assuming the default value is FAILOVER=ON.

Please suggest do I need to explicitly define the value for FAILOVER, if so what would be the appropriate value - FAILOVER=ON or FAILOVER=YES. Also what is the difference between FAILOVER=ON & FAILOVER=YES .

Thanks
-Samar-

This post has been answered by Bjoern Rost on Jun 6 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 4 2009

Added on Jun 5 2009

#performance-availability, #real-application-clusters

3 comments

8,788 views