Method: 1. Use "show log_status" to view the monitoring log. If the "log_status" parameter is ON, it means the log is on; 2. Use "set log_status off" to change the parameter to off, and use "save_config" to save the configuration modification. ; 3. Restart the listening program.
The operating environment of this tutorial: Windows 10 system, Oracle 11g version, Dell G3 computer.
The monitoring log is controlled by the log_status parameter, ON means open, which is also the default value, and OFF means closed. You can view the status of parameters through the show command of the LSNRCTL tool.
Close the listener log:
# su - oracle $ lsnrctl LSNRCTL> set log_status off LSNRCTL> save_config LSNRCTL> show log_status Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)) LISTENER parameter "log_status" set to OFF
The above modifications will take effect immediately and there is no need to restart the listener.
Manually delete the listener log in the alert directory. (It is recommended to make necessary backup before deletion)
Method:
Lsnrctl>show log_status Lsnrctl>set log_status off //不产生监听日志，但监听程序还是要的 Lsnrctl>save_config //保存配置 Lsnrctl>stop //关闭监听程序并重启监听 Lsnrctl>start //重启监听
The example is as follows:
Recommended Tutorial: "Oracle Video Tutorial"
The above is the detailed content of How to turn off oracle monitoring log. For more information, please follow other related articles on the PHP Chinese website!