在线等待！oracle客户端配置问题（tns-03505： 未能分解名称） ( 积分: 50 )

oracle数据库服务器上用“本地网络服务器”测试成功，tnsnames.ora配置文件如下：

# TNSNAMES.ORA Network Configuration File: d:/oracle/ora81/NETWORK/ADMIN/tnsnames.ora
# Generated by Oracle configuration tools.

SINO1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.111.28)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = sino)
)
)

INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = tt-jqs7yoif5z5o)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = sino)
(PRESENTATION = http://admin)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

SINO =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.111.28)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = sino)
)
)

在另一台电脑上装了一个oracle客户端,并用“本地网络服务器”测试连接到服务器，成功。客户端的tnsnames.ora配置文件如下：
# TNSNAMES.ORA Network Configuration File: e:/oracle/ora81/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

SINO.SINOAGENT =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.111.28)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = sino)
)
)
但在该客户端的cmd里 tnsping sino
则显示：tns-03505： 未能分解名称。
但tnsping 192.168.111.28 则能ping 通。

请问客户端该如何配置才能使tnsping sino 成功。
急！！谢谢啦！

oracle数据库服务器上用“本地网络服务器”测试成功，tnsnames.ora配置文件如下：

# TNSNAMES.ORA Network Configuration File: d:/oracle/ora81/NETWORK/ADMIN/tnsnames.ora
# Generated by Oracle configuration tools.

SINO1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.111.28)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = sino)
)
)

INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = tt-jqs7yoif5z5o)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = sino)
(PRESENTATION = http://admin)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

SINO =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.111.28)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = sino)
)
)

在另一台电脑上装了一个oracle客户端,并用“本地网络服务器”测试连接到服务器，成功。客户端的tnsnames.ora配置文件如下：
# TNSNAMES.ORA Network Configuration File: e:/oracle/ora81/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

SINO.SINOAGENT =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.111.28)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = sino)
)
)
但在该客户端的cmd里 tnsping sino
则显示：tns-03505： 未能分解名称。
但tnsping 192.168.111.28 则能ping 通。

请问客户端该如何配置才能使tnsping sino 成功。
急！！谢谢啦！

急！

你的服务名是: SINO.SINOAGENT
所以应该是: tnsping sino.sinoagent

如果希望是: sino的话应该改成sino吧? 未曾经过测试, 你可以试试.