RE: Tnsnames mystery

  • From: "TJ Kiernan" <tkiernan@xxxxxxxxxxx>
  • To: "Storey, Robert \(DCSO\)" <RStorey@xxxxxxxxxxxxxxxxxx>, <paul.baumgartel@xxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • 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.

Thanks,
T. J.
 


-----Original Message-----
From: Storey, Robert (DCSO) [mailto:RStorey@xxxxxxxxxxxxxxxxxx] 
Sent: Tuesday, August 21, 2012 10:17 AM
To: TJ Kiernan; paul.baumgartel@xxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: Tnsnames mystery

I've never utilized or set tns_admin in the past.  Is this a default setting at 
install for 10g?

-----Original Message-----
From: TJ Kiernan [mailto:tkiernan@xxxxxxxxxxx] 
Sent: Tuesday, August 21, 2012 10:13 AM
To: Storey, Robert (DCSO); paul.baumgartel@xxxxxxx; oracle-l@xxxxxxxxxxxxx
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.  

Thanks,
T. J.
 

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Storey, Robert (DCSO)
Sent: Tuesday, August 21, 2012 10:04 AM
To: 'paul.baumgartel@xxxxxxx'; oracle-l@xxxxxxxxxxxxx
Subject: RE: Tnsnames mystery

Sorry.. Windows XP.  
Names.Directory_path= (TNSNAMES)

TNS_ADMIN is not set.  Using the SET command did not show it in the list of 
variables.

-----Original Message-----
From: paul.baumgartel@xxxxxxx [mailto:paul.baumgartel@xxxxxxx] 
Sent: Tuesday, August 21, 2012 9:54 AM
To: Storey, Robert (DCSO); oracle-l@xxxxxxxxxxxxx
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?


Paul Baumgartel
UBS AG
Group Finance Accounting Solutions
400 Atlantic Street
Stamford, CT 06904

203.719.4368

paul.baumgartel@xxxxxxx
www.ubs.com


-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Storey, Robert
(DCSO)
Sent: Tuesday, August 21, 2012 10:49 AM
To: 'oracle-l@xxxxxxxxxxxxx'
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.

Thanks
Bob

--
//www.freelists.org/webpage/oracle-l


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.
--
//www.freelists.org/webpage/oracle-l


--
//www.freelists.org/webpage/oracle-l

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 08-2012