If tou have $TNS_ADMIN variable set in Unix and it is the same as
$ORACLE_HOME/network/admin
or even different than that I suggest to use the tnsnames.ora in that
directory.
Else go with $ORACLE_HOME/network/admin
--
Ravi Alluru
mailto:ravica_at_quixnet.net
"Randall Roberts" <randall_at_filer.org.nospam> wrote in message
news:3b16ebe2_1_at_news.pcmagic.net...
> 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 Fri Jun 01 2001 - 08:59:24 CDT
