Oracle listener.log 不断增大的问题解决

axq6607b14

我们的目的是：不影响生产系统，移除并重新生成listener.log：

*                                                                             *
* Welcome to solaris Version 9 *
*

#
#
# su - oracle
$ cd /oracle/product/10.2.0/db_1/network/log/   
$ ls -l
total 6136904
-rw-r-----   1 oracle   oinstall 3139249490 Jan 20 19:03 listener.log
-rw-r--r--   1 oracle   oinstall    2617857 Jan 17 02:08 sqlnet.log
$
$
$ lsnrctl set log_status off

LSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.1.0 - Production on 20-1月 -2009 19:10:53

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=mes_ora)(PORT=1521)))
LISTENER parameter "log_status" set to OFF
The command completed successfully
$ mv listener.log listener.bak
$ ls -l
total 6137000
-rw-r-----   1 oracle   oinstall 3139300680 Jan 20 19:10 listener.bak
-rw-r--r--   1 oracle   oinstall    2617857 Jan 17 02:08 sqlnet.log
$ lsnrctl set log_status on

LSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.1.0 - Production on 20-1月 -2009 19:11:10

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=mes_ora)(PORT=1521)))
LISTENER parameter "log_status" set to ON
The command completed successfully
$ ls -l
total 6137016
-rw-r-----   1 oracle   oinstall 3139300680 Jan 20 19:10 listener.bak
-rw-r--r--   1 oracle   oinstall       6416 Jan 20 19:11 listener.log
-rw-r--r--   1 oracle   oinstall    2617857 Jan 17 02:08 sqlnet.log
$ lsnrctl status

LSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.1.0 - Production on 20-1月 -2009 19:11:54

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=mes_ora)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.1.0 - Production
Start Date                29-11月-2008 05:55:53
Uptime                    52 days 13 hr. 16 min. 4 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      ON
Listener Parameter File   /oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File         /oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=loopback)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "jnmes" has 1 instance(s).
Instance "jnmes", status READY, has 1 handler(s) for this service...
Service "jnmesXDB" has 1 instance(s).
Instance "jnmes", status READY, has 1 handler(s) for this service...
Service "jnmes_XPT" has 1 instance(s).
Instance "jnmes", status READY, has 1 handler(s) for this service...
The command completed successfully
$

listener.bak 怎么处理就不用多说了吧！