静态监听的配置文件如下:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = ORCL)
(ORACLE_HOME = /oracle/database/11.2/db_1)
(SID_NAME = orcl)
)
(SID_DESC =
(GLOBAL_DBNAME = zszjkst)
(ORACLE_HOME = /oracle/database/11.2/db_1/)
(SID_NAME = zszjk)
)
)
GLOBAL_DBNAME :对应服务名,可以自定义
SID_NAME:对应实例名(区分大小写)
上面的静态监听配置启动后,监听信息如下:
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.50.14.65)(PORT=1521)))
Services Summary...
Service "ORCL" has 1 instance(s).
Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
Service "zszjkst" has 1 instance(s).
Instance "zszjk", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully