Oracle監聽日志文件的管理

1.到listener里面，查看對應的log_file和log_status [Oracle@bys3 log]$ lsnrctl LSNRCTL for Linux: Version 11.2.0.4.0 - Pro

1.到listener里面，查看對應的log_file和log_status [Oracle@bys3 log]$ lsnrctl
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 06-DEC-2013 10:27:11
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Welcome to LSNRCTL, type "help" for information.
LSNRCTL> show log_file
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=bys3.bys.com)(PORT=1521)))
LISTENER parameter "log_file" set to /u01/diag/tnslsnr/bys3/listener/alert/log.xml
The command completed successfully
LSNRCTL> show log_status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=bys3.bys.com)(PORT=1521)))
LISTENER parameter "log_status" set to ON
The command completed successfully
2.先去監聽日志的目錄里面并查看大小 從監聽里用show log_file得出日志文件的地址 ---測試機沒怎么用依然有8M大小的日志
[oracle@bys3 alert]$ du -sh log.xml
8.0M log.xml
3.現在可以關閉listener log LSNRCTL> set log_status off
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=bys3.bys.com)(PORT=1521)))
LISTENER parameter "log_statu". Try "help"

4.然后mv以前的日志文件 [oracle@bys3 alert]$ mv log.xml log.xmla
5.再開啟listerer log LSNRCTL> set log_status on
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=bys3.bys.com)(PORT=1521)))
LISTENER parameter "log_status" set to ON
The command completed successfully
LSNRCTL> show log_file
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=bys3.bys.com)(PORT=1521)))
LISTENER parameter "log_file" set to /u01/diag/tnslsnr/bys3/listener/alert/log.xml
The command completed successfully
6.查看日志文件已經自動生成了，原來的日志文件就可以慢慢處置了。 [oracle@bys3 alert]$ ls
log.xml log.xmla

相關閱讀：

Oracle監聽之動態監聽與靜態監聽特點

Oracle 11g RAC 環境下單實例非缺省監聽及端口配置

Oracle 監聽器日志配置與管理

Oracle錯誤- ORA-12514：TNS：無監聽程序

ORA-12514 監聽錯誤解決

Oracle監聽器出現的6種連接問題及其解決方法

Oracle LISTENER 未監聽到Oracle實例問題解決

聲明：本網頁內容旨在傳播知識，若有侵權等問題請及時與本網聯系，我們將在第一時間刪除處理。TEL:177 7030 7066 E-MAIL:11247931@qq.com