EM 13c Corrective Action Stopped Working When the User Deleted or Credentials Not Set (Doc ID 2924353.1)

Last updated on MARCH 04, 2024

Applies to:

Symptoms

 The Corrective Actions job stopped working suddenly and 

 Enterprise -> Monitoring -> Corrective Actions -> click on Broken Corrective Actions count and it will navigate to the Broken Corrective Actions page

To verify the Corrective Action jobs details run the below SQLs.

select * from sysman.mgmt$ca_executions

where status_internal = 21 order by ca_id, execution_id;

List All Broken Corrective Action Job Details :

SELECT c.*,j.*
FROM mgmt_corrective_action c ,
mgmt_job j
WHERE j.job_id = c.job_id
AND j.broken=1
AND c.ca_scope =1
ORDER BY j.job_id;

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.