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

Hi Terry.

This is what my sqlnet.ora file contains:

NAMES.DEFAULT_DOMAIN = seagatesoftware.com

SQLNET.AUTHENTICATION_SERVICES= (NTS) NAMES.DIRECTORY_PATH= (HOSTNAME) I commented out both the NAMES and I still get the error.

Felix

  "Terry Dykstra" <dontreply_tdykstra_at_cfol.ab.ca> wrote:
> Check your sqlnet.ora file. Try commenting out the name/names
 parameters.
>
> --
> Terry Dykstra
> Canadian Forest Oil Ltd.
> Sybase Developer's Network: http://www.sybase.com/sdn
> Techwave 2000: http://www.sybase.com/techwave2000/
> <felixseto_at_my-deja.com> wrote in message
 news:8l4nnd$vdt$1_at_nnrp1.deja.com...
> > 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.
>
>

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