方法一:
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
#--------------------------------------------
重启服务生效