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

rongshiyuan發表於2012-09-27
原文網址 : http://blog.itpub.net/17252115/viewspace-745219/
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/，如需轉載，請註明出處，否則將追究法律責任。
                                            


                




相關文章