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


When upgrading RDBMS from to, 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.
exec dbms_preup.run_fixup_and_report(‘INVALID_USR_TABLEDATA’);


So,The following steps were run.


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