RE: stupid oracle on windoze question

From: eric harrington <eharrington_at_ecora.com>
Date: Wed, 02 Jan 2002 08:49:07 -0800
Message-ID: <F001.003E5189.20020102083553@fatcity.com>

In my research the TNS_ADMIN does not actually "re-set" the directory where Oracle looks.

The presence of a TNS_ADMIN env var is checked first, if found then this path is used to locate the tnsnames.ora and sqlnet.ora. If it is not found, Oracle looks at the ORACLE_HOME env var, if found then it looks at the registry for this HOME to see if the TNS_ADMIN exist there, if it does it uses that location.

The point being that the TNS_ADMIN is checked first. It appears that setting this variable would satisfy Joe's request.

Eric Harrington

-----Original Message-----
Carmichael
Sent: Wednesday, January 02, 2002 10:51 AM To: Multiple recipients of list ORACLE-L

well the thing is, he wasn't looking for TNS_ADMIN since that just re-sets the directory Oracle looks at but wanted something that worked more like how login.sql works -- where if you have the file in your local working directory, it is used and overrides any other file.

In Unix, if you have a .tnsnames.ora file (please note the initial ".") in your own personal $HOME directory) it will override the values in the $ORACLE_HOME/network/admin/tnsnames.ora or the $TNS_ADMIN/tnsnames.ora file

THAT is what Joe wanted for Windows. It ain't in the flaming manuals.

• Kimberly Smith <ksmith2_at_myfirstlink.net> wrote:
  > Damn, why don't people use the manuals. TNS_ADMIN. Actually, you
  > can set
  > the puppy on Unix as well.
  > -----Original Message-----
  > From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of JOE
  > TESTA
  > Sent: Wednesday, January 02, 2002 6:15 AM
  > To: Multiple recipients of list ORACLE-L
  > Subject: stupid oracle on windoze question
  >
  >
  > 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
  >
  >
  

  ---

Do You Yahoo!?
Send your FREE holiday greetings online! http://greetings.yahoo.com

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
  INET: wisernet100_at_yahoo.com

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: ListGuru_at_fatcity.com (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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: eric harrington
  INET: eharrington_at_ecora.com

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: ListGuru_at_fatcity.com (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).

Received on Wed Jan 02 2002 - 10:49:07 CST