oracle关闭监听日志有影响吗,关闭监听的日志。

可以通过在listener.ora文件里增加

LOGGING_LISTENER = OFF

来关闭监听日志一般需要重启监听才能生效。

lsnrctl status可以查看当前监听的日志路径，和监听配置文件的路径。

[oracle@qa_143_199 ~]$ lsnrctl status

LSNRCTL for Linux: Version 11.1.0.7.0 - Production on 14-DEC-2010 11:06:10

Copyright (c) 1991, 2008, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.20.143.199)(PORT=1521)))

STATUS of the LISTENER

------------------------

Alias                     LISTENER

Version                   TNSLSNR for Linux: Version 11.1.0.7.0 - Production

Start Date                24-NOV-2010 22:59:38

Uptime                    19 days 12 hr. 6 min. 31 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFFListener Parameter File   /opt/oracle/products/11.1.0/network/admin/listener.ora

Listener Log File         /opt/oracle/diag/tnslsnr/qa_143_199/listener/alert/log.xml

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.20.143.199)(PORT=1521)))

Services Summary...

Service "crmg" has 1 instance(s).

Instance "crmg", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully