oracle 11G windows 2008系统 造成了监听死锁 报TNS-00505: 操作超时
最后分析 发现 LISTENER.LOG日志大小超过2GB
解决方案：
cd$ORACLE_HOME/network/log
lsnrctlset log_status off
mvlistener.log listener.bak
lsnrctlset log_status on
以下是我在gdimall2上的一个操作记录:
首先改变监听的日志记录状态:
$lsnrctlset log_status off
LSNRCTLfor HPUX: Version 9.2.0.8.0 - Production on 24-SEP-2008 10:17:46
Copyright(c) 1991, 2006, Oracle Corporation. All rights reserved.
Connectingto (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=gd_idb02)(PORT=1521)))
LISTENERparameter "log_status" set to OFF
Thecommand completed successfully
移动监听日志到另一个目录:
gd_idb02:[gdimall2-/oracle$]
$mv/oracle/app/oracle/product/9.2.0/network/log/listener.log /iarch/listener.log.bak
更改监听使其打开日志记录
$lsnrctlset log_status on
LSNRCTLfor HPUX: Version 9.2.0.8.0 - Production on 24-SEP-2008 10:18:39
Copyright(c) 1991, 2006, Oracle Corporation. All rights reserved.
Connectingto (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=gd_idb02)(PORT=1521)))
LISTENERparameter "log_status" set to ON
Thecommand completed successfully
检查发现新的日志已记录:
gd_idb02:[gdimall2-/oracle$]
$ ll/oracle/app/oracle/product/9.2.0/network/log/listener.log
-rw-rw-rw- 1 oracle dba 684 Sep 24 10:19/oracle/app/oracle/product/9.2.0/network/log/listener.log
原文：http://yiliang.blog.51cto.com/936874/1742378