oracle关闭listener.log日志

最新推荐文章于 2024-08-27 14:08:45 发布

转载最新推荐文章于 2024-08-27 14:08:45 发布 · 3.3k 阅读

oracle 专栏收录该内容

4 篇文章

订阅专栏

本文介绍两种关闭Oracle数据库监听器日志记录的方法：通过LSNRCTL命令行工具和直接编辑listener.ora配置文件。适用于Oracle 11g版本。

方法一：

Microsoft Windows [版本 6.1.7601]
版权所有 (c) 2009 Microsoft Corporation。保留所有权利。

C:\Users\Administrator>lsnrctl

LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 13-MAR-2015 16:27
:09

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

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> set log_status off
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
LISTENER parameter "log_status" set to OFF
The command completed successfully

LSNRCTL> save_config
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
Saved LISTENER configuration parameters.
Listener Parameter File D:\oracle\product\11.2.0\dbhome_1\network\admin\listen
er.ora
Old Parameter File D:\oracle\product\11.2.0\dbhome_1\network\admin\listener.ba
k
The command completed successfully
LSNRCTL>

方法二：

修改%ORACLE_HOME%\NETWORK\ADMIN\listener.ora 文件

# listener.ora Network Configuration File: D:\Oracle\product\11.2.0\dbhome_2\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = V3PM)
(ORACLE_HOME = D:\oracle\product\11.2.0\dbhome_1)
(SID_NAME = V3PM)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = V3-SQL)(PORT = 1521))
)
)

SUBSCRIBE_FOR_NODE_DOWN_EVENT_LISTENER=OFF
INBOUND_CONNECT_TIMEOUT_LISTENER = 0
DIAG_ADR_ENABLED_LISTENER = OFF

ADR_BASE_LISTENER = D:\oracle

#----ADDED BY TNSLSNR 13-MAR-2015 16:28:43---
LOGGING_LISTENER = OFF
#--------------------------------------------