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

From: <juturi_at_workmail.com>
Date: 2000/07/19
Message-ID: <8l2ujm$m0q$1@nnrp1.deja.com>#1/1

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. Received on Wed Jul 19 2000 - 00:00:00 CDT