多个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)
)
)

[@more@]

我的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博客 ” ，链接：http://blog.itpub.net/9826/viewspace-1033126/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/9826/viewspace-1033126/