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