The steps used to invoke tracing are outlined here. Each step is fully described in
subsequent sections. The first step is to choose the component to be traced. You may trace a client, a server, or a listener. The steps to enable
tracing are very simple:
- For any component, you can invoke tracing by editing the component configuration file that corresponds to the component traced. The component configuration files are listener.ora, sqlnet.ora or names.ora.
- Execute or start the component to be traced. If the trace component configuration files are modified while the component is running, the
modified trace parameters will take effect the next time the component is invoked or restarted. Instructions for each component follow:
- Be sure to turn off tracing when you do not need it for a specific diagnostic purpose.
If you are having trouble pinging a server, and need a detailed trace, you can manually add the following two tracing parameters to your sqlnet.ora file to perform tracing on the TNSPING utility:
The next lesson discusses the location of the log and trace files on an Oracle server.