【翻译自mos文章】禁止写入日志到Sqlnet.log和Listener.log

本文介绍如何通过配置文件和命令行禁用Oracle Net Services的日志记录功能,包括客户端/服务器日志记录和监听器日志记录的方法。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >


禁止写入日志到Sqlnet.log和Listener.log

参考原文:
How to Disable Logging to the Sqlnet.log and the Listener.log (Doc ID 162675.1)

适用于:
Oracle Net Services
Information in this document applies to any platform.
Checked for relevance on 15-Jan-2012

解决方案:

Disable Client / Server logging

To disable Oracle Net logging to the sqlnet.log file, add the following parameters
and values to the SQLNET.ORA file:

Unix: LOG_DIRECTORY_CLIENT = /dev/null OR LOG_FILE_CLIENT = /dev/null

Windows: LOG_DIRECTORY_CLIENT = NULL

Default  location of the net admin files is ORACLE_HOME/network/admin
Any process already running will continue to log to the sqlnet.log file, untill it is restarted.



Disable Listener Logging

Method 1.
In order to disable logging without stopping the listener, using the LSNRCTL command as follows:

LSNRCTL>set current_listener <listener_name> (if not using default LISTENER)
LSNRCTL>set LOG_STATUS off
LSNRCTL>save_config


If you're trying to disable listener logging temporarily, do not issue SAVE_CONFIG.
Once listener logging is disabled, you can now safely delete or archive the existing listener log.
To restore logging again and/or to create a new listener log, simply enable logging as follows:

LSNRCTL>set current_listener <listener_name> (if not using default LISTENER)
LSNRCTL>set LOG_STATUS on





Method 2.
You can also edit the LISTENER.ORA file and set LOGGING_<listener_name> to OFF LOGGING_<listener_name>=OFF
This requires that a lsnrctl reload or restart take place in order to pick up the changes.
Listener.ora file location can be found with command lsnrctl status, showing the file is use by the listener.



Warning! Disabling Oracle Net logging is not recommended and should only be used under particular circumstances and/or under instruction by Oracle Support.

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值