Monday, December 4, 2023

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

No comments:

Post a Comment

Enhancing Query Performance: Leveraging In-Memory Optimized Dates in Oracle 23ai

In-Memory Column Store Unlike traditional row-based storage, The  In-Memory Column Store  (IM column store) stores tables and partitions in ...