where is the exact location path of alert log file on oracle 12c?
Question is closed for new answers.
meda Changed status to publish 16/07/2022
Starting from oracle database 11g the alert log directory path has the following structure:
ORACLE_BASE/diag/rdbms/LOWER(<db_unique_name>)/<instance_name>/trace
And we can verify the directory path with this query:
SQL> select value from v$diag_info where name = 'Diag Trace'; VALUE -------------------------------------------------------------------------------- D:\APP\ADMIN\VIRTUAL\diag\rdbms\primary\primary\trace SQL>
The name of the alert.log has ‘alert_<ORACLE_SID>.log‘ format.
meda Selected answer as best 18/02/2022