Patch Recommendations functionality in 13.2 Cloud Control is showing old and incorrect recommendation

ERROR: 

Patch Recommendations" functionality in 13.2 Cloud Control is showing old and incorrect recommendation about database targets. The issue may not be isolated just to database targets.

The issue was reported on both 12.2.0.1 and 12.1.0.2 Repository databases.

FIX: 

1. Set the following parameter on the repository database:

SQL> alter system set "_fix_control" = '13836796:0' scope=both;

2. Restart the OMS (emctl stop oms -all; emctl start oms)

3. Login as SYSMAN user in the repository database and run:

SQL>  DELETE FROM mgmt_aru_patch_recom_md;

2431 rows deleted.

SQL> begin

mos_pa_patch_recom.delete_checksums;

end;

/  

PL/SQL procedure successfully completed.

SQL>


4. Rerun the "Refresh from My Oracle Support" job.

No comments:

Post a Comment