Re: TNSNAMES.ora

Bernard Polarski wrote:

> In your registery, in section HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE there
> is (or you may define) a variable TNS_ADMIN. If you put there a full
> path for the directory where to pick the tnsnames.ora then Oracle
> Client will look there. [Put only paths ] ie : "c:\progra~1\orant\net8
> \admin\network"
>
> B. Polarski
> http://www.geocities.com/bpolarsk
> Bpolarski_at_yahoo.com
>
> In article <83m4u9$c6c$1_at_news.doit.wisc.edu>,
> "Glen Siferd" <siferd_at_admin.uwex.edu> wrote:
> > Paul;
> >
> > You should have a ORANT\NET80\ADMIN directory, also, and that's where
> the
> > TNSNAMES.ORA that Oracle 8 uses is stored. The installation of the 7.3
> > client may well have overwritten the TNSNAMES.ORA file in that
> directory,
> > but should have made a backup. If not, you'll have to recreate it and
> make
> > sure you have identical copies in both NETWORK\ADMIN and NET80\ADMIN.
> >
> > What error message do you get when the Oracle 8 app won't run?
> >
> > Glen
> >
> > "Paul Long" <plong_at_micron.net> wrote in message
> > news:385E72D4.31D31BA_at_micron.net...
> > > I know nothing about Oracle 8x, but I need to know if it uses a
> > > TNSNAMES.ora file? If so, is this file suppose to be in the
> > > \orant\network\admin directory?
> > >
> > > My Oracle 8 is installed loaclly, but we must also connect to an
> Oracle
> > > 7.3 database on a network server. After installing the 7.3 client,
> our
> > > Oracle 8 application won't run. The only thing I'm aware of that
> may
> > > have been overwritten is the TNSNAMES.ora file.
> > >
> > > Any suggestions would be appreciated.
> > >
> > > Thanks,
> > >
> > > Paul
> > >
> >
> >
>
> --
> B.Polarski
>
> http://www.geocities.com/bpolarsk
> Email : bpolarsk_at_yahoo.com
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Jan 20 2000 - 08:36:01 CST