Oracle Network Products Troubleshooting Guide

Contents Index Home Previous Next

Valid SQLNET.ORA Diagnostic Parameters

The SQLNET.ORA file may contain optional parameters to control logging and tracing of clients and servers, and optional parameters for tracing the NAMESCTL utility and the TNSPING utility.

Parameters for Clients and Servers

The following table shows the valid SQLNET.ORA parameters used in logging and tracing of SQL*Net version 2 clients and servers. A more detailed description of each parameter is available in Appendix A, "Trace and Log Parameter Reference".

Table 3 - 2. SQLNET.ORA Diagnostic Parameters

Parameters Default Values Example (DOS client, UNIX server)
TRACE_LEVEL_CLIENT OFF [OFF | USER |ADMIN] TRACE_LEVEL_CLIENT=USER
TRACE_FILE_CLIENT SQLNET.TRC string TRACE_FILE_CLIENT=CLIENT
TRACE_DIRECTORY_CLIENT O/S specific valid directory TRACE_DIRECTORY_CLIENT= c:\NET\ADMIN
TRACE_UNIQUE_CLIENT OFF [ON|OFF] TRACE_UNIQUE_CLIENT=ON
LOG_FILE_CLIENT SQLNET.LOG string LOG_FILE_CLIENT=CLIENT
LOG_DIRECTORY_CLIENT O/S specific valid directory LOG_DIRECTORY_CLIENT=c:\NET\ADMIN
TRACE_LEVEL_SERVER OFF [OFF | USER | ADMIN] TRACE_LEVEL_SERVER=ADMIN
TRACE_FILE_SERVER SQLNET.TRC string TRACE_FILE_SERVER=unixsrv_2345.trc
TRACE_DIRECTORY_SERVER O/S specific valid directory TRACE_DIRECTORY_SERVER=/tmp/trace
LOG_FILE_SERVER SQLNET.LOG string LOG_FILE_SERVER=unixsrv.log
LOG_DIRECTORY_SERVER O/S specific valid directory LOG_DIRECTORY_SERVER=/tmp/trace
Note: You control both log and trace parameters for the client through Oracle Network Manager. You can also control trace parameters for the client through the SQLNET.ORA Editor. You control log and trace parameters for the server by manually adding the desired parameters to the SQLNET.ORA file.

For more information about the SQLNET.ORA Editor, see Chapter 4.

Parameters for Names Control Utility

The following table shows the valid SQLNET.ORA parameters used in tracing the Names Control Utility. A more detailed description of each parameter is available in Appendix A, ``Trace and Log Parameter Reference".

Note: You must add these parameters manually to the SQLNET.ORA file. You cannot create them using Oracle Network Manager.

Table 3 - 3. NAMESCTL Utility Diagnostic Parameters

Parameters Default Values Example (UNIX server)
NAMESCTL.TRACE_LEVEL OFF [OFF | USER | ADMIN] NAMESCTL.TRACE_LEVEL=user
NAMESCTL.TRACE_FILE namesctl.trc file NAMESCTL.TRACE_FILE=nc_south.trc
NAMESCTL.TRACE_DIRECTORY O/S specific directory NAMESCTL.TRACE_DIRECTORY= /oracle7/network/trace
NAMESCTL.TRACE_UNIQUE FALSE TRUE/FALSE or ON/OFF NAMESCTL.TRACE_UNIQUE=TRUE

Parameters for TNSPING

If you want to trace the TNSPING utility, you can add these parameters to SQLNET.ORA.

Note: You can add these parameters to the SQLNET.ORA file using the SQLNET.ORA Editor. You cannot create them using Oracle Network Manager.

For more information about the SQLNET.ORA Editor, see Chapter 4.

Table 3 - 4. TNSPING Diagnostic Parameters

Parameters Default Values Example (UNIX server)
TNSPING.TRACE_LEVEL OFF [OFF | USER | ADMIN] TNSPING.TRACE_LEVEL=user
TNSPING.TRACE_DIRECTORY O/S specific directory TNSPING.TRACE_DIRECTORY= /oracle7/network/trace


Contents Index Home Previous Next