On Sep 23, 1:49 pm, "Gerry Sinkiewicz" <sinki..._at_snet.net> wrote:
> "Ana C. Dent" <anaced..._at_hotmail.com> wrote in messagenews:03xJi.101983$Vk6.23325_at_newsfe07.phx...
>
>
>
> > zigzag..._at_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_at_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..._at_kdc.dbserver.na.xyz.com
> >> connection works. Why?
>
> >> What can be done to make connection work using sqlplus login/
> >> password_at_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.
Received on Sun Sep 23 2007 - 13:11:24 CDT
