Re: TNS_ADMIN environment variable

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 26 Aug 2002 15:53:26 -0700
Message-ID: <92eeeff0.0208261453.2fc58a6d@posting.google.com>

"Terry Dykstra" <dontreply_tddykstra_at_forestoil.ca> wrote in message news:<zHsa9.4987$xc2.352581_at_news0.telusplanet.net>...
> I recently came across a site where they set the TNS_ADMIN entry as an
> environment variable on their W2K machines. I always thought it should be
> set only as a registry entry under HKLM/software/oracle. Are there any
> reasons why you would use method above the other?

Oracle looks for TNS_ADMIN in following sequence,

IF (TNS_ADMIN is set as ENV variable) THEN

Use this;
ELSIF (TNS_ADMIN is set in registry at HKLM\SOFTWARE\ORACLE\HOME<x>) THEN

Use this;
ELSE
Use %ORACLE_HOME%\Network\Admin
END IF; //Rauf Sarwar Received on Mon Aug 26 2002 - 17:53:26 CDT