Thanks for the question, Gyan.
Asked: October 04, 2019 - 9:40 am UTC
Last updated: October 07, 2019 - 1:19 am UTC
Version: 11g/12c
Viewed 1000+ times
You Asked
I have check one production 12 DB environment. On this environment, there is not alert_<SID>.log files. Is the alert log file should there or missing?? if missing can we re-generate ??, So, it is difficult to monitoring the DC-Dr sync alerts and other critical warnings, errors, traces.
and Connor said...
First thing is make sure you are looking the right place. Run this on your database
SQL> select * from V$DIAG_INFO;
INST_ID NAME VALUE
---------- ------------------------------ ---------------------------------------------------------------
1 Diag Enabled TRUE
1 ADR Base C:\ORACLE
1 ADR Home C:\ORACLE\diag\rdbms\db19\db19
1 Diag Trace C:\ORACLE\diag\rdbms\db19\db19\trace
1 Diag Alert C:\ORACLE\diag\rdbms\db19\db19\alert
1 Diag Incident C:\ORACLE\diag\rdbms\db19\db19\incident
1 Diag Cdump C:\oracle\diag\rdbms\db19\db19\cdump
1 Health Monitor C:\ORACLE\diag\rdbms\db19\db19\hm
1 Default Trace File C:\ORACLE\diag\rdbms\db19\db19\trace\db19_ora_28568.trc
1 Active Problem Count 0
1 Active Incident Count 0
1 ORACLE_HOME C:\oracle\product\19
If you are looking in the right place, then check the permissions on the file system to make sure that nothing is stopping the database from writing there.
Rating
(2 ratings)
Is this answer out of date? If it is, please let us know via a Comment