12.1:Preupgrade command Fails with:"ERROR -ORA-06512: at "SYS.DBMS_PREUP" "

(Doc ID 2337266.1)

Last updated on DECEMBER 13, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information 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