Re: ORA-12154: TNS:could not resolve service name

Hi juturi.

Checked and I only have a one installation of the Oracle 8.1.6 client on the client machine. Only have one tnsnames.ora on my client machine.

Felix

  juturi_at_workmail.com wrote:
> do you have more than one installation of the oracle client on the
> client machine?
>
> Do a file find for "tnsnames.ora" on all the drives.
>
> In article <eqy8gdQ8$GA.287_at_cpmsnbbsa09>,
> "Ling" <circetsui_at_email.msn.com> wrote:
> > Hi Felix,
> >
> > Have you tried TNSPing on the client machine to see if it can reach
 the
> > database?
> >
> > ling
> > <felixseto_at_my-deja.com> wrote in message news:8l2ik7$d21
 $1_at_nnrp1.deja.com...
> > > I am trying to connect to an Oracle 8.1.6 database and the
 connection
> > > test was succesfull from Net8 assistant, but failed from SQLPlus.
 The
> > > error was ORA-12154:TNS:could not resolve service name. The
 SQLPlus on
> > > the Oracle 8.1.6 Server itself can connect successfully but on a
 remote
> > > machine it fails. I've also checked the tnsnames.ora and
 listener.ora
> > > files and they appear to be correct. Any ideas? Thanks.
> > >
> > > Felix
> > >
> > >
> > >
> > >
> > > Sent via Deja.com http://www.deja.com/
> > > Before you buy.
> >
> >
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Jul 19 2000 - 00:00:00 CDT