oracle监听日志文件过大

一、背景

oracle监听日志文件大小达到4G，不会往监听日志文件中写入新的日志，此时就要对监听日志进行清除。

二、清除监听日志

oracle的监听日志目录：
/u01/app/oracle/diag/tnslsnr/node01/listener/trace（node01是主机名）

1.查看监听状态

\[oracle@node01 listener\]$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 19-AUG-2021 03:24:09

Copyright © 1991, 2013, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=node01)(PORT=1521)))  
STATUS of the LISTENER

Alias LISTENER  
Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production  
Start Date 18-AUG-2021 17:53:57  
Uptime 0 days 9 hr. 30 min. 11 sec  
Trace Level off  
Security ON: Local OS Authentication  
SNMP OFF  
Listener Parameter File /u01/app/oracle/product/11.2.0/db\_1/network/admin/listener.ora  
Listener Log File /u01/app/oracle/diag/tnslsnr/node01/listener/alert/log.xml  
Listening Endpoints Summary…  
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=node01)(PORT=1521)))  
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))  
Services Summary…  
Service “orcl” has 1 instance(s).  
Instance “orcl”, status READY, has 1 handler(s) for this service…  
Service “orclXDB” has 1 instance(s).  
Instance “orcl”, status READY, has 1 handler(s) for this service…  
The command completed successfully

复制

监听状态是开启的，需要注意的是监听处于开启状态是不可以修改监听日志文件名或者删除监听日志文件的。

2.清除监听日志的方法

方法一、关闭监听清除监听日志

• 1.关闭监听

\[oracle@node01 listener\]$ lsnrctl stop

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 19-AUG-2021 03:38:19

Copyright © 1991, 2013, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=node01)(PORT=1521))) 
复制

The command completed successfully

• 2.清除监听日志

\[oracle@node01 trace\]$ rm -rf listener.log  
复制

也可以备份监听日志文件，然后再删除原有监听日志文件

\[oracle@node01 trace\]$ mv listener.log listener.log.bak  
\[oracle@node01 trace\]$ ll  
\-rw-r-----. 1 oracle oinstall 106920 Aug 19 03:24 listener.log.bak
复制

• 3.重新开启监听

\[oracle@node01 trace\]$ lsnrctl start

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 19-AUG-2021 03:41:19

Copyright © 1991, 2013, Oracle. All rights reserved.

Starting /u01/app/oracle/product/11.2.0/db\_1/bin/tnslsnr: please wait…

TNSLSNR for Linux: Version 11.2.0.4.0 - Production  
System parameter file is /u01/app/oracle/product/11.2.0/db\_1/network/admin/listener.ora  
Log messages written to /u01/app/oracle/diag/tnslsnr/node01/listener/alert/log.xml  
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=node01)(PORT=1521)))  
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

复制

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=node01)(PORT=1521)))  
STATUS of the LISTENER

Alias LISTENER  
Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production  
Start Date 19-AUG-2021 03:41:19  
Uptime 0 days 0 hr. 0 min. 4 sec  
Trace Level off  
Security ON: Local OS Authentication  
SNMP OFF  
Listener Parameter File /u01/app/oracle/product/11.2.0/db\_1/network/admin/listener.ora  
Listener Log File /u01/app/oracle/diag/tnslsnr/node01/listener/alert/log.xml  
Listening Endpoints Summary…  
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=node01)(PORT=1521)))  
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))  
The listener supports no services  
The command completed successfully  
\[oracle@node01 trace\]$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 19-AUG-2021 03:41:29

Copyright © 1991, 2013, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=node01)(PORT=1521)))  
STATUS of the LISTENER

Alias LISTENER  
Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production  
Start Date 19-AUG-2021 03:41:19  
Uptime 0 days 0 hr. 0 min. 10 sec  
Trace Level off  
Security ON: Local OS Authentication  
SNMP OFF  
Listener Parameter File /u01/app/oracle/product/11.2.0/db\_1/network/admin/listener.ora  
Listener Log File /u01/app/oracle/diag/tnslsnr/node01/listener/alert/log.xml  
Listening Endpoints Summary…  
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=node01)(PORT=1521)))  
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))  
Services Summary…  
Service “orcl” has 1 instance(s).  
Instance “orcl”, status READY, has 1 handler(s) for this service…  
Service “orclXDB” has 1 instance(s).  
Instance “orcl”, status READY, has 1 handler(s) for this service…  

复制

The command completed successfully
此时在监听日志目录就会再次生成一个监听日志文件listener.log

方法二、不关闭监听清除监听日志

• 1.查看当前监听状态

\[oracle@node01 listener\]$ lsnrctl

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 19-AUG-2021 03:24:13

Copyright © 1991, 2013, Oracle. All rights reserved.

Welcome to LSNRCTL, type “help” for information.

LSNRCTL> show  
The following operations are available after show  
An asterisk (\*) denotes a modifier or extended command:

rawmode displaymode  
rules trc\_file  
trc\_directory trc\_level  
log\_file log\_directory  
log\_status current\_listener  
inbound\_connect\_timeout startup\_waittime  
snmp\_visible save\_config\_on\_stop  
dynamic\_registration enable\_global\_dynamic\_endpoint  
oracle\_home pid  
connection\_rate\_limit valid\_node\_checking\_registration  
registration\_invited\_nodes registration\_excluded\_nodes

LSNRCTL> show log\_status  
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=node01)(PORT=1521)))  
LISTENER parameter “log\_status” set to ON  
复制

The command completed successfully

• 2.停止记录监听日志

LSNRCTL> set log\_status off  
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=node01)(PORT=1521)))  
LISTENER parameter “log\_status” set to OFF 

复制

The command completed successfully

• 3.清除监听日志

\[oracle@node01 trace\]$ rm -rf listener.log  
复制

也可以备份监听日志文件，然后再删除原有监听日志文件

\[oracle@node01 trace\]$ mv listener.log listener.log.bak  
\[oracle@node01 trace\]$ ll  
\-rw-r-----. 1 oracle oinstall 106920 Aug 19 03:24 listener.log.bak
复制

• 4.开启记录监听日志

LSNRCTL> set log\_status on  
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=node01)(PORT=1521)))  
LISTENER parameter “log\_status” set to ON  

复制

The command completed successfully

• 5.重新加载监听

LSNRCTL> reload  
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=node01)(PORT=1521)))  
The command completed successfully  

复制

此时在监听日志目录就会再次生成一个监听日志文件listener.log