动态监听和静态监听可以同时存在吗？

Yong Huang

> 难道这99个session都是通过动态监听来连接的？

Exclude local connections first. (Not all connections go through Oracle NET or SQL*Net.) Among all network connections, there's a possibility some connected to your instance immediately after it was started but before PMON registered with the listener (this delay can be as long as 60 seconds). Those few must have used the statically registered service. If all network connections came in 60 seconds after the instance was up, then you know for sure all of them (again, excluding local connections) came in through dynamically registered service.

> 如何屏蔽动态注册？只让oracle有静态注册

Why is dynamic registration not good for you?

You can try what guoyJoe suggested. Or change listener port from the default 1521 to some other number.

jayli426

Yong Huang 发表于 2013-9-19 01:19
> 难道这99个session都是通过动态监听来连接的？

Exclude local connections first. (Not all connectio ...

Mr huang， 你的意思就是说 有了当PMON 动态注册服务后，后续network发起的连接都走动态注册服务进来，这是有文档说明吗？能否通过实例证明一下呢？
不过这个知识了解似乎实际意义也不大，就像你说的，如果一定想区分动态静态，还不如搞个local_listener，换个port搞注册

Yong Huang

> 有了当PMON 动态注册服务后，后续network发起的连接都走动态注册服务进来，这是有文档说明吗？能否通过实例证明一下呢？

Oracle note
Incorrect SYSDATE shown when connected via Listener in RAC (Doc ID 1390015.1)
says
"When the listener has two service registrations, one static and one dynamic, then the dynamic one will be used."

As I said earlier, you can verify this with "lsnrctl service" and watch the counters for established.

traveldba

静态注册和动态注册本来就可以同时存在，同时存在可能使以防万一，怕动态注册注册不上，加个静态就不怕了。静态注册可以作为dba 维护使用。

shentao19890909

学习了，各位。目前针对这个点已经具备清晰的思路了。多谢各位的讨论！

默认有动态监听，配置了静态监听后，就两者同时存在了。

282789692

我也在oracle10g安装中遇到这个问题，很是纠结，查了下，也没有什么好的解决办法，求解啊？
Listener Parameter File   /oracle/product/11.2.0/rdbms/network/admin/listener.ora
Listener Log File         /oracle/diag/tnslsnr/ZD3DG401/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=22.188.21.114)(PORT=1521)))
Services Summary...
Service "ORAZ11G" has 2 instance(s).
  Instance "ORAZ11G", status UNKNOWN, has 1 handler(s) for this service...
  Instance "oraz11g", status READY, has 1 handler(s) for this service...
Service "oraz11gXDB" has 1 instance(s).
  Instance "oraz11g", status READY, has 1 handler(s) for this service...
The command completed successfully

hxb56

基本搞懂了 mark