RE: Tnsnames mystery

If you use 'process explorer.exe' from sysinternals it will show you the tnsnames.ora file that tnsping is using. This utility doesn't need an installso can be used quickly.

From: "Kevin Lidh" <kevin.lidh_at_gmail.com> To: <RStorey_at_DCSO.nashville.org>, <brianlanderson_at_gmail.com>, <oracle-l_at_freelists.org> Date: 21/08/2012 11:24 AM Subject: RE: Tnsnames mystery Sent by: oracle-l-bounce_at_freelists.org

Is there something in the "My Documents" directory? I had a client with Windows XP and they had a copy of an old tnsnames.ora file there and Oracle looked there first.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org[1]]On Behalf Of Storey, Robert (DCSO) Sent: Tuesday, August 21, 2012 9:19 AM
To: 'brianlanderson_at_gmail.com'; oracle-l_at_freelists.org Subject: RE: Tnsnames mystery

We use IP addresses
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org[2]]On Behalf Of Brian Anderson Sent: Tuesday, August 21, 2012 10:13 AM
To: oracle-l_at_freelists.org
Subject: Re: Tnsnames mystery

does the tnsnames.ora have the ip address or the host name.

if host name check the local hosts file.

On 8/21/2012 11:04 AM, Storey, Robert (DCSO) wrote:
>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.
>

--
http://www.freelists.org/webpage/oracle-l[3]


--
http://www.freelists.org/webpage/oracle-l[4]



-----
No virus found in this message.
Checked by AVG - www.avg.com[5]
Version: 2012.0.2197 / Virus Database: 2437/5211 - Release Date: 08/20/12

--
http://www.freelists.org/webpage/oracle-l[6]









Please consider the environment before printing this email

This message, including any attached documents, is intended for the
addressees only. It may contain information that is confidential, privileged
and/or exempt from disclosure. No rights to privilege or confidentiality
havebeen waived. Any unauthorized use or disclosure is prohibited. If you
have received this message in error, please reply to the sender by e-mail
anddelete or destroy all copies of this message.

Avant d'imprimer ce courriel, pensez àl'environnement

Ce message, incluant tous les documents joints, est àl'intention des
destinataires visés seulement.  Il peut contenir des renseignements
confidentiels, protégés et/ou ne pouvant pas être
divulgués.   Aucune renonciation n'est faite quant àsa nature
confidentielle et privilégiée.  Par conséquent, toute
diffusion ou utilisation non autorisée est strictement interdite.  Si
vous avez reçu ce message par erreur, veuillez en aviser
immédiatement l’expéditeur par retour de courriel et en
détruire toutes les copies existantes.






--- Links ---
   1 mailto:oracle-l-bounce_at_freelists.org
   2 mailto:oracle-l-bounce_at_freelists.org
   3 http://www.freelists.org/webpage/oracle-l
   4 http://www.freelists.org/webpage/oracle-l
   5 www.avg.com
   6 http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l