今天通过Oracle SQL*Plus连接远端服务器的时候提示“监听程序当前无法识别连接描述符中请求服务”，遂在网上找到了解决方案：
①打开Oracle服务器安装目录\NETWORK\ADMIN\listener.ora文件，你会看到如下信息：
# listener.ora Network Configuration File: D:\database\Oracle\network\admin\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\database\Oracle)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ms-c459ece7aa7f)(PORT = 1521))
)
)
②在(SID_LIST=...)后面添加一句话，其中Demo是Oracle监听的实例名：
# listener.ora Network Configuration File: D:\database\Oracle\network\admin\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\database\Oracle)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = V3X)
(ORACLE_HOME = D:\database\Oracle)
(SID_NAME = V3X)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ms-c459ece7aa7f)(PORT = 1521))
)
)
③重启Oracle Listener再连接即可
--转自
当前位置：
论坛首页 »
自由讨论区 »
MySQL, Oracle及数据库讨论区
»
发起投票
技术讨论
加好友
发消息
2015-4-23 10:22:59 |
赞(
操作
