Sunday, September 30, 2012

EM12c: How to fix 'Job Purge' repository scheduler job when it shows as down, though its up (EM12cR2 upgrade issue)

Issue: After upgrading EM from BP1 to EM12cR2, EM reports 'Job Purge' repository scheduler job as down though it's actually up.

One can see the status of this Job, on the Repository page (Setup -> Manage Cloud Control -> Repository), in the Repository Scheduler Jobs Status section, the "Job Purge" job is shown as down with a red arrow and blanks for both Next Scheduled Run and Last Scheduled Run. All the other jobs look good and are running successfully.



Action:
Please run the following SQL as SYSMAN to correct the problem.

UPDATE MGMT_PERFORMANCE_NAMES SET display_name = NULL,
   dbms_jobname = NULL, is_dbmsjob = 'N', is_deleted = 'Y'
  WHERE UPPER(DBMS_JOBNAME) LIKE 'MGMT_JOB_ENGINE.APPLY_PURGE_POLICIES%';
COMMIT;

Now it should look like as given below:

Note: One can also refer to discussion at this Oracle forum or this blog

3 comments:

pardydba said...

If you're going to quote me verbatim on the description of this problem you could at least link to the OTN Forum post if not my blog.

Neelima Bawa said...

Done

pardydba said...

Much appreciated -- be well!