My Oracle Support Banner

12.1:Preupgrade command Fails with:"ERROR -ORA-06512: at "SYS.DBMS_PREUP" " (Doc ID 2337266.1)

Last updated on AUGUST 04, 2018

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

To view full details, 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 a vibrant support community of peers and Oracle experts.