Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-12154: TNS:could not resolve service name
"Ana C. Dent" <anacedent_at_hotmail.com> wrote in message
news:03xJi.101983$Vk6.23325_at_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
>
Actually the sqlnet.ora file on the failing appserver compared to the ones
that don't fail would be good too.
Received on Sun Sep 23 2007 - 12:49:21 CDT