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