Re: stupid oracle on windoze question

From: orantdba <orantdba_at_netscape.net>
Date: Wed, 02 Jan 2002 07:11:09 -0800
Message-ID: <F001.003E4EFB.20020102064522@fatcity.com>

HI Joe,

>From the documentation:

TNS_ADMIN Oracle software looks for TNS_ADMIN in one location in the registry (depending upon the type of Oracle home installed). If you installed software into the default Oracle home, then any software running from that Oracle home will look in HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE. If you installed a new-style (8.0.4 or later) multiple Oracle home, then the Oracle software looks in HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOMEID . The ALL_HOMES key is used by the installer and plays no role when translating variables.

The environment always overrides the registry, so if TNS_ADMIN is set in the environment, that takes precedence over the TNS_ADMIN setting in the registry. No variables should be set in the environment by the Oracle Home Selector except for the PATH.
Hope this helps,
John

JTESTA_at_longaberger.com wrote:

  ok in the unix world, we have .tnsnames.ora file which overrides a $HOME/network/admin/tnsnames.ora file.

  Is there such a thing in the windoze world. a registry entry maybe?
  thanks, joe
                Received on Wed Jan 02 2002 - 09:11:09 CST