Oracle Net Services - Tracing and Logging at a Glance

一、Oracle trace的相关参数

TRACE_LEVEL_[CLIENT|SERVER|LISTENER] = [0-16|USER|ADMIN|SUPPORT|OFF]
TRACE_FILE_[CLIENT|SERVER|LISTENER] =
TRACE_DIRECTORY_[CLIENT|SERVER|LISTENER] =
TRACE_UNIQUE_[CLIENT|SERVER|LISTENER] = [ON|TRUE|OFF|FALSE]
TRACE_TIMESTAMP_[CLIENT|SERVER|LISTENER] = [ON|TRUE|OFF|FALSE] #Oracle8i+
TRACE_FILELEN_[CLIENT|SERVER|LISTENER] = #Oracle8i+
TRACE_FILENO_[CLIENT|SERVER|LISTENER] = #Oracle8i+

LOG_FILE_[CLIENT|SERVER|LISTENER] =
LOG_DIRECTORY_[CLIENT|SERVER|LISTENER] =
LOGGING_LISTENER = [ON|OFF]

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

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

NAMESCTL.TRACE_LEVEL = [0-16|USER|ADMIN|SUPPORT|OFF]
NAMESCTL.TRACE_FILE =
NAMESCTL.TRACE_DIRECTORY =
NAMESCTL.TRACE_UNIQUE = [ON|OFF]NOTES ON TRACING 11g AND NEWER CLIENT/SERVER/LISTENER/CMAN

对于Oracle 11g，使用传统的Oracle net tracing时，必须添加下列参数

Sqlnet.ora file on either client or server:

DIAG_ADR_ENABLED=OFF

Listener.ora file:

DIAG_ADR_ENABLED_=OFF

CMAN.ORA:

DIAG_ADR_ENABLED=OFF
ADR_BASE=c:\your_directory