**一個 Listener (預設埠 1521) 即可服務多個資料庫** (SID/Service Name)。客戶端透過 TNS 別名指定 SERVICE_NAME 或 SID 連線至對應實例。
SERVICE_NAME (或 SID)




# $ORACLE_HOME/network/admin/listener.ora
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = HARRY)(PORT = 1521)))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC = (SID_NAME = PLSExtProc)(ORACLE_HOME = D:\DATABASE\Oracle81)(PROGRAM = extproc))
(SID_DESC = (GLOBAL_DBNAME = ORASUN)(ORACLE_HOME = D:\DATABASE\Oracle81)(SID_NAME = ORASUN))
(SID_DESC = (GLOBAL_DBNAME = ORAGCE)(ORACLE_HOME = D:\DATABASE\Oracle81)(SID_NAME = ORAGCE))
)
# $ORACLE_HOME/network/admin/tnsnames.ora
SMEST =
(DESCRIPTION =
(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)))
(CONNECT_DATA = (SERVICE_NAME = ORAGCE))
)
SMEDI =
(DESCRIPTION =
(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)))
(CONNECT_DATA = (SERVICE_NAME = ORASUN))
)
INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)))
(CONNECT_DATA = (SERVER = SHARED)(SERVICE_NAME = ORAGCE)(PRESENTATION = https://admin))
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)))
(CONNECT_DATA = (SID = PLSExtProc)(PRESENTATION = RO))
)
修改 listener.ora 後必須重啟 Listener 服務:
lsnrctl stop
lsnrctl start
# 或 Windows 服務管理員重啟 OracleTNSListener
ORACLE_HOMEORACLE_HOME/PATH 由啟動腳本動態設定HKLM\SOFTWARE\ORACLE\HOME0, HOME1…AL32UTF8
一張網卡綁定內網 IP 啟動 Listener 1521,另一張網卡綁定外網 IP 啟動 Listener 1522,並在 listener.ora 的 SID_LIST 註冊相同 SID,實現存取隔離。