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

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Sun, 23 Sep 2007 17:07:08 GMT
Message-ID: <03xJi.101983$Vk6.23325@newsfe07.phx>

zigzagdna_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/xyzpass_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 Received on Sun Sep 23 2007 - 12:07:08 CDT