ORA-12154: TNS:could not resolve service name

From: <zigzagdna_at_yahoo.com>
Date: Sun, 23 Sep 2007 10:00:39 -0700
Message-ID: <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. Received on Sun Sep 23 2007 - 12:00:39 CDT