12.1:Preupgrade command Fails with:"ERROR -ORA-06512: at "SYS.DBMS_PREUP" "
Last updated on DECEMBER 13, 2017
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.2 and laterInformation in this document applies to any platform.
Symptoms
Below error received while executing the preupgrade.jar(12.2) on Oracle database 11.2.0.3.
[oracle@xyz ~]$ /u01/app/oracle/product/11.2.0/dbhome_1/jdk/bin/java - jar /home/oracle/scripts/Upgrade/preupgrade.jar
ERROR -
ERROR - Unable to run sqlplus due to:
ORA-06512: at "SYS.DBMS_PREUP", line 4391
ORA-06512: at "SYS.DBMS_PREUP", line 9635
ORA-06512: at line 8
declare
*
ERROR at line 1:
ORA-01426: numeric overflow
ORA-06512: at line 56
if you are executing the preupgrade tool from a standby database
make sure the preupgrade tool has been executed in the primary database
If you are executing the tool from Windows, please make sure you have
given the appropriate permissions to the Oracle binaries owner.
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