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

rongshiyuan發表於2012-09-27
View

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.




來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/17252115/viewspace-745219/，如需轉載，請註明出處，否則將追究法律責任。







相關文章