12cR1 : Pre-Upgrade Fixup fails with errors ORA-06502 and ORA-06512
(Doc ID 1964729.1)
Last updated on MARCH 02, 2019
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.2 and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A 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;
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 |