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

Last updated on OCTOBER 28, 2013

Applies to:

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

Symptoms

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

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.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms