Ah ha! Revenge of the RTFM! ;P ----Original Message----- Sent: 02 January 2002 14:45 To: Multiple recipients of list ORACLE-L
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 [EMAIL PROTECTED] 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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
