RE: Tnsnames mystery

From: Lange, Kevin G <>
Date: Tue, 21 Aug 2012 10:01:32 -0500
Message-ID: <>

When you tnsping the database does it tell you the parameter file its using ? I always get this in my output so I know what my path was set to . Also, check to see that you are not using something like ldap to get the tns information.

Used parameter files:

-----Original Message-----

[] On Behalf Of
Sent: Tuesday, August 21, 2012 9:54 AM
To:; 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
Group Finance Accounting Solutions
400 Atlantic Street
Stamford, CT 06904


-----Original Message-----

[] On Behalf Of Storey, Robert (DCSO)
Sent: Tuesday, August 21, 2012 10:49 AM
To: ''
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

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.

This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately.

-- Received on Tue Aug 21 2012 - 10:01:32 CDT

Original text of this message