learn something new every day.....
- orantdba <orantdba_at_netscape.net> wrote:
> HI All,
>
> It is in that useless documentation, from the Net8 Administrators
> Guide
>
> 1. 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:
>
> 1. Current working directory from where an application is
> executed
> 2. 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.
>
> 3. 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 -- 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
> >
> >
> >--- Jared.Still_at_radisys.com 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 <ORACLE-L_at_fatcity.com>
> >> <wisernet100_at_Y cc:
>
> >>
> >> AHOO.COM> Subject: RE: stupid
> >>oracle 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 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:
> >> INET: Jared.Still_at_radisys.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).
> >>
> >
> >
> >__________________________________________________
> >Do You Yahoo!?
> >Send your FREE holiday greetings online!
> >http://greetings.yahoo.com
> >
>
>
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).
Received on Wed Jan 02 2002 - 15:20:24 CST
