Blogs

JBO-25077 OEM has a problem with collecting the information of a host

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.

 

Solution:

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

More from this Author