Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: stupid oracle on windoze question

Re: stupid oracle on windoze question

From: orantdba <orantdba_at_netscape.net>
Date: Wed, 02 Jan 2002 09:57:44 -0800
Message-ID: <F001.003E52DD.20020102094037@fatcity.com>

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 !
!
f="mailto:ksmith2_at_myfirstlink.net"><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 / 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, include
 a 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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US