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 |
For more information about the SQLNET.ORA Editor, see Chapter 4.
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 |
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 |