Tracing the LSNRCTL Control Utility

Tracing the LSNRCTL Control Utility [ID 737530.1]
 Modified 16-DEC-2011     Type HOWTO     Status PUBLISHED 

In this Document
  Solution

Applies to:

Oracle Net Services - Version: 10.1.0.2.0 to 11.2.0.3 - Release: 10.1 to 11.2
Information in this document applies to any platform.
Checked for relevance on 16-APR-2010.

Goal

In the event that the listener does not start, the LSNRCTL utility still reads the listener.ora file and can be traced.

This feature was introduced in 10g and does not exist for 8i and 9i listeners.
See the special note for 11g usage.

Solution

Use the following parameters in the listener.ora file in order to trace LSNRCTL. See the special note for 11g usage.

Parameter Name               Default value
LSNRCTL_TRACE_LEVEL          OFF
LSNRCTL_TRACE_FILE           lsnrctl_.trc
LSNRCTL_TRACE_DIRECTORY      $ORACLE_HOME/network/trace
LSNRCTL_TRACE_UNIQUE         ON
LSNRCTL_TRACE_TIMESTAMP      ON

LSNRCTL_TRACE_LEVEL = [OFF | USER | SUPPORT | 16]
The trace level should always be set to "SUPPORT" or "16"
Setting only this parameter will normally be all that is needed for lsnrctl tracing.  The remaining parameters do not need to be set.

LSNRCTL_TRACE_FILE
Unless changed or unless LSNRCTL_TRACE_UNIQUE=OFF, this parameter will result in a file called lsnrctl_.trc
Oracle Support recommends not changing the default value.

LSNRCTL_TRACE_DIRECTORY
The default location is normally fine, but can be altered if needed.

LSNRCTL_TRACE_UNIQUE = [ON | OFF]
The default of ON should always be used. Setting this parameter to OFF will only create a single "lsnrctl.trc" file that is overwritten each time the listener is restarted.

LSRNCTL_TRACE_TIMESTAMP = [ON | OFF]
The default of ON should always be used. Setting to OFF will prevent timestamps from being logged.

In 11g, only the trace level parameter is used. All other parameters cannot be altered. The trace file follows the rules of 11g's "ADR" tracing - even in the case of ADR being disabled in the listener.

Parameter Name Defualt value
LSNRCTL_TRACE_LEVEL OFF
LSNRCTL_TRACE_FILE not used, file is ora__1.trc
LSNRCTL_TRACE_DIRECTORY not used, output directory is $HOME/oradiag*/lsnrctl///trace (or it can be located in $ORACLE_BASE/diag/lsnrctl///trace)
LSNRCTL_TRACE_UNIQUE not used (set to ON)
LSNRCTL_TRACE_TIMESTAMP not used (set to ON)

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/24867586/viewspace-713535/,如需转载,请注明出处,否则将追究法律责任。

转载于:http://blog.itpub.net/24867586/viewspace-713535/

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值