RE: Tnsnames mystery

  • From: "Storey, Robert (DCSO)" <RStorey@xxxxxxxxxxxxxxxxxx>
  • To: "'Patterson, Joel'" <Joel.Patterson@xxxxxxxxxxx>, "Thomas.Mercadante@xxxxxxxxxxxx" <Thomas.Mercadante@xxxxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 22 Aug 2012 12:03:49 +0000

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 [mailto:Joel.Patterson@xxxxxxxxxxx] 
Sent: Wednesday, August 22, 2012 6:21 AM
To: Thomas.Mercadante@xxxxxxxxxxxx; Storey, Robert (DCSO); 
oracle-l@xxxxxxxxxxxxx
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: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Mercadante, Thomas F (LABOR)
Sent: Tuesday, August 21, 2012 1:10 PM
To: RStorey@xxxxxxxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: Tnsnames mystery

Robert,
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

HTH

Tom


-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Storey, Robert (DCSO)
Sent: Tuesday, August 21, 2012 12:17 PM
To: 'oracle@xxxxxxxxxxxxxxx'; oracle-l@xxxxxxxxxxxxx
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: oracle-l-bounce@xxxxxxxxxxxxx<mailto:oracle-l-bounce@xxxxxxxxxxxxx> 
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Norman Dunbar
Sent: Tuesday, August 21, 2012 10:16 AM
To: oracle-l@xxxxxxxxxxxxx<mailto:oracle-l@xxxxxxxxxxxxx>
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.

Cheers,
Norm.

--
Norman Dunbar
Dunbar IT Consultants Ltd

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

Company Number: 05132767
--
//www.freelists.org/webpage/oracle-l


--
//www.freelists.org/webpage/oracle-l





--
//www.freelists.org/webpage/oracle-l


--
//www.freelists.org/webpage/oracle-l

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 08-2012