| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: stupid oracle on windoze question
HI All,
It is in that useless documentation, from the Net8 Administrators Guide
Ensure that the client machine has the tnsnames.ora and the
sqlnet.ora files in $ORACLE_HOME/network/admin
on UNIX and ORACLE_HOME\network\admin
on Windows platforms.
The search order for sqlnet.ora and tnsnames.ora follows:
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/admin on UNIX and ORACLE_HOME\network\admin on Windows platforms
The one that I haven't seen documented is the "dot tnsnames.ora" on unix
Hope this helps,
-- John
wisernet100_at_yahoo.com wrote:
ah but you can do something similar, at least according to Joe -- hefound it on a thread on MetaLink.You put a tnsnames.ora file in your local directory (I would supposewithout setting TNS_ADMIN) and then it will use the local oneinteresting, veddy interesting--- Jared.Still_at_radisys.com wrote:
Not only is it not in the flaming manuals, I don't think youcan even do that on Windoze.Sure, you can set the TNS_ADMIN var inControlPanel->System->EnvVars, but that is rather broadin scope and does not offer the granularity available on unix.Jared Rachel Carmichael To: Multiple recipientsof list ORACLE-L <ORACLE-L_at_fatcity.com> <wisernet100_at_Y cc: AHOO.COM> Subject: RE: stupidoracle on windoze question
Sent by: root_at_fatcity.c 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 justre-sets the directory Oracle looks at but wanted something thatworkedmore like how login.sql works -- where if you have the file in yourlocal 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 inthe $ORACLE_HOME/network/admin/tnsnames.ora or the$TNS_ADMIN/tnsnames.ora fileTHAT is what Joe wanted for Windows. It ain't in the flamingmanuals.
--- Kimberly Smith <ksmith2_at_myfirstlink.net> wrote:
Damn, why don't people use the manuals. TNS_ADMIN. Actually, youcan setthe puppy on Unix as well. -----Original Message----- From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of JOETESTA 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 entrymaybe? 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@yahoo.comFat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / MailingLists--------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail messageto: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and inthe message BODY, include a l
ine containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: INET: Jared.Still@radisys.comFat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / MailingLists--------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail messageto: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing lis
t you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
__________________________________________________Do You Yahoo!?Send your FREE holiday greetings online!http://greetings.yahoo.com
Received on Wed Jan 02 2002 - 14:29:05 CST
 |
 |