My Oracle Support Banner

ASH Analytics Not Visible In EM 13.3 Console (Doc ID 2661936.1)

Last updated on APRIL 21, 2020

Applies to:

Enterprise Manager for Oracle Database - Version 13.3.0.0.0 and later
Information in this document applies to any platform.
Customer has followed below document and implemented all the steps. Not helped much
1. Usage Of ASH Analytics In EM 13.3 PG Release (Doc ID 2580773.1)
2. OEM 13c - ASH Analytics Page Is Blank (Doc ID 2572207.1)
Not helped.

Below SQL's was failing

SELECT omc_ash_viewer.getDataRealTime('','300','n','n','N').getClobVal(2,2) AS output FROM dual;

ERROR:
ORA-06598: insufficient INHERIT PRIVILEGES privilege
ORA-06512: at "DBSNMP.OMC_ASH_VIEWER", line 1
ORA-06512: at line 1
SELECT omc_ash_viewer.getDataRealTime('','300','n','n','N').getClobVal(2,2) AS output FROM dual;

Goal

 ASH analytics not visible in EM 13.3 console. Make it working

Solution

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
Goal
Solution


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