Tablespace Alert Will Not Clear
(Doc ID 1911148.1)
Last updated on MARCH 05, 2019
Applies to:
Enterprise Manager for Oracle Database - Version 12.1.0.3.0 and laterInformation 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
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
Symptoms |
Cause |
Solution |
References |