Oracle Network Products Troubleshooting Guide
Names Server Trace and Log Parameter Descriptions
NAMES.TRACE_
LEVEL
This parameter controls the level of trace detailproduced for the Names Server. Setting the level to OFF disables trace. Trace should be OFF except for short diagnostic sessions.
Configuration file: NAMES.ORA
Default value: OFF
OK to change? yes
Ranges 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
NAMES.TRACE_FILE
This parameter generates the name of the output file from a Names Server trace session. By default the trace file generated by the Names Server is called NAMES. Note that for each trace session a trace output file is generated. On most operating systems, if NAMES.TRACE_UNIQUE is set to ON or TRUE in the NAMES.ORA configuration file, each trace file appends the process identifier of the current process to the filename so that previous files are not overwritten. If files are not overwritten with the process identifier, many files accumulate, which uses up alot of disk space. The format of the appended process identifier is platform specific and is described in Oracle platform-specific documentation.
Configuration file: NAMES.ORA
Default value: names
OK to change? yes
Ranges of values valid filename
Example:
NAMES.TRACE_FILE = NAMES_SUN_03
NAMES.TRACE_UNIQUE = TRUE
On a UNIX machine, this example might generate a trace file called NAMES_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.
NAMES.TRACE_
DIRECTORY
This parameter determines the name of the directory to which trace files from a Names Server trace session are written. The default value is specific to each operating system.
Note: You must set NAMES.TRACE_DIRECTORY in NAMES.ORA, then restart the Names Server. You cannot set this from NAMESCTL.
Configuration file: NAMES.ORA
Default value: names
OK to change? yes
Range of values: valid directory
Examples: See your Oracle platform-specific
documentation.
This parameter determines whether or not a unique trace file is created for each Names Server. By default, the value is OFF, and only one trace file is created for a Names Server. If the value is OFF, when a new trace file is created for a Names Server, it overwrites the existing file. If the value is set to ON, a process identifier is appended to the name of each trace file generated so that several can coexist.
The format of the appended process identifier is platform specific and is described in the Oracle operating system-specific manual for your platform. For example, on a UNIX machine the format would be similar to the following:
SERVERA_3123.TRC
Note: Trace files are usually very large. If this parameter is set to ON (or TRUE), the number of large trace files could interfere with machine performance. Therefore use it carefully.
NAMES.LOG_FILE
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.
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.
Configuration file: NAMES.ORA
Default value: NAMES.LOG
OK to change? yes
Ranges of values: valid filename
Example:
NAMES.LOG_FILE = names_server2
This example generates a log file called NAMES_SERVER2.
NAMES.LOG_
DIRECTORY
This parameter is used to override the placement of the log output file for a Names Server. The default location is specific to each operating system.
Configuration file: NAMES.ORA
Default value: See your Oracle operating system
documentation.
OK to change? yes
Range of values: valid directory
Example: See your Oracle platform-specific
documentation.