My Oracle Support Banner

How to set Oracle Net Listener Tracing Dynamically or at the LSNRCTL Prompt (Doc ID 1940914.1)

Last updated on JANUARY 16, 2025

Applies to:

Oracle Net Services - Version 11.2.0.1 and later
Oracle Database - Enterprise Edition - Version 8.0.3.0 and later
Oracle Cloud Infrastructure - Exadata Cloud Service - Version N/A and later
Gen 2 Exadata Cloud at Customer - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Information in this document applies to any platform.

Goal

 This document is intended to clarify that from 11.2 onwards, there is no need to first set any tracing parameters under listener.ora or reload the listener to activate listener tracing with timestamps.
Listener tracing can be enabled dynamically through 'set trc_level' command in lsnrctl utility. Independent if ADR is or not enabled, the trace is created with timestamps.

Limitation
~~~~~~~~
Please note that if the ADMIN_RESTRICTIONS_<listener_name> is set to ON for the Listener, then this cannot be done. This parameter needs to be set to OFF or commented out for Dynamic commands to work.

 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Goal
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.