oracle 10Grac不生成监听日志

oracle 10Grac不生成监听日志

环境：oracle 10.2.0.5.0

一 首先查看监听状态：

LSNRCTL> status

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=xx)(PORT=1521)(IP=FIRST)))

STATUS of the LISTENER

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

Alias LISTENER_xxxxxx1

Version TNSLSNR for Linux: Version 10.2.0.5.0 - Production

Start Date 14-OCT-2022 09:33:50

Uptime 263 days 0 hr. 38 min. 37 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /oracle/app/oracle/product/10.2.0/network/admin/listener.ora

Listener Log File /oracle/app/oracle/product/10.2.0/network/log/listener_xxxxxx1.log

Listening Endpoints Summary...

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

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

Services Summary...

Service "+ASM" has 1 instance(s).

Instance "+ASM1", status BLOCKED, has 1 handler(s) for this service...

Service "+ASM_XPT" has 1 instance(s).

Instance "+ASM1", status BLOCKED, has 1 handler(s) for this service...

Service "xx" has 2 instance(s).

Instance "xx", status READY, has 2 handler(s) for this service...

Instance "xx", status READY, has 1 handler(s) for this service...

The command completed successfully

监听状态正常。

二 查看是否禁止生成监听日志：

有两种禁止生成监听日志的方法：

1 log_status设为off

查看log_status是否为off

LSNRCTL> show log_status

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))

LISTENER parameter "log_status" set to ON

2 listener.ora 添加LOGGING_LISTENER=OFF

cat listener.ora也没有设置LOGGING_LISTENER=OFF

通过操作系统看listener.log时候发现有两个log,可能数据添加了多个监听

通过lsnrctl status 看到使用的监听为LISTENER_xxxxxx1

再来查看current_listener参数设置的监听

LSNRCTL> show current_listener

Current Listener is LISTENER

修改current_listener=LISTENER_xxxxxx1

（直接修改set current_listener LISTENER_xxxxxx1不会生效，需要先set log_status off，亲测，但不知道原理）

LSNRCTL> set log_status off

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))

LISTENER parameter "log_status" set to OFF

The command completed successfully

LSNRCTL> set current_listener LISTENER_xxxxxx1

Current Listener is LISTENER_xxxxxx2

LSNRCTL> set log_status on

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=xx)(PORT=1521)(IP=FIRST)))

LISTENER_ZXYYDB2 parameter "log_status" set to ON

The command completed successfully

LSNRCTL> show log_status

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))

LISTENER parameter "log_status" set to ON

监听日志已经有了新的日志。