Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: how can i know the TNSNAME.ORA file used by Toad or another application
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...Received on Mon May 26 2003 - 09:32:49 CDT
> 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