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 220.127.116.11 and later
Information in this document applies to any platform.
Below error received while executing the preupgrade.jar(12.2) on Oracle database 18.104.22.168.
[oracle@xyz ~]$ /u01/app/oracle/product/11.2.0/dbhome_1/jdk/bin/java - jar /home/oracle/scripts/Upgrade/preupgrade.jar
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
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.
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