When I opened the target host to view the related report, I got this page.
Here is the details of the error in the above image:
property:cpuUtilization on bean:oracle.sysman.si.extension.model.host.XHost@f365a80 of type:oracle.sysman.si.extension.model.host.XHost
JBO-25077: Name cpuUtilization not found in the given object: oracle.sysman.si.extension.model.host.XHost@f365a80.
JBO-25077: Name cpuUtilization not found in the given object: oracle.sysman.si.extension.model.host.XHost@f365a80.
JBO-25077: Name cpuUtilization not found in the given object: oracle.sysman.si.extension.model.host.XHost@f365a80.
JBO-25077: Name cpuUtilization not found in the given object: oracle.sysman.si.extension.model.host.XHost@f365a80.
This happens because none of the DBMS_scheduler jobs are running in the EM repository.
I did the following steps to perform the partition maintenance and re-submit all mandatory DBMS scheduler jobs related to the EM repository:
1. Log in as sys user on the EM repository database and check the value of the job_queue_processes parameter in the database:
[oracle@cloudcontrol7 ~]$ sqlplus / as sysdba
SQL> show parameter job_queue_process
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
job_queue_processes integer 50
2. Set the job_queue_processes to 0
SQL> alter system set job_queue_processes = 0;
3. Connect as SysMan, and remove em_dbms_jobs (EMD_MAINTENANCE controls maintenance jobs for Enterprise Manager.)
SQL> connect sysman
Enter password:
Connected.
SQL> exec emd_maintenance.remove_em_dbms_jobs;
PL/SQL procedure successfully completed.
SQL> exec gc_interval_partition_mgr.partition_maintenance;
PL/SQL procedure successfully completed.
4. Execute <OMS_HOME>/sysman/admin/emdrep/sql/core/latest/admin/admin_recompile_invalid.sql script to recompile the invalid objects:
5. Re-submit all mandatory DBMS scheduler jobs related to the EM repository:
SQL> connect / as sysdba
Connected.
SQL> alter system set job_queue_processes = 1000;
System altered.
SQL> connect sysman
Enter password:
Connected.
SQL> exec emd_maintenance.submit_em_dbms_jobs;
PL/SQL procedure successfully completed.
SQL> commit;
Commit complete.
6. Now, we just need to resync the OEM to collect and update reports
[oracle@cloudcontrol7 ~]$ /home/oracle/app/oracle/middleware/bin/emcli login -username=SYSMAN
Enter password :
Login successful
[oracle@cloudcontrol7 ~]$ /home/oracle/app/oracle/middleware/bin/emcli sync
Synchronized successfully