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