Oracle 12c 18c 19c: How to find out the Listener.log file location?

advertisements

_____________________________________________________________________________________________________________________

In latest versions of Oracle the listener.log file placed under the ADR_BASE/diag folder.

cd $ORACLE_BASE/diag/tnslsnr/$HOSTNAME/listener/alert

and the directory is

Directory:- /u01/app/oracle/diag/tnslsnr/<HOSTNAME>/listener/alert

OR

/u01/app/grid/diag/tnslsnr/<HOSTNAME>/listener/alert

File_name:- log.xml (default name)


SQL> select * from v$diag_info
   INST_ID NAME                    VALUE                                 CON_ID
---------- ------------------------------ ----------------------------------------
        1 Diag Enabled             TRUE                                     0
        1 ADR Base                 /u01/app/oracle                          0

advertisements

 

Diag Enabled: Indicates whether ADR is enabled or not

$ lsnrctl status

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 21-SEP-2019 12:49:41

Copyright (c) 1991, 2019, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=TESTBOX)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date                20-SEP-2019 07:58:40
Uptime                    1 days 4 hr. 51 min. 1 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/19.0.0/dbhome_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/TESTBOX/listener/alert/log.xml
Listening Endpoints Summary...

OR

$ lsnrctl status|grep log
Listener Log File         /u01/app/oracle/diag/tnslsnr/TESTBOX/listener/alert/log.xml

_____________________________________________________________________________________________________________________

Website Stats