My Oracle Support Banner

Preupgrade error: ORA-06502: PL/SQL: Numeric Or Value Error: Character String Buffer Too Small (Doc ID 2915675.1)

Last updated on JULY 20, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Information in this document applies to any platform.

Symptoms

Upgrade from 12.2.0.1 to 19c, during execution of preupgrade.jar script, following error appeared:

===========================

20221213-02:26:28 <source_oracle_home>/jdk/bin/java -jar <target_oracle_home>/rdbms/admin/preupgrade.jar FILE -DIR /tmp/Oracle19.3.0.0.Upgrade
ERROR - Unable to run the preupgrade due to:ERROR - Unable to run preupgrade due to:
ORA-06512: at "SYS.DBMS_PREUP", line 1127
ORA-06512: at "SYS.DBMS_PREUP", line 1243
ORA-06512: at "SYS.DBMS_PREUP", line 5333
ORA-06512: at "SYS.DBMS_PREUP", line 5241

INTERNAL ERROR: An internal preupgrade error occurred that prevents further execution. This is unexpected and usually caused by some sort of internal inconsistency. You may want to contact Oracle Support. The internal error message is:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_PREUP", line 295
ORA-06512: at "SYS.DBMS_PREUP", line 5298
ORA-06512: at "SYS.DBMS_PREUP", line 1127
ORA-06512: at "SYS.DBMS_PREUP", line 1243
ORA-06512: at "SYS.DBMS_PREUP", line 5333
ORA-06512: at "SYS.DBMS_PREUP", line 5241
ORA-06512: at line 39

declare
*
ERROR at line 1:
ORA-20000: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at line 56
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_PREUP", line 295
ORA-06512: at "SYS.DBMS_PREUP", line 5298
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "SYS.DBMS_PREUP", line 1127
ORA-06512: at "SYS.DBMS_PREUP", line 1243
ORA-06512: at "SYS.DBMS_PREUP", line 5333
ORA-06512: at "SYS.DBMS_PREUP", line 5241
ORA-06512: at line 39

ERROR
-----------------------
ORA-06502: PL/SQL: numeric or value error: character string buffer too small

 

Changes

 undo_management parameter value has changed to manual

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
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.