Required Script to Complete AWR Warehouse Upgrade (Doc ID 2672081.1)

Last updated on JUNE 01, 2020

Applies to:

Enterprise Manager for Oracle Database - Version 13.2.2.0.0 and later
Information in this document applies to any platform.

Goal

In case the OMS Version is 13.2 or higher (Including 13.4 RU3), a script must run manually on The Enterprise Manager Repository to upgrade the packages on the AWR Warehouse database.

Bug 31340799 - AWR Warehouse packages not updated automatically

This script enables the enhanced diagnostics and error handling for the AWR Warehouse in EM 13.2 and EM 13.3..

This script should only be applied to upgraded AWR Warehouses for EM 13.2 through 13.4 RU2. This script is not for fresh installs of the AWR Warehouse in EM 13.4 RU3 and above.

How to check the script run successfully?

Once the script is triggered a series of EM Jobs will run:

1- CAW_UPRGRADE_*

2- CAW_LOAD_UPGRADE_*

3- CAW_EXTRACT_UPGRADE_*(if warehouse has one or more non-PDB sources)

4- CAW_EXTRACT_UPGRADE_PDP_*(if warehouse has one or more PDB Sources)

If all these jobs succeed, then the update is applied successfully.