Oracle的listener.log清理过程
1、关闭监听日志记录
lsnrctl set log_status off
2、备份 listener.log
mv listener.log listener.log_20210524
3、清空日志
echo /dev/null > listener.log
4、开启监听日志记录
lsnrctl set log_status on
--操作过程
[oracle@bsdb trace]$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 24-MAY-2021 18:30:38
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=bsdb)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date 21-MAR-2020 15:34:49
Uptime 429 days 2 hr. 55 min. 48 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /home/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
Listener Log File /home/app/oracle/diag/tnslsnr/bsdb/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=bsdb)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary...
Service "bsdb" has 1 instance(s).
Instance "bsdb", status READY, has 1 handler(s) for this service...
Service "factXDB" has 1 instance(s).
Instance "bsdb", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@bsdb trace]$ pwd
/home/app/oracle/diag/tnslsnr/bsdb/listener/trace
[oracle@bsdb trace]$ ls
listener.log listener.log_1025_bak listener.log_bak20181212
[oracle@bsdb trace]$ ll -thr
total 13G
-rw-r----- 1 oracle oinstall 2.3G Dec 12 2018 listener.log_bak20181212
-rw-r----- 1 oracle oinstall 3.5G Oct 25 2019 listener.log_1025_bak
-rw-r----- 1 oracle oinstall 7.3G May 24 18:32 listener.log
[oracle@bsdb trace]$
[oracle@bsdb trace]$ lsnrctl set log_status off
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 24-MAY-2021 18:34:31
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=bsdb)(PORT=1521)))
LISTENER parameter "log_status" set to OFF
The command completed successfully
[oracle@bsdb trace]$
[oracle@bsdb trace]$ mv listener.log listener.log_20210524
[oracle@bsdb trace]$ ll -thr
total 13G
-rw-r----- 1 oracle oinstall 2.3G Dec 12 2018 listener.log_bak20181212
-rw-r----- 1 oracle oinstall 3.5G Oct 25 2019 listener.log_1025_bak
-rw-r----- 1 oracle oinstall 7.3G May 24 18:34 listener.log_20210524
[oracle@bsdb trace]$ echo /dev/null > listener.log
[oracle@bsdb trace]$ lsnrctl set log_status on
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 24-MAY-2021 18:34:55
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=bsdb)(PORT=1521)))
LISTENER parameter "log_status" set to ON
The command completed successfully
[oracle@bsdb trace]$
[oracle@bsdb trace]$ ll -thr
total 13G
-rw-r----- 1 oracle oinstall 2.3G Dec 12 2018 listener.log_bak20181212
-rw-r----- 1 oracle oinstall 3.5G Oct 25 2019 listener.log_1025_bak
-rw-r----- 1 oracle oinstall 7.3G May 24 18:34 listener.log_20210524
-rw-r--r-- 1 oracle oinstall 2.3K May 24 18:34 listener.log
[oracle@bsdb trace]$
[oracle@bsdb trace]$ tail -10f listener.log
24-MAY-2021 18:35:03 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=bsdba))(SERVICE_NAME=bsdb)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=bsdba))) * (ADDRESS=(PROTOCOL=tcp)(HOST=2.10.3.2)(PORT=50670)) * establish * bsdb * 0
24-MAY-2021 18:35:03 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=bsdba))(SERVICE_NAME=bsdb)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=bsdba))) * (ADDRESS=(PROTOCOL=tcp)(HOST=2.10.3.2)(PORT=50672)) * establish * bsdb * 0
24-MAY-2021 18:35:04 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=bsdba))(SERVICE_NAME=bsdb)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=bsdba))) * (ADDRESS=(PROTOCOL=tcp)(HOST=2.10.3.2)(PORT=50674)) * establish * bsdb * 0
24-MAY-2021 18:35:04 * service_update * bsdb * 0
【推荐】国内首个AI IDE,深度理解中文开发场景,立即下载体验Trae
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· 记一次.NET内存居高不下排查解决与启示
· 探究高空视频全景AR技术的实现原理
· 理解Rust引用及其生命周期标识(上)
· 浏览器原生「磁吸」效果!Anchor Positioning 锚点定位神器解析
· 没有源码,如何修改代码逻辑?
· 全程不用写代码,我用AI程序员写了一个飞机大战
· MongoDB 8.0这个新功能碉堡了,比商业数据库还牛
· 记一次.NET内存居高不下排查解决与启示
· DeepSeek 开源周回顾「GitHub 热点速览」
· 白话解读 Dapr 1.15:你的「微服务管家」又秀新绝活了
2020-05-25 Oracle修改instance_name、db_name、db_unique_name、service_names
2020-05-25 oracle如何清除创建失败的索引
2020-05-25 Oracle ORA-06512&ORA-08103对象已不存在
2020-05-25 修改rac集群各种ip地址
2020-05-25 使用Oracle自带profile以及函数简单设定Oracle用户名密码规则