My Oracle Support Banner

EM 12C, Tablespace Full Alerts Does not reflect modified Warning/Critical Thresholds values (Doc ID 1460909.1)

Last updated on FEBRUARY 20, 2019

Applies to:

Enterprise Manager for Oracle Database - Version to [Release 12.1]
Information in this document applies to any platform.
Checked for relevance on 28-Oct-2013


DB version running on SLES-11 (x86_64).
Agent version
OMS version

Changing the warning and critical thresholds of tablespace using Grid Control does not update DBA_THRESHOLDS on the target for METRICS_NAME='Tablespace Space Usage'.

Queries on DBA_Thresholds is showing the old thresholds, while changes take effect on <AGENT_HOME>/sysman/emd/collection/oracle_database_<target_name>.xml file.

Trying to set the thresholds using following access path failed also:

DB HOME Page --> Administration ->>Storage --> Tablespaces ->> Edit --> Thresholds --> Specify (new values) --> Apply

Failed to commit: ORA-13914: Threshold notification failed.




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.