RE: Tnsnames mystery
Date: Tue, 21 Aug 2012 13:10:13 -0400
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
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Storey, Robert (DCSO) Sent: Tuesday, August 21, 2012 12:17 PM
To: 'oracle_at_dunbar-it.co.uk'; oracle-l_at_freelists.org 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.
From: oracle-l-bounce_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Norman Dunbar Sent: Tuesday, August 21, 2012 10:16 AM
To: oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org> Subject: Re: Tnsnames mystery
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 Pudsey West Yorkshire United Kingdom LS28 7EL Company Number: 05132767 -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Tue Aug 21 2012 - 12:10:13 CDT