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 (22.214.171.124) and server2 (126.96.36.199) are in a vcs cluster (188.8.131.52)
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.