Enable Tracing Oracle Listener

Just in case if you need to generate trace of Listener Do the following:

vi /u01/oracle/11.2/network/admin/listener.ora

And add the Following:

TRACE_LEVEL_listener=support
TRACE_TIMESTAMP_listener=true

valid values for trace level can be from following depending upon the information required.

user or 4 for user trace information
admin or 10 for administration trace information
support or 16 for Oracle Support Services trace information

Bounce the Listener and check the location of trace files, this will also provide you the information about the parameter and log files.

[oracle@TOSHdb trace]$ lsnrctl stat
LSNRCTL for Linux: Version 11.2.0.1.0 – Production on 21-MAR-2011 10:24:44
Copyright (c) 1991, 2009, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
————————
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.1.0 – Production
Start Date                21-MAR-2011 09:44:43
Uptime                    0 days 0 hr. 40 min. 3 sec
Trace Level               support
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/oracle/11.2/network/admin/listener.ora
Listener Log File         /u01/oracle/diag/tnslsnr/11g/listener/alert/log.xml
Listener Trace File       /u01/oracle/diag/tnslsnr/11g/listener/trace/ora_6339_47673611031200.trc
Listening Endpoints Summary…
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=TOSH)(PORT=1521)))
Services Summary…
Service “TOSH” has 1 instance(s).
Instance “TOSH”, status READY, has 1 handler(s) for this service…
Service “TOSHXDB” has 1 instance(s).
Instance “TOSH”, status READY, has 1 handler(s) for this service…
The command completed successfully

Leave a Comment