My Oracle Support Banner

12cR1 : Pre-Upgrade Fixup fails with errors ORA-06502 and ORA-06512 (Doc ID 1964729.1)

Last updated on AUGUST 04, 2018

Applies to:

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

Symptoms

When upgrading RDBMS from 11.2.0.2 to 12.1.0.2.1, Pre-Upgrade Script was run.

The log file preupgrd.log reports:

ERROR: –> Invalid user table data found in your database.
Invalid data can be seen prior to the database upgrade or during PDB plug in. This table data must be made valid BEFORE upgrade or plug in.
- To fix the data, load the Preupgrade package and execute the fixup routine. For plug in, execute the fix up routine in the PDB.
@?/rdbms/admin/utluppkg.sql
SET SERVEROUTPUT ON;
exec dbms_preup.run_fixup_and_report(‘INVALID_USR_TABLEDATA’);
SET SERVEROUTPUT OFF;

 

So,The following steps were run.

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.