Tracing the LSNRCTL Control Utility

ygzhou518發表於2011-12-19
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/，如需轉載，請註明出處，否則將追究法律責任。

相關文章