My Oracle Support Banner

EM 13c: Enterprise Manager 13c Cloud Control DB Alert Log Metric Fails to Report Logged ORA- Errors for 12.2 ,18c and higher database versions (Doc ID 2329471.1)

Last updated on MARCH 12, 2021

Applies to:

Enterprise Manager for Oracle Database - Version 12.1.0.8.0 to 13.2.2.0.0 [Release 12.1 to 13.2]
Information in this document applies to any platform.

Symptoms

Enterprise Manager (EM) 13.2 Cloud Control does not report logged ORA errors with the Alert Log Monitor metric.

ORA- errors are not detected with the 12.2.0.1 database target.
ORA- errors are detected with the 12.1.0.2 database target with same settings.

Generate ORA- errors to test the symptom, for example:

exec dbms_system.ksdwrt(2, 'ORA-00100');

The ORA-00100 error is logged, but is not found in the file monitoring metric.


Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


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