How to Run and View a Listener Trace. [ID 147446.1]

Applies to:

Oracle Application Object Library
Information in this document applies to any platform.
Checked for relevance on 15-Feb-2010

Solution

goal: How to Run and View a Listener Trace


fact: Oracle Application Object Library 10.7 G


fact: Oracle Application Object Library 10.7 N


fact: Oracle Application Object Library 11






fix:

1. Set the parameter TRACE_LEVEL_LISTENER=16 in the listener.ora file and
bounce the listener to start the trace.

(or)

At the command line type: 

lsnrctl trace 16

Note: This level of tracing generates a huge amount of information in the trace 
file. Turn it off once enough trace information is obtained.

2. Attempt to view a report from the client. This will produce a very detailed 
trace file of the connection attempt.

3. Set the parameter TRACE_LEVEL_LISTENER=0 in the listener.ora file and
bounce the listener to stop the trace.

(or)

At the command line type: 

lsnrctl trace OFF

4. Navigate to $ORACLE_HOME/bin

5. Run trcasst 

Ex: trcasst filename.trc>[outfile]

Where [outfile] is the name of the output file to contain the modified trace 
file.

6. View the output file

Reference:
See the Net8 Administrator's manual for details on Trace Assistant.