11g监听启动后自动关闭
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 06-SEP-2013 21:39:37Copyright (c) 1991, 2009, Oracle. All rights reserved.Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.67.6)(PORT=1522)))STATUS of the LISTENER------------------------Alias LISTENERVersion TNSLSNR for Linux: Version 11.2.0.1.0 - ProductionStart Date 28-AUG-2013 16:53:12Uptime 9 days 4 hr. 46 min. 25 secTrace Level offSecurity ON: Local OS AuthenticationSNMP OFFListener Parameter File /oracle/11g/network/admin/listener.oraListener Log File /oracle/diag/tnslsnr/dw1/listener/alert/log.xmlListening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.67.6)(PORT=1522)))Services Summary...Service "PLSExtProc" has 1 instance(s). Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...Service "dw" has 1 instance(s). Instance "dw", status UNKNOWN, has 1 handler(s) for this service...LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 06-SEP-2013 21:59:36Copyright (c) 1991, 2009, Oracle. All rights reserved.Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.67.6)(PORT=1522)))TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener Linux Error: 111: Connection refused检查监听日志../listener/alert/log.xml 中发现如下内容WARNING: Subscription for node down event still pending通过mos查看文档《'Warning: Subscription For Node Down Event Still Pending' In Listener Log (文档 ID 372959.1》Applies to:Oracle Net Services - Version 10.1.0.2.0 to 11.2.0.0 [Release 10.1 to 11.2]Information in this document applies to any platform.Checked for relevance on 29-Aug-2012This issue affects only 10g and newer listeners.SymptomsYou are receiving the following warning messages in the listener.log file constantly:'WARNING: Subscription for node down event still pending' ChangesThis may be a new installation or a recent upgrade to 10g or newer.CauseThese messages are related to the Oracle TNS Listener's default subscription to the Oracle Notification Service (ONS). In a non-RAC environment it is recommended to disable this subscription. This feature was introduced in Oracle 10g.SolutionSet the following parameter in the listener.ora:SUBSCRIBE_FOR_NODE_DOWN_EVENT_<listener_name>=OFFWhere <listener_name> should be replaced with the actual listener name configured in theLISTENER.ORA file.SUBSCRIBE_FOR_NODE_DOWN_EVENT_<listener_name> parameter is to be placed by itself on an empty line.It will be necessary to restart or reload the listener following the addition of this parameter.This will prevent the messages from being written to the log file and may also prevent the TNSListener from hanging periodically. See NOTE 340091.1Please Note: Setting SUBSCRIBE_FOR_NODE_DOWN_<listener_name> to OFF disables a necessary RAC functionality. The above workaround is recommended only for non-RAC environments.The issue may be present in all 10g and newer installations.Note: The use of this undocumented parameter may cause problems with the use of the Net Manager (NetMgr) configuration utility. See Note 437598.1.ReferencesNOTE:340091.1 - Intermittent TNS Listener Hang, New Child Listener Process ForkedNOTE:437598.1 - NetMGR May Error When Listener.ora File Contains:SUBSCRIBE_FOR_NODE_DOWN_EVENT设置SUBSCRIBE_FOR_NODE_DOWN_EVENT_LISTENER=OFF,重启监听恢复正常;