Enable or Disable trace on the Listener
Enable or Disable trace on the Listener or Server level
Two ways for Server trace choose as you wish
- 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
Note: Parameter meaning used in SQLNET file
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 doesn't 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.