troubleshooting Question

tnsnames.ora file for a Oracle 11g database in vcs cluster

Avatar of GP7
GP7 asked on
Oracle Database
4 Comments1 Solution1243 ViewsLast Modified:
Hi All,

I have a database which is a part of vcs cluster. I need to have a tnsnames entry such that the client can connect to wich ever server is up in the cluster.

eg, server1 (20.40.50.151) and server2 (20.40.50.152) are in a vcs cluster (20.40.50.150)
and server1 is active. Now, when there is a server1 failure then it should automatically failover to server2.

How do I setup my listener.ora file and tnsnames.ora file so as to be able to failover automatically?

i have never worked with VCS clustering before, so any input is greatly appreciated.

Thanks,
ASKER CERTIFIED SOLUTION
it-rex

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros