Oracle DBA之配置静态监听（listener registered statically）__listener_registered_the_oracleproduct_DESCRIPTION_

当前位置: 数据库>oracle

Oracle DBA之配置静态监听（listener registered statically）

来源: 互联网发布时间：2017-04-06

本文导语: （1）listener.ora 本次实验将配置静态监听到listener L1上，项目SID_LIST_L1为L1的静态监听配置信息： L1 = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = PC1255-20110528)(PORT = 1522)) ) ...

（1）listener.ora

本次实验将配置静态监听到listener L1上，项目SID_LIST_L1为L1的静态监听配置信息：

L1 =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = PC1255-20110528)(PORT = 1522))

)

SID_LIST_L1 =

(SID_LIST =

(SID_DESC =

(SID_NAME = PLSExtProc)

(Oracle_HOME = D:oracleproduct10.2.0db_1)

(PROGRAM = extproc)

)

(SID_DESC =

(GLOBAL_DBNAME = t01)

(ORACLE_HOME = D:oracleproduct10.2.0db_1)

(SID_NAME = t01)

)

（2）listener.ora文件编辑好后，使用reload重新读取该配置文件（reload同时也会重新注册动态监听）：

（

RELOAD Purpose Use the RELOAD command to reread the listener.ora file. This command enables you to add or change statically configured services without actually stopping the listener.

In addition, the database services, instances, service handlers, and listening endpoints that were dynamically registered with the listener will be unregistered and subsequently registered again.

http://download.oracle.com/docs/cd/A97630_01/network.920/a96581/lsnrctl.htm

）

LSNRCTL> status

正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=PC1255-20110528)(PORT=1522)))

LISTENER 的 STATUS

------------------------