同一臺機器上安裝了10g和11g對於listener的配置

rainbowbridg發表於2007-12-27

由於資源有限我在同一臺機器的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)
)
)

[@more@]ref:

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/7916042/viewspace-995901/,如需轉載,請註明出處,否則將追究法律責任。

相關文章