My Oracle Support Banner

Preupgrade_fixups.sql fails with errors ORA-06502 and ORA-06512 (Doc ID 3059121.1)

Last updated on JANUARY 24, 2025

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Oracle Cloud Infrastructure - Exadata Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Gen 2 Exadata Cloud at Customer - Version N/A and later
Information in this document applies to any platform.

Symptoms

 


DBUA is officially desupported in Oracle 23ai release.
AutoUpgrade is the official and supported method for upgrading Oracle databases in the 19c and 23c releases.
AutoUpgrade is the recommended tool for database upgrades starting from Oracle 19c.
AutoUpgrade is the ONLY supported tool for database upgrades in Oracle 23ai.
Note: DBUA for "RAC on Windows" is supported only for the short term until this functionality is available in AutoUpgrade.

Further information on how to use this Tool is documented in Note 2485457.1 and Oracle documentation.

To get latest version of AutoUpgrade Tool refer Note 2485457.1

Reference : AutoUprade Blog.

 

 

 

1．Trying to upgrade database from 12c to 19c.

2．Running preupgrade.jar.

 

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
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.