My Oracle Support Banner

Getting Metric Error For Monitoring Oracle Database With OMC (Doc ID 2626263.1)

Last updated on MAY 24, 2023

Applies to:

Oracle Management Cloud - Version N/A to N/A [Release 1.0]
Information in this document applies to any platform.

Symptoms

The following OMC alert is generated monitoring an Oracle Database target:


1.Error evaluating Database Options:24HrCollectionRO - java.lang.Throwable: The user does not have privilege to SELECT from the tables/views needed to collect the metric. Grant the necessary privileges. See https://docs.oracle.com/javadb/10.8.3.0/ref/rrefsqljgrant.html for more information on GRANT.

2.Metric Evaluation Error for 15MinCollection:Job Status

3.Error evaluating Invalid Object Count by Schema:15MinCollection - java.lang.Throwable: The user does not have privilege to SELECT from the tables/views needed to collect the metric. Grant the necessary privileges. See https://docs.oracle.com/javadb/10.8.3.0/ref/rrefsqljgrant.html for more information on GRANT.

4.Metric Evaluation Error for 1MinCollection:Blocking Sessions

5.Metric Evaluation Error for 5MinSharedHERacCollection:OraDB_InstanceEfficiency

6.Metric Evaluation Error for TablespaceUsageCollection:Storage Usage By Tablespace Full

7.Metric Evaluation Error for 10MinITACollection:AWR SQL Reference Data


 

 



Changes

 

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
Changes
Cause
Solution


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