您好,欢迎来到三六零分类信息网!老站,搜索引擎当天收录,欢迎发信息

Oracle监听日志文件的管理

2026/1/10 3:00:00发布18次查看
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 loglsnrctl> 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 loglsnrctl> 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实例问题解决

该用户其它信息

VIP推荐

免费发布信息,免费发布B2B信息网站平台 - 三六零分类信息网 沪ICP备09012988号-2
企业名录 Product