My Oracle Support Banner

12cR1 Upgrade : Pre-Upgrade reports the message “Inactive DBIDs found in AWR” (Doc ID 1964451.1)

Last updated on FEBRUARY 14, 2019

Applies to:

Oracle Database - Enterprise Edition - Version and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.


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

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


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.