INTRODUCTION
This blog is about, one of our non-prod OEM13C environment the Database target status was showing warning eventhough the target is actually up and running.
SOLUTION
Login into OEM using sysman, navigate too below,
SETUP->MANAGEMENT CLOUD CONTROL->REPOSITORY,
There should be a tab called ‘Repository scheduler job status with several options as below,
- Composite Target Availability was down in our environment, select the respective option and click Restart Job, once restart is complete refresh the page and check the status of the job should be up.
- Once done with above action plan, follow below steps as sysman user in repository database,
SQL>exec emd_maintenance.remove_em_dbms_jobs;
Reset the value of the following parameter to 100 as SYS user:
SQL>alter system set job_queue_processes=100 scope=BOTH;
Submit DBMS_SCHEDULER jobs. (Connect as SYSMAN user and execute the following:)
SQL>exec emd_maintenance.submit_em_dbms_jobs;
SQL>commit.
Once the above steps are done check the status of the Database target