Oracle监听lsnrctl查询状态详解

转载 2012年03月24日 13:04:30

过lsnrctl查询到的状态显示如下

 

 

LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ocm1.oracle.domain)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date                17-MAY-2011 21:03:40
Uptime                    0 days 0 hr. 2 min. 49 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/10.2.1/db/network/admin/listener.ora
Listener Log File         /u01/app/oracle/product/10.2.1/db/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ocm1.oracle.domain)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ocm1.oracle.domain)(PORT=1522)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ocm1.oracle.domain)(PORT=1600)))
Services Summary...
Service "POD" has 1 instance(s).
  Instance "POD", status READY, has 1 handler(s) for this service...
Service "POD1" has 1 instance(s).
  Instance "POD", status UNKNOWN, has 1 handler(s) for this service...
Service "PODS" has 1 instance(s).
  Instance "POD", status READY, has 2 handler(s) for this service...
Service "pod_XPT" has 1 instance(s).
  Instance "POD", status READY, has 1 handler(s) for this service...
Service "repos" has 2 instance(s).
  Instance "repos", status UNKNOWN, has 1 handler(s) for this service...
  Instance "repos", status READY, has 1 handler(s) for this service...
Service "repos_XPT" has 1 instance(s).
  Instance "repos", status READY, has 1 handler(s) for this service...
The command completed successfully

 

 status详解

Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ocm1.oracle.domain)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ocm1.oracle.domain)(PORT=1522)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ocm1.oracle.domain)(PORT=1600)))

#此处说明该主机地址为ocm1.oracle.domain,开启的监听端口有1521,1522,1600


Services Summary...
Service "POD" has 1 instance(s).
  Instance "POD", status READY, has 1 handler(s) for this service...

#此处说明有一个服务名POD的服务,数据库实例名为POD,状态READY说明其目前处于动态注册


Service "POD1" has 1 instance(s).
  Instance "POD", status UNKNOWN, has 1 handler(s) for this service...

#此处说明有一个服务名为POD1的服务,数据库的实例名为POD,状态UNKNOWN说明其目前是静态注册


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

#此处说明有一个服务名为PODS的服务,数据库实例名为POD,状态READY说明其是动态注册

 

Service "repos" has 2 instance(s).
  Instance "repos", status UNKNOWN, has 1 handler(s) for this service...
  Instance "repos", status READY, has 1 handler(s) for this service...
The command completed successfully

#此处说明有一个服务名为repos的服务,对应数据库实例为repos,UNKNOWN,READY状态说明其目前有一个静态注册和一个动态注册

 

 LSNRCTL> services
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ocm1.oracle.domain)(PORT=1521)))
Services Summary...
Service "POD" has 1 instance(s).
  Instance "POD", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0 state:ready
         LOCAL SERVER
Service "POD1" has 1 instance(s).
  Instance "POD", status UNKNOWN, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0
         LOCAL SERVER
Service "PODS" has 1 instance(s).
  Instance "POD", status READY, has 2 handler(s) for this service...
    Handler(s):
      "D001" established:0 refused:0 current:0 max:1022 state:ready
         DISPATCHER <machine: ocm1.oracle.domain, pid: 28400>
         (ADDRESS=(PROTOCOL=tcp)(HOST=ocm1.oracle.domain)(PORT=37290))
      "D000" established:0 refused:0 current:0 max:1022 state:ready
         DISPATCHER <machine: ocm1.oracle.domain, pid: 28398>
         (ADDRESS=(PROTOCOL=tcp)(HOST=ocm1.oracle.domain)(PORT=37288))
Service "pod_XPT" has 1 instance(s).
  Instance "POD", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0 state:ready
         LOCAL SERVER
Service "repos" has 2 instance(s).
  Instance "repos", status UNKNOWN, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0
         LOCAL SERVER
  Instance "repos", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0 state:ready
         LOCAL SERVER
Service "repos_XPT" has 1 instance(s).
  Instance "repos", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0 state:ready
         LOCAL SERVER
The command completed successfully

 

service详解

Service "POD" has 1 instance(s).
  Instance "POD", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0 state:ready
         LOCAL SERVER

#名为POD的服务,对应数据库实例为POD,状态READY说明其处于动态注册

DEDICATED" established:0 refused:0 state:ready说明是专有连接,连接数为0拒绝数为0,状态:动态


Service "POD1" has 1 instance(s).
  Instance "POD", status UNKNOWN, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0
         LOCAL SERVER

#名为POD1的服务,对应数据库实例为POD,状态UNKNOWN说明其处于静态注册

DEDICATED" established:2 refused:0说明是专有连接,连接数为2拒绝数为0


Service "PODS" has 1 instance(s).
  Instance "POD", status READY, has 2 handler(s) for this service...
    Handler(s):
      "D001" established:0 refused:0 current:0 max:1022 state:ready
         DISPATCHER <machine: ocm1.oracle.domain, pid: 28400>
         (ADDRESS=(PROTOCOL=tcp)(HOST=ocm1.oracle.domain)(PORT=37290))
      "D000" established:0 refused:0 current:0 max:1022 state:ready
         DISPATCHER <machine: ocm1.oracle.domain, pid: 28398>
         (ADDRESS=(PROTOCOL=tcp)(HOST=ocm1.oracle.domain)(PORT=37288))

#名为PODS的服务,对应数据库实例名为POD的数据库,READY状态说明其为动态注册

"D001" established:0 refused:0 current:0 max:1022 state:ready

 "D000" established:0 refused:0 current:0 max:1022 state:ready

这里说明其为share模式,目前,两个dispatcher目前都连接为0,拒绝为0,最大数为1022,状态是动态注册

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

对应sql查询

SQL> show parameter dispatchers

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
dispatchers                          string
max_dispatchers                      integer
SQL> alter system set dispatchers='(protocol=tcp) (dispatchers=2)';
System altered.
SQL> show parameter dispatchers
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
dispatchers                          string      (protocol=tcp) (dispatchers=2)
max_dispatchers                      integer
SQL> select name,network,paddr,status from v$dispatcher;
NAME NETWORK                                                                          PADDR    STATUS
---- -------------------------------------------------------------------------------- -------- ----------------
D000 (ADDRESS=(PROTOCOL=tcp)(HOST=seagull)(PORT=37288))                               2A220390 WAIT
D001 (ADDRESS=(PROTOCOL=tcp)(HOST=seagull)(PORT=37290))                               2A220948 WAIT

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

Service "repos" has 2 instance(s).
  Instance "repos", status UNKNOWN, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0
         LOCAL SERVER
  Instance "repos", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0 state:ready
         LOCAL SERVER

#repos服务对应的实例有2个,但此处都为实例repos,一个为静态UNKNOWN,一个为动态READY,目前连接数都为0,拒绝也为0
The command completed successfully

 

相关文章推荐

java标签接口

标签接口真有那么重要吗?比如说很多初学者认为java.io.Serializable这样的接口,很多时候可用可不用,不用一样能执行对象系列化功能。为此,我们通过一个通俗而有趣的示例!这个示例是设计一个...
  • ylovep
  • ylovep
  • 2011-02-12 15:08
  • 1352

Oracle监听lsnrctl查询状态详解

lsnrctl查询到的状态显示如下     LSNRCTL> status Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(...

sql的一些基本操作

linux下Oracle显示中文乱码

CRT 客户端 添加数据后,查询内容中文的数据都是???,网上搜索下内容,解决方法如下: 1.Oracle数据库出现乱码的原因: 操作系统与服务器一致,但客户端与服务器字符集不一致 客户端与服务器一...

Linux下配置Oracle 监听

1. 修改监听器配置文件 Linux下Oracle监听器配置文件在:$ ORACLE_HOME/network/admin/listerer.ora, 如:  /bank/oracle...

Oracle 11g用户口令过期 Oracle错误代码:ORA-28002

导致密码消失的原因:Oracle 11g中默认的DEFAULT概要文件中口令有效期PASSWORD_LIFE_TIME默认值为180天。 当以客户端登陆Oracle提示ORA-28002,则基本可以确...

如何去除从windows上传到unix的前导符^M

编辑的用户数据文件完成后,需要传到服务器上,用dos2unix命令把文件在Windows下编辑时,每行的”^M”   删除,命令如下: #dos2unix 1.txt 1.txt ...

升级oracle版本流程

升级oracle版本流程 一、准备工作 下载Oracle补丁包,以root或oracle用户将补丁上传到服务器上,并解压该补丁。 二、数据备份 执行数据库全库备份,RMAN或exp或expdp等方式...

exp/imp与expdp/impdp区别

转载一: 在平常备库和数据库迁移的时候,当遇到大的数据库的时候在用exp的时候往往是需要好几个小时,耗费大量时间。oracle10g以后可以用expdp来导出数据库花费的时间要远小于exp花费的时间...

Oracle数据库查看用户状态

一、当前ORACLE用户的状态可查看视图DBA_USERS;一般情况下在使用的正常用户均处于OPEN状态。 1 SQL> select username,accou...
内容举报
返回顶部
收藏助手
不良信息举报
您举报文章:深度学习:神经网络中的前向传播和反向传播算法推导
举报原因:
原因补充:

(最多只允许输入30个字)