多个ORACLE数据库实例下listener.ora文件配置
本机两个数据库：ER1和ID1，都是使用的一套oracle数据库系统，为了同时监听两个数据库实例，需要按照以下格式配置listener.ora文件：
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = ER1)
(ORACLE_HOME = G:oracleERP102)
)
(SID_DESC =
(SID_NAME = ID1)
(ORACLE_HOME = G:oracleERP102)
)
)
我的listener.ora文件：
# listener.ora Network Configuration File: G:oracleERP102networkadminlistener.ora
# Generated by Oracle configuration tools.
################
# Filename......: listener.ora
# Created.......: created by SAP AG, R/3 Rel. >= 6.10
# Name..........:
# Date..........:
# @(#) $Id: //bc/700-1_REL/src/ins/SAPINST/impl/tpls/ora/ind/LISTENER.ORA#4 $
################
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = ER1)
(ORACLE_HOME = G:oracleERP102)
)
(SID_DESC =
(SID_NAME = ID1)
(ORACLE_HOME = G:oracleERP102)
)
)
ADMIN_RESTRICTIONS_LISTENER = on
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = trigger)(PORT = 1527))
)
)
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/9826/viewspace-1033126/ ，如需转载，请注明出处，否则将追究法律责任。
