Alert and Listener log path in Oracle 12C database

                        Alert log text file path in 12C

1. Find diag location

SQL> SELECT name,VALUE FROM V$DIAG_INFO where name = 'Diag Alert';

NAME       VALUE

---------- -----------------------------------------

Diag Alert  /u01/app/oracle/diag/rdbms/host_SID/SID/alert

2. For text file move to trace folder instead of alert folder.

/u01/app/oracle/diag\rdbms\xe\xe\trace

SQL> Show parameter background_dump_dest

NAME                   TYPE        VALUE

---------------------- ----------- ------------------------------

background_dump_dest   string      /u01/app/oracle\DBHOMEXE\RDBMS\TRACE

Listener log path

1. Find the diag parameter location

SQL> show parameter diag

NAME              TYPE        VALUE

----------------- ----------- -------------

diagnostic_dest   string      /u01/app/oracle

2. For text file:

$DIAG_LOCATION   /u01/app/oracle\listener\trace\listener.log

3. For XML File:

$DIAG_LOCATION    /u01/app/oracle\listener\alert\log.xml

You get the listener log location with lsnrctl status command

$LSNRCTL status