LISTENER.LOG日志大小不能超过2GB

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