Oracle Network Products Troubleshooting Guide
Server Trace and Log Parameter Descriptions
TRACE_LEVEL_SERVER
This parameter determines the level of trace detail produced for an Oracle server. Setting the trace level to OFF disables trace. Trace should be OFF except for short diagnostic sessions.
Configuration file: SQLNET.ORA
Default value: OFF
OK to change? yes
Range of values: [OFF | USER | ADMIN]
OFF = No user-specified tracing. This value can be used to disable trace. | |
USER = End-user level: Trace to provide additional information to identify user-induced error conditions such as: | |
- server installation errors
- runtime show-stopper errors (for example, protocol stack not loaded)
ADMIN = Administrator level: Trace to identify installation-specific problems, for substantiation of "finger pointing" in case of third-party stacks, and for the following situations: | |
- site configuration-specific failures
(for example, lookup files)
- configuration inconsistencies
- server installation errors
- errors in interaction with third-party software
TRACE_FILE_SERVER
This parameter controls the trace output filename for a TNS client application. By default, the filename on most operating systems is SQLNET.TRC. A new trace output file is generated for each trace session. On most operating systems, each trace file automatically appends the process identifier of the current process to the filename so that previous files are not overwritten. The format of the appended process identifier is platform specific and is described in the Oracle operating system-specific manual for your platform.
Configuration file: SQLNET.ORA
Default value: SQLNET
OK to change? yes
Ranges of values valid filename
Example:
TRACE_FILE_SERVER = SERVERA
On a UNIX machine, this example might generate a trace file called SERVERA_5798.TRC.
Note: On most operating systems, TNS appends the .TRC suffix to the trace filename, so there is no need to specify it in the configuration file.
TRACE_DIRECTORY_ SERVER
This parameter is used to override the placement of the trace output file for an Oracle server. The default location is specific to each operating system. See the Oracle operating system-specific manual for your platform for details.
Configuration file: SQLNET.ORA
Default value: See your Oracle platform-specific
documentation.
OK to change? yes
Range of values: valid directory
Example: See your Oracle platform-specific
documentation.
LOG_FILE_SERVER
This parameter controls the log filename for an Oracle server. By default the log file generated is called SQLNET.LOG. Log files always append new information to the end of the existing log until the administrator prunes the log file.
Configuration file: SQLNET.ORA
Default value: SQLNET
OK to change? yes
Ranges of values: valid filename
Example:
LOG_FILE_SERVER = SERVER
This example generates a log file called SERVER.LOG
Note: On most operating systems, TNS appends the .LOG suffix to the log filename, so there is no need to specify it in the configuration file.
LOG_DIRECTORY_ SERVER
This parameter is used to override the placement of the log output file for an Oracle server. The default location is specific to each operating system.
Configuration file: SQLNET.ORA
Default value: See your Oracle platform-specific
documentation.
OK to change? yes
Range of values: valid directory
Example: See your Oracle platform-specific
documentation.