EM13c : oracle_security Metric Collection Fails With: Result has repeating key value
(Doc ID 2614930.1)
Last updated on NOVEMBER 26, 2019
Applies to:Enterprise Manager for Oracle Database - Version 184.108.40.206.0 to 220.127.116.11.0 [Release 13c]
Information in this document applies to any platform.
In Enterprise Manager (EM) Cloud Control, to capture the System Privileges of target databases through a query we can fetch them from MGMT$DB_ESM_ANYPRIVILEGES table.
This is a config table which gets populated with "Basic Security Configuration for Oracle database" default standard. It has to be enabled for all those target databases from which the system privileges needs to be captured.
Steps to enable are available in the following document:
<Note 2543556.1> - EM13c : Where to validate the SYSTEM Privileges of target databases?
MGMT$DB_ESM_ANYPRIVILEGES does not result data for some of the databases.
Verifying the "emctl control agent runCollection JVPUR20T:rac_database oracle_security" confirms the metric collection fail with: Result has repeating key value error.
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