Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: stupid oracle on windoze question
Hi Jared,
Sorry, I misunderstood the question.
Environment variables can, however be set locally instead of at the system level
tns_admin=<directory>
inside of a .bat or a .cmd script, maybe even perl :-)
John
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 recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> <wisernet100_at_Y cc: AHOO.COM> Subject: RE: stupid oracle on windoze question Se nt 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 that workedmore 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 flaming manuals.--- Kimberly Smith <a class="moz-txt-link-rfc2396E" hre !!
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 / Mailing Lists--------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail messageto: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and inthe message BODY, includea line 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). Received on Wed Jan 02 2002 - 11:57:44 CST