EM 13c, EM 12c : Alerts are not Raised for "DB Alert Log" / "Alert Log" Metrics of Target Database if DB and Agent are Installed by Different OS users (Doc ID 2137632.1)

Last updated on DECEMBER 06, 2021

Applies to:

Symptoms

Using Enterprise Manager (EM) to monitor a target database, whose alert.log reports multiple ORA- errors. However, no alerts are raised for the "DB Alert Log" or the "Alert Log" metric of this target database, though the thresholds match and the ORA- error is not part of the Filter expression for the "Generic alert log error" metric.

The <AGENT_INST>/sysman/log/emagent_perl.trc file reports the below errors:

alertlog.pl: Tue May 3 18:33:46 2016: WARN: target: FAD7524FDEE1E951D878EAA8FD6AAA8B; unable to open alert log at 
/u01/app/oracle/product/11.2.0/diag/rdbms/orcl/ORCL/trace/alert_orcl.log
.....................
alertlog_dedup.pl: Tue May 3 18:36:52 2016: WARN: target: FAD7524FDEE1E951D878EAA8FD6AAA8B; 
unable to open alert log at /u01/app/oracle/product/11.2.0/diag/rdbms/orcl/ORCL/trace/alert_orcl.log

- The Agent and the target DB have been installed by two different OS users and the Agent OS user.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.