My Oracle Support Banner

Invalid XDB-related Objects After Downgrading To 11.2.0.4 (Doc ID 2163596.1)

Last updated on FEBRUARY 03, 2022

Applies to:

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

Symptoms

A database that DOES NOT have XDB installed is upgraded from 11.2.0.4 to 12.1.0.2, and subsequently downgraded back to 11.2.0.4. The upgrade and downgrade completed without any issues. However, after the downgrading the database, 147 XDB-related objects are INVALID:

Changes

Database was upgraded to 12.1 and subsequently downgraded back to 11.2.0.4.

Cause

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
Symptoms
Changes
Cause
Solution
References


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