Highlighted
Absent Member.. Absent Member..
Absent Member..
917 views

How to Use tnsnames.ora file to find live VIP so federation connect to the live one.

How to Use tnsnames.ora file to find live VIP so federation connect to the live one.

 

Regards,Kunj

 

Tags (1)
0 Likes
2 Replies
Highlighted
Acclaimed Contributor.. Acclaimed Contributor..
Acclaimed Contributor..

Re: How to Use tnsnames.ora file to find live VIP so federation connect to the live one.

Please find the explanation from Oracle -> http://docs.oracle.com/html/B14406_01/undrstnd.htm .

 

Regards
-Dmitry Gomel, PMP
Click the Like button at the bottom to say 'Thanks'.
Highlighted
Absent Member.. Absent Member..
Absent Member..

Re: How to Use tnsnames.ora file to find live VIP so federation connect to the live one.

I can find one discovery module named "Oracle TNSName By Shell" which discovers ConfigurationDocument, IpAddress, Node, Oracle, Composition, Containment etc.

 

If i go to properties i can see parameters file=c:\tmep\tnsnames.ora

 

But if i go to my ucmdb application server C:\temp i cannot find tnsnames.ora file.

 

I'm new to ucmdb. can you please guide me on

 

why we are using this discovery module Oracle TNSName By Shell"

How to use this?

tnsnames.ora is an input file or output file?

 

Actual requirement is something like:

We have both primary and secondary db servers. Primary servers are always live. Sometimes due to maintenence activity the engineers swith between primary to secondary and make secondary as primary.

 

in ucmdb some federation tasks are there. in the tql's we configured the IP's. when they switch the servers we need to manually go and change the IP's to successfully run the federation jobs.

How to avoid this outage?

 

for that i heard we can go with any of these methods

 

  1. Using virtual IP on LB and point the active server
  2. Write script to find alive IP on the back end
  3. Using tnsnames.ora file to find live VIP so federation connect live one.

How to use these above methods?

 

I was trying with the 3rd one. but i dont know where to start?

 

Regards,

Kunj

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.