RE: Tnsnames mystery

From: <>
Date: Tue, 21 Aug 2012 11:31:30 -0400
Message-ID: <>


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" <> To: <>, <>, <> Date: 21/08/2012 11:24 AM Subject: RE: Tnsnames mystery Sent by:

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-----
[[1]]On Behalf Of Storey, Robert (DCSO) Sent: Tuesday, August 21, 2012 9:19 AM
To: ''; Subject: RE: Tnsnames mystery

We use IP addresses
-----Original Message-----
[[2]]On Behalf Of Brian Anderson Sent: Tuesday, August 21, 2012 10:13 AM
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



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


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 &#224;l'environnement

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

--- Links ---
Received on Tue Aug 21 2012 - 10:31:30 CDT

Original text of this message