My Oracle Support Banner

EM13c : oracle_security_inst2 Collected Data Not Present In MGMT$DB_ESM_DBPARAMCOLLEC (Doc ID 2690858.1)

Last updated on JULY 14, 2020

Applies to:

Enterprise Manager Base Platform - Version and later
Information in this document applies to any platform.


In Enterprise Manager (EM) Cloud Control, On a 2 instance RAC, only 1 instance is returning a value when 2 are expected.

select t.target_name,t.target_type, e.cm_target_guid target_guid, e.value ,to_char(e.last_collection_timestamp,'dd-mm-yyyy hh24:mi:ss') collection_date
from MGMT$DB_ESM_DBPARAMCOLLEC e join mgmt_targets t on e.cm_target_guid = t.target_guid where = 'audit_trail' and t.target_name like '<Target_Name>%';


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

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