同一台机器上安装了10g和11g对于listener的配置
由于资源有限我在同一台机器的2个不同的用户下安装了oracle10和oracle11(oracle用户安装的10g,daizy用户安装了oracle11g),但是发现原来的oracle10可以远程连接,而oracle11g确不能连接,后修改了listener.ora,结果2个都能连接
oracle10
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)
)
)
oracle11g
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)
)
)
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/7916042/viewspace-995901/ ，如需转载，请注明出处，否则将追究法律责任。
