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!
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.
