My Oracle Support Banner

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

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.