lsncr无响应

yangly

日志中报错：

TNSLSNR for Linux: Version 10.2.0.1.0 - Production on 28-MAR-2011 09:19:02

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

Log messages written to /oracle/product/10.2.0/db_1/network/log/listener.log
Trace information written to /oracle/product/10.2.0/db_1/network/trace/listener.
trc
Trace level is currently 0

Started with pid=8422
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=JYTEST)(PORT=1521)))
Listener completed notification to CRS on start

TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
WARNING: Subscription for node down event still pending

 

sqlplus / as sysdba 查看数据库是打开的. 于是判断监听有问题. 运行lsnrctl status 没有反应. 在$ORACLE_HOME/network/log中竟然发现没有监听日志记录. 今天才想起oracle 11g的监听不在该位置.而是在$ORACLE_BASE/diag/tnslsnr/<instance_name>/listener/trace目录下.查看监听日志,有大量的警告 "WARNING: Subscription for node down event still pending" ,该警告信息原因为oracle监听繁忙导致产生子监听,可能发生冲突,导致监听失败.禁用子监听即可.

由于该监听器为默认,所以添加SUBSCRIBE_FOR_NODE_DOWN_EVENT_LISTENER=OFF到listner.ora中,然后重载监听,lsnrctl reload. 观察监听日志发现没有再产生该警告.