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

Home -> Community -> Usenet -> c.d.o.server -> Re: how can i know the TNSNAME.ORA file used by Toad or another application

Re: how can i know the TNSNAME.ORA file used by Toad or another application

From: Terry Dykstra <dontreply_tddykstra_at_forestoil.ca>
Date: Mon, 26 May 2003 14:32:49 GMT
Message-ID: <lApAa.13344$_i3.2065510@news2.telusplanet.net>


Order of searching for tnsnames.ora:
- tns_admin as an OS environment comes first. - tns_admin defined in the registry under hklm/software/oracle/homeX (X being 0,1,2,..)
- then the default network/admin (network80/admin for net8.0) directory

--
Terry Dykstra
Canadian Forest Oil Ltd.
"windymimich" <windymimich_at_caramail.com> wrote in message
news:53530e89.0305260619.be3bc21_at_posting.google.com...

> I use a winnt system, and i 'd like to know how can i find which
> TNSNAME.ORA file ( because i have many oracle SQL*NET client
> installed) my oracle client like Toad uses?
> I've seen variable like ORACLE_HOME or ORACLE_HOME_NAME in the
> registry in many registry instance.
> How can i give focus(pointer) to a choised ORACLE_ENVIRONMENT?
> thx
Received on Mon May 26 2003 - 09:32:49 CDT

Original text of this message

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