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

 

Oracle监听状态查看

前提:登录用户有dba权限,能够进行查看 查看状态命令:lsnrctl status启动监听:lsnrctl start关闭监听:lsnrctl stop...
  • wenxuechaozhe
  • wenxuechaozhe
  • 2017年07月30日 16:38
  • 853

命令检查oracle是否启动,监听是否正常

192.168.1.73 oracle/gense@1234 lsnrctl start sqlplus /nolog conn /as sysdba startup // linu...
  • lianghonglin0909
  • lianghonglin0909
  • 2015年12月18日 09:32
  • 5951

如何查看和启动oracle监听

开始菜单-->运行-->cmd-->lsnrctl status查看 如果没有启动 lsnrctl start; 回车
  • wocaocao69
  • wocaocao69
  • 2012年01月16日 16:23
  • 1907

windows 启动关闭Oracle监听和服务

经常要用数据库,让他自己启动的话,开机太慢,所以用命令启动方便点。    1.开启:     在运行中输入cmd,进入控制台,lsnrctl start回车,提示启动监听成功后 net sta...
  • wangjialiang
  • wangjialiang
  • 2012年08月15日 09:55
  • 38806

oracle监听器启动lsnrctl status例程的状态为unknown

以前同事问及为何数据库例程在监听器中状态为unnkown,这是何意.有何影响.查阅了资料,解决如下: # listener.ora Network Configuration File: E...
  • Eason_oracle
  • Eason_oracle
  • 2016年11月11日 10:42
  • 5532

Oracle监听lsnrctl查询状态详解

lsnrctl查询到的状态显示如下     LSNRCTL> status Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(...
  • levy_cui
  • levy_cui
  • 2016年04月13日 10:20
  • 1861

AIX oracle 监听问题处理

塔吉克 现场的系统报联接不上数据库   ORACLE 10g  AIX   检查监听,发现报错,错误如下     $ lsnrctl reload LSNRCTL for...
  • yobyin
  • yobyin
  • 2013年05月03日 16:32
  • 491

linux oracle(常用命令)启动、停止、监听

1、手动启动dbstart /u01/app/oracle/product/11.2.0/dbhome_1 (ORACLE_HOME)2、停止数据库dbshut /u01/app/oracle/pro...
  • liubinwyzbt
  • liubinwyzbt
  • 2016年09月04日 18:29
  • 4973

oracle 监听启动的时候 lsnrctl start 的显示 什么服务read unknown 之类的解释

Listener Status June 8, 2009 Tags: oracle listener     监听有三种状态:block、unkown、ready Service “+AS...
  • taodearyy
  • taodearyy
  • 2012年09月17日 09:52
  • 1332

Oracle error:Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...

首先说下环境吧:redhat 6.3,oracle11g; 本来设置的是oracle开机自动启动,谁知道开机后使用ps -ef | grep oracle 有进程,但是程序连接不了oracle;几经调...
  • fansy1990
  • fansy1990
  • 2013年06月13日 17:30
  • 10778
内容举报
返回顶部
收藏助手
不良信息举报
您举报文章:Oracle监听lsnrctl查询状态详解
举报原因:
原因补充:

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