10.04.2012 11:12
OlegON
 
219968.1
Цитата:
TRACE_LEVEL_[CLIENT|SERVER|LISTENER] = [0-16|USER|ADMIN|SUPPORT|OFF]
TRACE_FILE_[CLIENT|SERVER|LISTENER] = <FILE NAME>
TRACE_DIRECTORY_[CLIENT|SERVER|LISTENER] = <DIRECTORY>
TRACE_UNIQUE_[CLIENT|SERVER|LISTENER] = [ON|TRUE|OFF|FALSE]
TRACE_TIMESTAMP_[CLIENT|SERVER|LISTENER] = [ON|TRUE|OFF|FALSE] #Oracle8i+
TRACE_FILELEN_[CLIENT|SERVER|LISTENER] = <SIZE in KB> #Oracle8i+
TRACE_FILENO_[CLIENT|SERVER|LISTENER] = <NUMBER> #Oracle8i+

LOG_FILE_[CLIENT|SERVER|LISTENER] = <FILE NAME>
LOG_DIRECTORY_[CLIENT|SERVER|LISTENER] = <DIRECTORY NAME>
LOGGING_LISTENER = [ON|OFF]

TNSPING.TRACE_LEVEL = [0-16|USER|ADMIN|SUPPORT|OFF]
TNSPING.TRACE_DIRECTORY = <DIRECTORY>

NAMES.TRACE_LEVEL = [0-16|USER|ADMIN|SUPPORT|OFF]
NAMES.TRACE_FILE = <FILE NAME>
NAMES.TRACE_DIRECTORY = <DIRECTORY>
NAMES.TRACE_UNIQUE = [ON|OFF]
NAMES.LOG_FILE = <FILE NAME>
NAMES.LOG_DIRECTORY = <DIRECTORY>
NAMES.LOG_UNIQUE = [ON|OFF]

NAMESCTL.TRACE_LEVEL = [0-16|USER|ADMIN|SUPPORT|OFF]
NAMESCTL.TRACE_FILE = <FILE NAME>
NAMESCTL.TRACE_DIRECTORY = <DIRECTORY>
NAMESCTL.TRACE_UNIQUE = [ON|OFF]
нюансы для 11g
Цитата:
Sqlnet.ora file on either client or server:

DIAG_ADR_ENABLED=OFF


Listener.ora file:

DIAG_ADR_ENABLED_<listener_name>=OFF


CMAN.ORA:

DIAG_ADR_ENABLED=OFF
ADR_BASE=c:\your_directory
Цитата:
LOG AND TRACE PARAMETERS

This section provides a detailed description of each trace and log parameter.

TRACE LEVELS

TRACE_LEVEL_[CLIENT|SERVER|LISTENER] = [0-16|USER|ADMIN|SUPPORT|OFF]
Determines the degree to which Oracle Net tracing is provided.
Configuration file is SQLNET.ORA, LISTENER.ORA.
Level 0 is disabled - level 16 is the most verbose tracing level.
Listener tracing requires the Net Listener to be reloaded or restarted
after adding trace parameters to LISTENER.ORA.
Oracle Net (client/server) tracing takes immediate effect after tracing
parameters are added to SQLNET.ORA.
By default, the trace level is OFF.
OFF (equivalent to 0) disabled - provides no tracing.
USER (equivalent to 4) traces to identify user-induced error conditions.
ADMIN (equivalent to 6) traces to identify installation-specific problems.
SUPPORT (equivalent to 16) trace information required by OSS for troubleshooting.
TRACE FILE NAME

TRACE_FILE_[CLIENT|SERVER|LISTENER] = <FILE NAME>
Determines the trace file name.
Any valid operating system file name.
Configuration file is SQLNET.ORA, LISTENER.ORA.
Trace file is automatically appended with '.TRC'.
Default trace file name is SQLNET.TRC, LISTENER.TRC.
TRACE DIRECTORY
TRACE_DIRECTORY_[CLIENT|SERVER|LISTENER] = <DIRECTORY>
Determines the directory in which trace files are written.
Any valid operating system directory name.
Configuration file is SQLNET.ORA, LISTENER.ORA.
Directory should be writable by the connecting user and/or Oracle software owner.
Default trace directory is $ORACLE_HOME/network/trace.

UNIQUE TRACE FILES
TRACE_UNIQUE_[CLIENT|SERVER|LISTENER] = [ON|TRUE|OFF|FALSE]
Allows generation of unique trace files per connection.
Trace file names are automatically appended with '_<PID>.TRC'.
Configuration file is SQLNET.ORA, LISTENER.ORA.
Unique tracing is ideal for sporadic issues/errors that occur infrequently or randomly.
Default value is OFF
TRACE TIMING
TRACE_TIMESTAMP_[CLIENT|SERVER|LISTENER] = [ON|TRUE|OFF|FALSE]
A timestamp in the form of [DD-MON-YY 24HH:MI;SS] is recorded against each
operation traced by the trace file.
Configuration file is SQLNET.ORA, LISTENER.ORA
Suitable for hanging or slow connection issues.
Available from Oracle8i onwards.
Default value is is OFF.

MAXIMUM TRACE FILE LENGTH
TRACE_FILELEN_[CLIENT|SERVER|LISTENER] = <SIZE>
Determines the maximum trace file size in Kilobytes (Kb).
Configuration file is SQLNET.ORA, LISTENER.ORA.
Available from Oracle8i onwards.
Default value is UNLIMITED.
TRACE FILE CYCLING
TRACE_FILENO_[CLIENT|SERVER|LISTENER] = <NUMBER>
Determines the maximum number of trace files through which to perform cyclic tracing.
Configuration file is SQLNET.ORA, LISTENER.ORA.
Suitable when disk space is limited or when tracing is required to be enabled for long periods.
Available from Oracle8i onwards.
Default value is 1 (file).
LOG FILE NAME
LOG_FILE_[CLIENT|SERVER|LISTENER] = <FILE NAME>
Determines the log file name.
May be any valid operating system file name.
Configuration file is SQLNET.ORA, LISTENER.ORA.
Log file is automatically appended with '.LOG'.
Default log file name is SQLNET.LOG, LISTENER.LOG.

LOG DIRECTORY
LOG_DIRECTORY_[CLIENT|SERVER|LISTENER] = <DIRECTORY NAME>
Determines the directory in which log files are written.
Any valid operating system directory name.
Configuration file is SQLNET.ORA, LISTENER.ORA.
Directory should be writable by the connecting user or Oracle software owner.
Default directory is $ORACLE_HOME/network/log.
DISABLING LOGGING
LOGGING_LISTENER = [ON|OFF]
Disables Listener logging facility.
Configuration file is LISTENER.ORA.
Default value is ON.
ORACLE NET TRACE/LOG EXAMPLES

CLIENT (SQLNET.ORA)
...
trace_level_client = 16
trace_file_client = cli
trace_directory_client = /u01/app/oracle/product/9.0.1/network/trace
trace_unique_client = on
trace_timestamp_client = on
trace_filelen_client = 100
trace_fileno_client = 2
log_file_client = cli
log_directory_client = /u01/app/oracle/product/9.0.1/network/log
tnsping.trace_directory = /u01/app/oracle/product/9.0.1/network/trace
tnsping.trace_level = admin

SERVER (SQLNET.ORA)
...
trace_level_server = 16
trace_file_server = svr
trace_directory_server = /u01/app/oracle/product/9.0.1/network/trace
trace_unique_server = on
trace_timestamp_server = on
trace_filelen_server = 100
trace_fileno_server = 2
log_file_server = svr
log_directory_server = /u01/app/oracle/product/9.0.1/network/log

namesctl.trace_level = 16
namesctl.trace_file = namesctl
namesctl.trace_directory = /u01/app/oracle/product/9.0.1/network/trace
namesctl.trace_unique = on

LISTENER (LISTENER.ORA)
...
trace_level_listener = 16
trace_file_listener = listener
trace_directory_listener = /u01/app/oracle/product/9.0.1/network/trace
trace_timestamp_listener = on
trace_filelen_listener = 100
trace_fileno_listener = 2
logging_listener = off
log_directory_listener = /u01/app/oracle/product/9.0.1/network/log
log_file_listener=listener

NAMESERVER TRACE (NAMES.ORA)
....
names.trace_level = 16
names.trace_file = names
names.trace_directory = /u01/app/oracle/product/9.0.1/network/trace
names.trace_unique = off

CONNECTION MANAGER TRACE (CMAN.ORA)
...
tracing = yes

10g and newer CMAN tracing is set using the following parameters under PARAMETER_LIST:

TRACE_LEVEL=SUPPORT

Additionally, cyclic tracing is now available for CMAN using:


TRACE_FILELEN=<length of each file>
TRACE_FILENO=<number of files to generate cyclically>

See above explanation for cyclic trace parameters.

As mentioned above, 11g would require these additional trace parameters:

DIAG_ADR_ENABLED=OFF
ADR_BASE=c:\your_directory




References

NOTE:1011114.6 - SQL*NET V2 TRACING
NOTE:16658.1 - (7) Tracing SQL*Net/Net8
NOTE:395525.1 - How to Enable Oracle SQLNet Client , Server , Listener , Kerberos and External procedure Tracing from Net Manager
NOTE:39774.1 - LOG & TRACE Facilities on NET v2.
NOTE:454927.1 - Using and Disabling the Automatic Diagnostic Repository (ADR) with Oracle Net for 11g
NOTE:751432.1 - Further TNS Listener Tracing
Часовой пояс GMT +3, время: 12:29.

Форум на базе vBulletin®
Copyright © Jelsoft Enterprises Ltd.
В случае заимствования информации гипертекстовая индексируемая ссылка на Форум обязательна.