RE: Tnsnames mystery

From: Storey, Robert (DCSO) <"Storey,>
Date: Wed, 22 Aug 2012 12:03:49 +0000
Message-ID: <>

No, there was no system environment variable. That would have also been displayed using the SET command. Also, no Oracle_home was set.

-----Original Message-----
From: Patterson, Joel [] Sent: Wednesday, August 22, 2012 6:21 AM To:; Storey, Robert (DCSO); Subject: RE: Tnsnames mystery

Yes, it sounds like a 'system' environment variable. I navigate using the start button/settings/control panel/system/advanced tab/environment variables button/system variables section -- TNS_ADMIN

Joel Patterson
Database Administrator
904 727-2546
-----Original Message-----
From: [] On Behalf Of Mercadante, Thomas F (LABOR) Sent: Tuesday, August 21, 2012 1:10 PM
To:; Subject: RE: Tnsnames mystery

Did you check the PATH environmental? Did it have the network drive in the path?

ORACLE_HOME does not need to be set.
TNS_ADMIN is an environmental variable.

Right-click "my computer"/properties/advanced/Environmental variables


-----Original Message-----
From: [] On Behalf Of Storey, Robert (DCSO) Sent: Tuesday, August 21, 2012 12:17 PM
To: ''; Subject: RE: Tnsnames mystery

Is the TNS_ADMIN a separate key outside of the oracle key in the registry. Going to look to see if it is set someone where else.

I also noticed I did not have the oracle_home variable set on that machine.

-----Original Message-----
From:<> [] On Behalf Of Norman Dunbar Sent: Tuesday, August 21, 2012 10:16 AM
To:<> Subject: Re: Tnsnames mystery

Hi Robert,

On 21/08/12 16:04, 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.

Check the registry settings for the oracle home in use. It is possible that there is a setting there, and if so, it will not show up when you use SET.


Norman Dunbar
Dunbar IT Consultants Ltd

Registered address:
Thorpe House
61 Richardshaw Lane
West Yorkshire
United Kingdom
LS28 7EL

Company Number: 05132767



Received on Wed Aug 22 2012 - 07:03:49 CDT

Original text of this message