12cR1 Upgrade : Pre-Upgrade reports the message 'Inactive DBIDs found in AWR'

WHEN PRE-UPGRADE SCRIPT IS RUN,PRIOR TO UPGRADING TO 12C,THE FOLLOWING MESSAGE IS SHOWN IN THE PRE-UPGRADE LOG-

**********************************************************************

[Pre-Upgrade Checks]

**********************************************************************

WARNING: –> Inactive DBIDs found in AWR


AWR contains inactive DBIDs which may need additional updating after

upgrading.

The same message is shown even after running the postupgrade_fixups.sql,once the Upgrade is completed.


------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------


From the code in rdbms/admin/utluppkg.sql, FUNCTION AWR_DBIDS_PRESENT_check checks for DBID Values in the sys.wrm$_wr_control & compares it with the DBID value under v$database.


It probably means any export/import of awr from other database had been done before.


From postupgrade_fixups.sql, the correction script awrupd12.sql  will double check if the suspected DBID in AWR data needs to be updated for 12c.


SOLUTION


Basically,this is an ignorable Warning as per BUG 18614807 - POSTUPGRADE_FIXUPS.SQL SCRIPT ALWAYS WARNS AWR CONTAINS INACTIVE DBIDS


After the upgrade is successful,run the following SQL Queries -


SQL> select dbid from sys.wrm$_wr_control;

SQL> select dbid from v$database;

The table sys.wrm$_wr_control could have additional DBIDs compared to v$database


Removing the additional DBID from sys.wrm$_wr_control is explained in the below Note -


How To remove Workload Repository information related to an old DBID from workload repository (Doc ID 1251795.1)

 Note - This issue can also be caused when a DB is cloned from another Source DB.