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