Question

Linux下查看监听状态的命令lsnrctl status，如何根据返回结果判断监听是正常启动

如下是我使用lsnrctl status命令的返回结果，请问是根据字段Alias LISTENER来判断监听时正常启动的么，如果不是正常启动的，返回结果会是什么样的？？ 本人菜鸟，求大神指点，菜鸟就别误人子弟了，本人根据查询返回的字段判断是否启动监听的，是要上生产机的。
[patrol@mail1 ~]$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 04-7月 -2014 16:16:21
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date 14-4月 -2014 09:42:35
Uptime 81 days 6 hr. 33 min. 45 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/11.2.0/grid/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/mail1/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.1.45.39)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.1.45.41)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "mail" has 1 instance(s).
Instance "mail1", status READY, has 1 handler(s) for this service...
Service "mailXDB" has 1 instance(s).
Instance "weixin1", status READY, has 1 handler(s) for this service...
The command completed successfully

Answer 1

用 oracle:~ # lsof -i:1521 如果有返回信息，就说明侦听是启用的，如果没有返回任何信息说明侦听是停用的，或者你用 lsnrctl start。

oracle@oracle:~> lsnrctl start
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 04-JUL-2014 18:28:35
Copyright (c) 1991, 2011, Oracle. All rights reserved.
TNS-01106: Listener using listener name LISTENER has already been started
返回以上信息，说明是启用的。

方法1：:

看 oracle监听是否启动 在CMD下运行如下命令就可以  lsnrctl status  

正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=spcc)(PORT=1525)))  

TNS-12541: TNS：无监听器  

TNS-12560: TNS: 协议适配器错误  

TNS-00511: 无监听器  

32-bit Windows Error: 61: Unknown error  

LSNRCTL> start listener1  

启动tnslsnr：请稍候...  

这表示没有启动。。  

方法2：  

如果是LINUX系统可以通过如下命令看进程在不在  

ps -ef|grep lsn   

看 oracle监听是否启动 在CMD下运行如下命令就可以

lsnrctl status

正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=spcc)(PORT=1525)))

TNS-12541: TNS：无监听器。TNS-12560: TNS: 协议适配器错误。TNS-00511: 无监听器

32-bit Windows Error: 61: Unknown error

LSNRCTL> start listener1

启动tnslsnr：请稍候...。这表示没有启动。。

如果是LINUX系统可以通过如下命令看进程在不在

ps -ef|grep lsn

Answer 2

用 oracle:~ # lsof -i:1521 如果有返回信息，就说明侦听是启用的，如果没有返回任何信息说明侦听是停用的，或者你用 lsnrctl start
oracle@oracle:~> lsnrctl start
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 04-JUL-2014 18:28:35
Copyright (c) 1991, 2011, Oracle. All rights reserved.
TNS-01106: Listener using listener name LISTENER has already been started
返回以上信息，说明是启用的

追问

在监听启用的时候，我用lsof -i:1521也是无任何返回信息的

Answer 3

Instance "XXX", status READY