[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1213
  • Last Modified:

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

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,
0
GP7
Asked:
GP7
  • 2
1 Solution
 
schwertnerCommented:
Sofar as i recall it is possible to double some values in tnsnames.ora file, like IP addresses
0
 
it-rexCommented:
there is something called a VIP “Virtual” IP address which will always point to whatever active in your cluster ;
ask your sys/network admin about it

and please read this

http://www.oraclemagician.com/white_papers/vcs_select.doc
0
 
GP7Author Commented:
@it-rex .. thank you for the link

I will let you know if i have any questions..
0
 
GP7Author Commented:
Thank you
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now