Tablespace Alert Will Not Clear

(Doc ID 1911148.1)

Last updated on MARCH 08, 2017

Applies to:

Enterprise Manager for Oracle Database - Version 12.1.0.3.0 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.0.3.0 version, Target Database, Listener, ASM

ACTUAL BEHAVIOR
---------------
Currently for one of the database targets, SYSAUX tablespace has become full and the customer received a critical alert.
Though they have added space and is currently using only 60%, they did not get the clear alert for this table space.

Thresholds for the metric in the target DB show as 86/90.
no outstanding alerts in the DBA_OUTSTANDING_ALERST table.
agent is registered with AQ table.
alerts are occurring and clearing, but this one will not clear.

EXPECTED BEHAVIOR
-----------------------
When the underlying condition is fixed (in this case added space to the tablespace) the alerts should clear and
a notification email should be received.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot monitor their DB tablespaces correctly.

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