From: Doug Coan <dcoan@aegonusa.com>
Subject: Re: ORA-12154: TNS:could not resolve service name
Date: 2000/08/08
Message-ID: <8mpjhq$al8$1@nnrp1.deja.com>#1/1
References: <8l2ik7$d21$1@nnrp1.deja.com> <eqy8gdQ8$GA.287@cpmsnbbsa09> <8l2ujm$m0q$1@nnrp1.deja.com>
X-Http-Proxy: 1.0 x73.deja.com:80 (Squid/1.1.22) for client 206.150.248.11
Organization: Deja.com - Before you buy.
X-Article-Creation-Date: Tue Aug 08 18:29:18 2000 GMT
X-MyDeja-Info: XMYDJUIDdougcoan
Newsgroups: comp.databases.oracle.server
X-Http-User-Agent: Mozilla/4.72 [en] (WinNT; U)


In article <8l2ujm$m0q$1@nnrp1.deja.com>,
  juturi@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@cpmsnbbsa09>,
>   "Ling" <circetsui@email.msn.com> wrote:
> > Hi Felix,
> >
> > Have you tried TNSPing on the client machine to see if it can reach
 the
> > database?
> >
> > ling
> > <felixseto@my-deja.com> wrote in message news:8l2ik7$d21
 $1@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.
>

Make sure when you are connecting from the server to the server that you
are using IP and not IPC. If you are setting the oracle_sid and just
saying 'sqlplus', you are IPC and if you are saying 'sqlplus
uid@service_name' then you are using IP (or a protocol other than IPC).
Thus there may be an  invalid comparison to server works, remote pc does
not.

Check sqlnet.ora.   NET8 assistant tries to be helpful and modifies the
server's sqlnet.ora so the default domain is the ip domain of the
server. If your remote box is trying to resolve to say .WORLD then you
will get this message.

HTH -

--
Doug Coan
Oracle Certified Professional DBA


Sent via Deja.com http://www.deja.com/
Before you buy.