If EMD_MAINTENANCE.DISABLE_EM_DBMS_JOBS Hangs When Deconfiguring Plug-In from Management Repository

Today, I tried to remove a plugin from Management Server but I see that undeployment process was hung at step 5:

I connected to Management Repository and see if there’s any waiting process. Unfortunately there was nothing. So I started to examine “active” processes of SYS user. You may know that EM12c uses SYS user when deploying or undeploying agent software. I found a process working for minutes, trying to complete the following commmand:

It’s easy to guess that it’s related with disabling the scheduler jobs belong to Enterprise Manager but I wanted to be sure and check the package code. As expected, the procedure queries the scheduler jobs of the repository owner (SYSMAN) and then disable all its jobs but it hung. After a quick check on My Oracle Support, I couldn’t find any solution for emd_maintenance.disable_em_dbms_jobs so I decided to let him help by restarting the cjq0 process. I queried the job_queue_processes, set it to zero, and then reset it to its previous value.

And then I see that undeployment process continued without any problem.

Please share

AWS Big Data Specialist. Oracle Certified Professional (OCP) for EBS R12, Oracle 10g and 11g. Co-author of "Expert Oracle Enterprise Manager 12c" book published by Apress. Awarded as Oracle ACE (in 2011) and Oracle ACE Director (in 2016) for the continuous contributions to the Oracle users community. Founding member, and vice president of Turkish Oracle User Group (TROUG). Presented at various international conferences including Oracle Open World.

Leave Comment

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.