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 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms

An upgrade from 11.2.0.2 to 11.2.0.3 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.

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

 

Changes

An attempt is made to upgrade the database environment to 11.2.0.3.

 

Cause

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