win11.2.0.4lsnrctl status hang

以前听客户说监听日志大于4G，监听出现问题。本次另一个客户也出现这个问题，表现为监听lsnrctl start,status长久hang住

匹配mos

WINDOWS: Listener Hangs & Lsnrctl Commands Are Slow or Hang (Doc ID 1319797.1) 

APPLIES TO:
Oracle Net Services - Version 11.1.0.7 to 18.1.0.0.0 [Release 11.1 to 18.1]
Microsoft Windows x64 (64-bit)
Microsoft Windows (32-bit)
This issue is limited to the Windows OS.

问题，监听日志大于4️⃣g，因此需要备份清理。

Since ADR Diagnostics are enabled for this listener these steps cannot be done dynamically using the lsnrctl utility. 
e.g.

LSNRCTL>set log_file mylog

Will yield:  TNS-01251: Cannot set trace/log directory under ADR.

However, it is possible to disable the flat file listener logging using the following commands:

LSNRCTL>set current_listener <listener_name>
LSNRCTL>set log_status OFF
LSNRCTL>save_config

This will prevent this issue from arising in the future.  This also stop the ADR logging.

 

转载于:https://www.cnblogs.com/lvcha001/p/10747148.html