记录下刚刚做的一个为一个数据库(t02)配置多个监听(listener)的实验,过程有点小曲折。
(1)新增两个测试的监听,listener.ora的配置内容(可纯手动编辑该文件或使用netca)如下:
(LISTENER为系统原有;L1、L2为测试用新增的监听)
# listener.ora Network Configuration File: D:\oracle\product\10.2.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
L2 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = PC1255-20110528)(PORT = 1523))
)
)
L1 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = PC1255-20110528)(PORT = 1522))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = PC1255-20110528)(PORT = 1521))
)
)
(2)配置tnsnames.ora,使数据库(t02)可同时使用以上3个监听:
# tnsnames.ora Network Configuration File: D:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
T01 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = PC1255-20110528)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = t01)
)
)
T02 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = PC1255-20110528)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = PC1255-20110528)(PORT = 1522))
(ADDRESS = (PROTOCOL = TCP)(HOST = PC1255-20110528)(PORT = 1523))
(CONNECT_DATA =
(SERVER = DEDICATED)