oracle 注册监听工具,oracle监听器动态注册于静态注册的区别

即静态注册，listener不知道实例的状态，只有在进程通过其连接数据库时才能知道，如果你想使用远程管理数据库就使用静态监听

动态注册：listener实时的都知道实例的状态，数据库在关闭的时候会动态的从listener中注销，所以远程管理数据库的启动和停止就不行了。

4，如何判断是静态注册还是动态注册

(1) 可以通过配置文件判断

动态注册

SID_LIST_LISTENER =(SID_LIST =(SID_DESC =(PROGRAM = extproc)(SID_NAME = PLSExtProc)(ORACLE_HOME = D:\oradata\orcl)))

静态注册

SID_LIST_LISTENER =(SID_LIST =(SID_DESC =(PROGRAM = extproc)(SID_NAME = PLSExtProc)(ORACLE_HOME = D:\oradata\orcl))(SID_DESC =(GLOBAL_DBNAME = orcl)(ORACLE_HOME = D:\oradata\orcl)(SID_NAME = ORCL))(SID_DESC =(GLOBAL_DBNAME = orcl1)(ORACLE_HOME = D:\oradata\orcl)(SID_NAME = ORCL)))

通过查看虽然可以大致看出，但是这种方法并不能和明确的现实数据库在运行时的实际情况

(2) lsnrclt status

----静态注册是这样的 都是unknow

Services Summary...

Service "PLSExtProc" has 1 instance(s).

Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...

Service "jeff" has 1 instance(s).

Instance "JEFF", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully

-----动态注册是这样的

Services Summary...

Service "JEFF" has 1 instance(s).

Instance "JEFF", status READY, has 1 handler(s) for this service...

Service "JEFFXDB" has 1 instance(s).

Instance "JEFF", status READY, has 1 handler(s) for this service...

Service "JEFF_XPT" has 1 instance(s).

Instance "JEFF", status READY, has 1 handler(s) for this service...

Service "PLSExtProc" has 1 instance(s).

Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully

3,有时候会碰到即使listener起来也不能连接到数据库的情况 。会报一个ORA-12514 ，

运行lsnrctls status 是这个样子的 ，说明没有服务没有注册进来

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=r1)(PORT=1521)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))

Services Summary...

Service "PLSExtProc" has 1 instance(s).

Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully

解决方法：

alter system register; ---手动将服务注册到listener中