一、背景
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