ora-12514错误：监听程序当前无法识别连接描述符中请求的服务。
环境：服务端 linux as4+oracle9.2.0.4 ip：192.168.1.252 主机名：server.
客户端 win2003 oracle10gclient ip:192.168.1.254
问题如下：
sqlplus 连接出现ora-12514错误：监听程序当前无法识别连接描述符中请求的服务。
使用net manager 和 net configuration assistant测试连接的时候都是成功连接的。
服务端listener 监听正常（相关web服务使用也正常）
listener.ora 如下：
istener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = server.)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /opt/ora9/product/9.2)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = xjty)
(ORACLE_HOME = /opt/ora9/product/9.2)
(SID_NAME = xjty)
)
)
服务端tnsnames.ora如下：
nsnames.ora
# Generated by Oracle configuration tools.
xjty =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = server.)(PORT = 1521))
)
(CONNECT_DATA =
