perl - 阻止 Oracle 生成 sqlnet.log 文件

Question

我在 perl 中使用 DBD::Oracle，每当连接失败时，客户端都会生成一个包含错误详细信息的 sqlnet.log 文件。

问题是，我已经有 perl 捕获的错误，并且在我自己的日志文件中。我真的不需要这些额外的信息。

那么，是否有停止创建 sqlnet.log 的标志或环境？

Answer 1

从金属链接

The logging is automatic, there is no way to turn logging off, but since you are on Unix server, you can redirect the log file to a null device, thus eliminating the problem of disk space consumption.

In the SQLNET.ORA file, set LOG_DIRECTORY_CLIENT and LOG_DIRECTORY_SERVER equal to a null device.

For example:

LOG_DIRECTORY_CLIENT = /dev/null
LOG_FILE_CLIENT = /dev/null

in SQLNET.ORA suppresses client logging completely.

To disable the listener from logging, set this parameter in the LISTENER.ORA file:

logging_listener = off