以前听客户说监听日志大于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 mylogWill 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_listenerLSNRCTL>set log_status OFFLSNRCTL>save_configThis will prevent this issue from arising in the future. This also stop the ADR logging.