oracle 永久关闭listener日志

jiawang

在Oracle的各种日志中，监听日志算是比较大的，尤其是在windows平台，还存在监听日志过大导致监听异常的bug。

所以除了写脚本定期删日志文件之外，就是永久性的把监听写日志的功能关闭。


停止监听服务进程记录日志
[oracle@strong ~]$ lsnrctl set log_status off

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 04-MAY-2023 15:17:13

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

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

TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   Linux Error: 111: Connection refused
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
LISTENER parameter "log_status" set to OFF
The command completed successfully

保存配置信息
[oracle@strong ~]$ lsnrctl save_config
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 04-MAY-2023 15:17:43
Copyright (c) 1991, 2019, Oracle.  All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=strong)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   Linux Error: 111: Connection refused
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
Saved LISTENER configuration parameters.
Listener Parameter File   /u01/app/oracle/product/19.3.0/db_1/network/admin/listener.ora
Old Parameter File   /u01/app/oracle/product/19.3.0/db_1/network/admin/listener.bak
The command completed successfully
[oracle@strong ~]$

修改后listener.ora文件中就会多一条配置：LOGGING_LISTENER = OFF
[oracle@strong admin]$ more listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/19.3.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = strong)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )


SID_LIST_LISTENER =
   (SID_LIST =
        (SID_DESC =
          (GLOBAL_DBNAME = orcl)
          (ORACLE_HOME = /u01/app/oracle/product/19.3.0/db_1)
          (SID_NAME = orcl)   
        )   
)  


#----ADDED BY TNSLSNR 04-MAY-2023 15:18:04---
LOGGING_LISTENER = OFF
#--------------------------------------------
[oracle@strong admin]$

jiawang

也可以直接在istener.ora文件下添加logging_listener=off 参数，然后重启监听器实现。
su – oracle  
cd $ORACLE_HOME/network/admin  
vi listener.ora  
加入一行：  
logging_listener=off