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

shentao19890909

guoyJoe 发表于 2013-9-17 17:09
去服务器端看lsnrctl status

服务端是unknown和ready都有，那说明静态和动态都有。 那我怎么知道客户端是通过那个监听连接上去的？

Service "ora11g" has 2 instance(s).
  Instance "ora11g", status UNKNOWN, has 1 handler(s) for this service...
  Instance "ora11g", status READY, has 1 handler(s) for this service...

guoyJoe

你看一下用的是哪个服务，哪个端口？贴有所有信息来……。lsnrctl status

shentao19890909

guoyJoe 发表于 2013-9-17 17:13
你看一下用的是哪个服务，哪个端口？贴有所有信息来……。lsnrctl status

racle@linux_lbi_10:/oracle/app/product/11g/db/network/admin> lsnrctl status

LSNRCTL for Linux: Version 11.1.0.7.0 - Production on 05-JUN-2012 17:13:11

Copyright (c) 1991, 2008, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.1.0.7.0 - Production
Start Date                06-JUN-2012 01:56:02
Uptime                    496 days 17 hr. 45 min. 2 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /oracle/app/product/11g/db/network/admin/listener.ora
Listener Log File         /oracle/app/diag/tnslsnr/linux_lbi_10/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.71.180.82)(PORT=1521)))
Services Summary...
Service "ora11g" has 2 instance(s).
  Instance "ora11g", status UNKNOWN, has 1 handler(s) for this service...
  Instance "ora11g", status READY, has 1 handler(s) for this service...
Service "ora11gXDB" has 1 instance(s).
  Instance "ora11g", status READY, has 1 handler(s) for this service...
Service "ora11g_XPT" has 1 instance(s).
  Instance "ora11g", status READY, has 1 handler(s) for this service...
The command completed successfully


全部信息，如何判断？

guoyJoe

shentao19890909 发表于 2013-9-17 17:17
racle@linux_lbi_10:/oracle/app/product/11g/db/network/admin> lsnrctl status

LSNRCTL for Linux:  ...

ora76 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.71.180.76)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ora11g)
    )
  )
你连的是静态和动态两个。

shentao19890909

guoyJoe 发表于 2013-9-17 17:24
ora76 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.71.180.76)(PORT = 1521))

判断的依据是啥？跪求

Yong Huang

If you have both dynamic and static registration for the same service, the dynamic one will be used. You can tell by "lsnrctl service", which maintains cumulative counters for established and refused connections.

shentao19890909

Yong Huang 发表于 2013-9-17 23:02
If you have both dynamic and static registration for the same service, the dynamic one will be used. ...

oracle@linux_lbi_10:/oracle/app/product/11g/db/network/admin> lsnrctl service

LSNRCTL for Linux: Version 11.1.0.7.0 - Production on 06-JUN-2012 09:03:39

Copyright (c) 1991, 2008, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
Services Summary...
Service "ora11g" has 2 instance(s).
  Instance "ora11g", status UNKNOWN, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:150 refused:9088
         LOCAL SERVER
  Instance "ora11g", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:45670 refused:0 state:ready
         LOCAL SERVER
Service "ora11gXDB" has 1 instance(s).
  Instance "ora11g", status READY, has 1 handler(s) for this service...
    Handler(s):
      "D000" established:0 refused:0 current:0 max:1022 state:ready
         DISPATCHER <machine: linux_lbi_10, pid: 17046>
         (ADDRESS=(PROTOCOL=tcp)(HOST=linux_lbi_10)(PORT=60391))
Service "ora11g_XPT" has 1 instance(s).
  Instance "ora11g", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:45670 refused:0 state:ready
         LOCAL SERVER
The command completed successfully
客户端有近100个session在连接。
SQL> select count(1) from v$session t where t.USERNAME is not null;

  COUNT(1)
----------
        99
---------------------------------
怎么解释上面那些监听信息？
难道这99个session都是通过动态监听来连接的？

shentao19890909

guoyJoe 发表于 2013-9-17 17:24
ora76 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.71.180.76)(PORT = 1521))

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

guoyJoe

shentao19890909 发表于 2013-9-18 10:13
如何屏蔽动态注册？只让oracle有静态注册

再添加一个服务即可。

shentao19890909

guoyJoe 发表于 2013-9-18 10:33
再添加一个服务即可。

版主大人，再添加一个服务是啥意思？
能我我例子吗，或者网上这份资料的url，我没有搜到这方面资料。