Re: tnsnames file question

There is a Network/Admin path in every Oracle Home directory you have. There is an Oracle Home for each product. The tnsnames.ora file in the Network/Admin (or Net8/Admin in some products) is for the products in the same Oracle Home. The ones in the Sample sub-directories are only samples. Sometimes its a matter of copying your good tnsnames.ora to every Oracle Home.

Best!

Randall

J. G. Dutcher <DutcherJG_at_navair.navy.mil> wrote in message news:DutcherJG-3105011518150001_at_clhrd7.chinalake.navy.mil...
> I'm trying to migrate from a unix box to a windows NT box. Oracle (8i)
> keeps telling me my tnsnames file is not configured correctly. When I
> check for tnsnames.ora files I find lots of them.
>
> So my question is, short of renaming all of them, and then one by one
> naming them back to tnsnames.ora, how do I know which tnsname.ora file
> Oracle is using?
>
> Any help is appreciated.
>
> TIA
>
> JG Dutcher
> dutcherjg_at_navair.navy.mil
Received on Thu May 31 2001 - 20:11:25 CDT