12cR1 : Pre-Upgrade Fixup fails with errors ORA-06502 and ORA-06512

(Doc ID 1964729.1)

Last updated on FEBRUARY 23, 2016

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

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