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