Listener Oracle Net Services Tracing on the Client and Server

Listener Oracle Net Services Tracing on the Client and Server

Enable or Disable trace on the Listener or Server level
Two ways for Server trace choose as you wish:
1. You can enable or disable trace on Server from listener.

--- Check the Trace Level
LSNRCTL> show trc_level
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
LISTENER parameter "trc_level" set to off
The command completed successfully

-- Enable the Trace
LSNRCTL> set trc_level 16
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
LISTENER parameter "trc_level" set to support
The command completed successfully

-- Check the trace file created on listener log file location
LSNRCTL> show trc_File
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
LISTENER parameter "trc_file" set to ora_9132_5280.trc
The command completed successfully

-- Disable the trace
LSNRCTL> set trc_level 0
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
LISTENER parameter "trc_level" set to off
The command completed successfully

2. Enable trace of Server by editing the SQLNET.ORA file of Server directory(listener is configured)
Go to the Server directory %ORACLE_HOME%\NETWORK\ADMIN folder and open SQLNET.ORA file and place following entries:

TRACE_LEVEL_SERVER = 16
TRACE_FILE_SERVER = client
TRACE_DIRECTORY_SERVER = E:\oracle12c\trace
TRACE_TIMESTAMP_SERVER = ON
TRACE_UNIQUE_SERVER = ON
TRACE_FILELEN_SERVER=10000
TRACE_FILENO_SERVER=10
DIAG_ADR_ENABLED= OFF

Enable or disable the Client SQLNET file trace
Go to the SQLNET file location of Oracle Client that is %ORACLE_CLIENT%\NETWORK\ADMIN folder and open SQLNET.ORA file and place all the given parameter in the SQLNET.ORA file.

TRACE_LEVEL_CLIENT = 16
TRACE_FILE_CLIENT = client
TRACE_DIRECTORY_CLIENT = E:\oracle12c\trace
TRACE_TIMESTAMP_CLIENT = ON
TRACE_UNIQUE_CLIENT = ON
TRACE_FILELEN_CLIENT=10000
TRACE_FILENO_CLIENT=10
DIAG_ADR_ENABLED= OFF

Parameter meaning

TRACE_LEVEL_[ CLIENT | SERVER | ] = Define the trace level 0 (no trace), 4 (user trace), 6 (admin trace), 16 (support all)
TRACE_FILE_[ CLIENT | SERVER | ] = Define the file name of trace file Default Server (srv_pid.trc) Client (sqlnet.trc) and listener (listener.trc)
TRACE_DIRECTORY_[ CLIENT | SERVER | ] = Define the directory location where trace generated. default is %ORACLE_HOME%\network\trace
TRACE_UNIQUE_[ CLIENT | SERVER | ] = Define ON append the same file and OFF doesnot append in same file.
TRACE_TIMESTAMP_[ CLIENT | SERVER | ] = Define ON place timestamp in each entry and OFF no timestamp
TRACE_FILELEN_[ CLIENT | SERVER | ] = Define the Size of trace file in bytes.
TRACE_FILENO_[ CLIENT | SERVER | ] = Define that file written in cycle fashion, rotate itself when last is filled write to first one.
LOG_FILE_[ CLIENT | SERVER | ] = Define the file name of log file.
LOG_DIRECTORY_[ CLIENT | SERVER | ] = Define the directory for log.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s