在同一台机器的2个不同的用户下安装了Oracle 10g和Oracle 11g(Oracle用户安装10g,daizy用户安装Oracle 11g),但是发现原来的Oracle 10g可以远程连接,而Oracle 11g确不能连接。
解决方法：
修改listener.ora后,10g和11g的连接即可恢复正常。
具体示例如下：
Oracle数据库10g
cat listener.ora
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oratest)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /home/oracle/OraHome_1)
(PROGRAM = extproc)
)
(SID_DESC =
(ORACLE_HOME = /home/oracle/OraHome_1)
(SID_NAME = test)
)
)
Oracle数据库11g
cat listener.ora
# listener.ora Network Configuration File: /home/daizy/OraHome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.170)(PORT = 1522))
(ADDRESS = (PROTOCOL = IPC)(KEY = dzy))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /home/daizy/OraHome_1)
(PROGRAM = extproc)
)
(SID_DESC =
(ORACLE_HOME = /home/daizy/OraHome_1)
(SID_NAME = dzy)
)
)
我们一直都在努力坚持原创.......请不要一声不吭，就悄悄拿走。
我原创，你原创，我们的内容世界才会更加精彩！
【所有原创内容版权均属TechTarget，欢迎大家转发分享。但未经授权，严禁任何媒体（平面媒体、网络媒体、自媒体等）以及微信公众号复制、转载、摘编或以其他方式进行使用。】
微信公众号
TechTarget
官方微博
TechTarget中国
