It is in that useless documentation, from the Net8 Administrators Guide
-
Ensure that the client machine has the
tnsnames.oraand thesqlnet.orafiles in$ORACLE_HOME/network/adminon UNIX andORACLE_HOME\network\adminon Windows platforms.The search order for
sqlnet.oraandtnsnames.orafollows:- Current working directory from where an application is executed
-
TNS_ADMIN environment variable
If the TNS_ADMIN environment variable is not defined as a variable on Windows NT, it may be in the registry.
-
If TNS_ADMIN is not defined,
$ORACLE_HOME/network/adminon UNIX andORACLE_HOME\network\adminon Windows platforms
Hope this helps,
-- John
[EMAIL PROTECTED] wrote:
ah but you can do something similar, at least according to Joe -- he
found it on a thread on MetaLink.
You put a tnsnames.ora file in your local directory (I would suppose
without setting TNS_ADMIN) and then it will use the local one
interesting, veddy interesting
--- [EMAIL PROTECTED] wrote:Not only is it not in the flaming manuals, I don't think you
can even do that on Windoze.
Sure, you can set the TNS_ADMIN var in
ControlPanel->System->EnvVars, but that is rather broad
in scope and does not offer the granularity available on unix.
Jared
Rachel
Carmichael To: Multiple recipients
of list ORACLE-L <[EMAIL PROTECTED]>
<wisernet100@Y cc:
AHOO.COM> Subject: RE: stupid
oracle on windoze question
Sent by:
[EMAIL PROTECTED]
om
01/02/02 07:50
AM
Please respond
to 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 <[EMAIL PROTECTED]> wrote:Damn, why don't people use the manuals. TNS_ADMIN. Actually, you
can set
the puppy on Unix as well.
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]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 overridesa$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: [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 l ine 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:
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 lis t you want to be removed from). You may
also send the HELP command for other information (like subscribing).
__________________________________________________
Do You Yahoo!?
Send your FREE holiday greetings online!
http://greetings.yahoo.com
