ORACLE/ADMIN2011. 5. 2. 21:32
반응형

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.
반응형
Posted by [PineTree]