Path: text.usenetserver.com!out01b.usenetserver.com!news.usenetserver.com!in04.usenetserver.com!news.usenetserver.com!nx01.iad01.newshosting.com!newshosting.com!198.186.194.247.MISMATCH!news-out.readnews.com!news-xxxfer.readnews.com!postnews.google.com!57g2000hsv.googlegroups.com!not-for-mail
From:  zigzagdna@yahoo.com
Newsgroups: comp.databases.oracle.server
Subject: Re: ORA-12154: TNS:could not resolve service name
Date: Sun, 23 Sep 2007 11:11:24 -0700
Organization: http://groups.google.com
Lines: 62
Message-ID: <1190571084.495039.281830@57g2000hsv.googlegroups.com>
References: <1190566839.120418.238640@y42g2000hsy.googlegroups.com>
   <03xJi.101983$Vk6.23325@newsfe07.phx>
   <AGxJi.531$hI7.251@newssvr17.news.prodigy.net>
NNTP-Posting-Host: 148.177.1.210
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
X-Trace: posting.google.com 1190571084 28578 127.0.0.1 (23 Sep 2007 18:11:24 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Sun, 23 Sep 2007 18:11:24 +0000 (UTC)
In-Reply-To: <AGxJi.531$hI7.251@newssvr17.news.prodigy.net>
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR 1.0.3705; .NET CLR 1.1.4322; InfoPath.1),gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: 57g2000hsv.googlegroups.com; posting-host=148.177.1.210;
   posting-account=ps2QrAMAAAA6_jCuRt2JEIpn5Otqf_w0
Xref: usenetserver.com comp.databases.oracle.server:435440
X-Received-Date: Sun, 23 Sep 2007 14:11:24 EDT (text.usenetserver.com)

On Sep 23, 1:49 pm, "Gerry Sinkiewicz" <sinki...@snet.net> wrote:
> "Ana C. Dent" <anaced...@hotmail.com> wrote in messagenews:03xJi.101983$Vk6.23325@newsfe07.phx...
>
>
>
> > zigzag...@yahoo.com wrote in news:1190566839.120418.238640
> > @y42g2000hsy.googlegroups.com:
>
> >> I have database installed on dbserver.  Dbserver is HP UNIX 11i
> >> running Oracle 8.1.6.1.
>
> >> I have Oracle client installed on three application servers
> >> appserver1, apserver2 and  appserver3. App servers are Windows 2003
> >> running Oracle 9.2.0.7 client.
>
> >> Tnsanmes.ora on three severs is as follows:
>
> >> kdc =
> >>   (DESCRIPTION =
> >>   (ADDRESS = (PROTOCOL= TCP)(Host= dbserver.na.xyz.com)(Port= 1521))
> >>   (CONNECT_DATA = (SID = kdc))
>
> >>    )
> >> kdc.dbserver.na.xyz.com  =
> >>   (DESCRIPTION =
> >>   (ADDRESS = (PROTOCOL= TCP)(Host= dbserver.na.xyz.com)(Port= 1521))
> >>   (CONNECT_DATA = (SID = kdc))
> >>    )
>
> >> When I do sqlplus xyxlogin/xyzpass@kdc
>
> >> Connection works on appserver1 and asppserver2 but not on appserver3.
> >> On appserver3 I get : ORA-12154: TNS:could not resolve service name
> >> Error.
>
> >> But when I enter sqlplus  xyzlogin/xyzp...@kdc.dbserver.na.xyz.com
> >> connection works.  Why?
>
> >> What can be done to make connection work using sqlplus login/
> >> password@kdc.
>
> >> Thanks.
>
> > Please NOTE the following is legal syntax:
>
> > kdc,kdc.dbserver.na.xyz.com  =
> >  (DESCRIPTION =
> >  (ADDRESS = (PROTOCOL= TCP)(Host= dbserver.na.xyz.com)(Port= 1521))
> >  (CONNECT_DATA = (SID = kdc))
> >   )
>
> > Post the content of sqlnet.ora file which exists on dbserver.na.xyz.com
>
> Actually the sqlnet.ora file on the failing appserver compared to the ones
> that don't fail would be good too.- Hide quoted text -
>
> - Show quoted text -

That was it. failing server had default sqlnet.ora while other app
servers did not have sqlnet.ora. I removed the sqlnet.ora for app
server 3 and problem went away. Thanks a lot to both of you.