Upgrade From 11.2.0.x To 11.2.0.y Leaves V$_DIAG View And Other ADR Views Invalid

(Doc ID 1516661.1)

Last updated on AUGUST 18, 2015

Applies to:

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


An upgrade from to leaves the V$_DIAG view and other related ADR views (such as V_$DIAG_HM_RUN, V_$DIAG_VSHOWINCB, etc.) invalid.

This prevents the upgrade from finishing successfully.

The issue may not be limited to above example versions as ig has been reported once also for upgrading 32-bit to 64-bit on Windows.



An attempt is made to upgrade the database environment to



Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms