Issues: One of the following problems may be noted:

• The Targets > Exadata page is slow to load

• The Targets > Exadata page shows a message indicating that Oracle Text needs to be installed on the Enterprise Manager repository database.
• Exadata Dashboards show no data or are slow to load.

Resolution:

1. The Exadata and Recovery Appliance fleet pages and the features of the Exadata and Zero Data Loss Recovery Appliance Management Packs require Oracle Text to be installed on the Enterprise Manager repository database. To install Oracle Text, follow the steps in Doc ID 2591868.1 from My Oracle Support.

2. Verify that Oracle Text is installed by running the following query and ensure that a row similar to the following is returned:

   select comp_name, version, status from dba_registry where comp_name='Oracle Text';
   COMP_NAME ------ VERSION ---------- STATUS --------
   Oracle Text      19.0.0.0.0         VALID

3. Ensure that the following jobs are not running in the repository database while implementing the action plan outlined below:

   • Run the following SQL query on the repository database as SYSMAN:

     SELECT *
     FROM mgmt$job_execution_history h
     WHERE job_type IN ( 'ExaFleetSysRefresh', 'ExaFleetMembersRefresh', 'ExaFleetPropsRefresh' )
     AND status = 'Running';

   • If the query in Step 2 does not return results, proceed with the next step.

4. Run the following SQL statements on the repository database as SYSMAN:

   DROP INDEX FLT_TGT_PROP_JSON_INDX;
   DROP INDEX XA_FLT_MEM_JSON_INDX;
   CREATE SEARCH INDEX FLT_TGT_PROP_JSON_INDX ON XA_FLT_TGT_PROPS_E(properties) FOR JSON;
   CREATE SEARCH INDEX XA_FLT_MEM_JSON_INDX ON XA_FLT_MEMS_E(members) FOR JSON;

5. Refresh data in the relevant tables by executing the following commands on the repository database as SYSMAN:

   EXEC em_xafleet.refresh_members;
   EXEC em_xafleet.refresh_props;
   COMMIT;

6. Validate that the tables/views are populated with data using the following commands on the repository database as SYSMAN. Each of the following queries should return at least one row:

   SELECT * FROM xa_flt_mems_e;
   SELECT * FROM xa_flt_members;
   SELECT * FROM xa_flt_tgt_props_e;
   SELECT * FROM xa_flt_tgt_props;

7. Access Oracle Enterprise Manager and verify the following:

   • The response time of the Exadata page has improved.

   • There is no warning message related to missing Oracle Text on the Exadata page.

   • The Exadata Dashboards show data (assuming that the Exadata Management Pack is enabled for at least one Exadata system).