My Oracle Support Banner

Server Generated alerts missed from EM due to DBA_SUBSCR_REGISTRATIONS not having Cloud Control agent entries (Doc ID 1903631.1)

Last updated on DECEMBER 12, 2015

Applies to:

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


From 12c Cloud Control, Server Generated Alerts like Tablespace alerts are not generated. This is due to missing entry for Cloud Control agent in dba_subscr_registrations.
After restarting the Cloud Control agent the entries remains in dba_subscr_registrations, but disappears after sometime.

Following query can be executed in target database monitored by Cloud Control agent to verify whether there is an entry for agent:

select subscription_name from dba_subscr_registrations;

A sample output would be :


The format of entry would be :




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.