Dear fellow DBAs and experts,
I currently have a problem that is bugging me, as I wasn't able to find a solution yet.
I have a couple of open incidents in Cloud Control 12c (12.1.0.4), which cannot be cleared.
Cloud Control lists a couple of databases where jobs have failed.
I tracked these jobs down to belong to the Oracle Space Advisor (AT_SQ_SQL_SW%).
As a matter of fact, it is reported to be an Oracle bug.
For now, I would like to get rid of these annoying messages until I get a downtime to patch the respective systems.
Unfortunately, the messages cannot be deleted or surpressed since they will clear themselves once the underlying problem is fixed.
I tried to purge the job logs ussing the DBMS_SCHEDULER.PURGE_LOG procedure.
execute DBMS_SCHEDULER.PURGE_LOG(log_history => 0, which_log => 'JOB_LOG', job_name => 'ORA$AT_SA_SPC_SY_3085');
Afterwards I reevaluated the incident in Cloud, but the incident is not cleared.
I'd highly appreciate your feedback and thoughts on this issue.
Many thanks and regards in advance!
Sebastian