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

No comments:

ORA-00059: Maximum Number Of DB_FILES Exceeded in 19C database

When I am adding datafile to my 19C database facing the below error. SQL> alter tablespace DATA  add datafile '/u01/data/data15.dbf...