RE: Tnsnames mystery
Date: Tue, 21 Aug 2012 10:21:04 -0500
It isn't default, but is useful when working around an ODBC driver bug (Getting Junk Characters in Drop Down List for TNS Service Name [ID 882357.1]). I'm not sure where else it's useful, but that's how I learned about it.
From: Storey, Robert (DCSO) [mailto:RStorey_at_DCSO.nashville.org] Sent: Tuesday, August 21, 2012 10:17 AM
To: TJ Kiernan; paul.baumgartel_at_ubs.com; oracle-l_at_freelists.org Subject: RE: Tnsnames mystery
I've never utilized or set tns_admin in the past. Is this a default setting at install for 10g?
From: TJ Kiernan [mailto:tkiernan_at_pti-nps.com] Sent: Tuesday, August 21, 2012 10:13 AM
To: Storey, Robert (DCSO); paul.baumgartel_at_ubs.com; oracle-l_at_freelists.org Cc: TJ Kiernan
Subject: RE: Tnsnames mystery
If I recall correctly, TNS_ADMIN can also be set in the registry (HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_homename), which probably did not get cleaned out with the uninstall. I would expect that your search for TNSNAMES.ora would have turned up another file, unless there's a hidden version of the file somewhere.
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Storey, Robert (DCSO) Sent: Tuesday, August 21, 2012 10:04 AM
To: 'paul.baumgartel_at_ubs.com'; oracle-l_at_freelists.org Subject: RE: Tnsnames mystery
Sorry.. Windows XP.
TNS_ADMIN is not set. Using the SET command did not show it in the list of variables.
From: paul.baumgartel_at_ubs.com [mailto:paul.baumgartel_at_ubs.com] Sent: Tuesday, August 21, 2012 9:54 AM
To: Storey, Robert (DCSO); oracle-l_at_freelists.org Subject: RE: Tnsnames mystery
What kind of client machine? What's the value of NAMES.DIRECTORY_PATH in sqlnet.ora? Have you tried temporarily removing renaming your new tnsnames.ora to see what happens on tnsping?
Group Finance Accounting Solutions
400 Atlantic Street
Stamford, CT 06904
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Storey, Robert (DCSO)
Sent: Tuesday, August 21, 2012 10:49 AM
Subject: Tnsnames mystery
Okay, I'm stumped. I wiped oracle off a client machine and reinstalled the 10g client. I copied over a fresh copy of a tnsnames.ora file that has all our client services with their new IP's. However, when I tnsping one of the services, I am getting IP address that were in the OLD tnsnames file. I did a file search on the machine and found no additional copies (other than the sample directory) of the tnsnames.ora file.
Where would it be getting the OLD service information from? I searched the registry and did not find it. The Tnsping file shows that it is going to the correct sql home.
Visit our website at http://www.ubs.com
This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system.
E-mails are not encrypted and cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. This message is provided for informational purposes and should not be construed as a solicitation or offer to buy or sell any securities or related financial instruments.
UBS reserves the right to retain all messages. Messages are protected and accessed only in legally justified cases.
http://www.freelists.org/webpage/oracle-l Received on Tue Aug 21 2012 - 10:21:04 CDT