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

 

posted @   钱若梨花落  阅读(741)  评论(0编辑  收藏  举报
(评论功能已被禁用)
编辑推荐:
· 记一次.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用户名密码规则
点击右上角即可分享
微信分享提示