12c datapatch Fails with Error:'p_description=>DBMS_STATS ORA-06502: PL/SQL: NUMERIC OR VALUE ERROR' (Doc ID 2292845.1)

Last updated on JUNE 15, 2020

Applies to:

Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database - Enterprise Edition - Version 12.1.0.2 to 12.2.0.1 [Release 12.1 to 12.2]
Generic UNIX

Symptoms

12c datapatch fails with errors:'p_description=>DBMS_STATS ORA-06502: PL/SQL: NUMERIC OR VALUE ERROR'

Installing patches...
Patch installation complete. Total patches installed: 6

Validating logfiles...
Patch 21930149 apply (pdb CDB$ROOT): WITH ERRORS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/21930149/19649695/21930149_apply_ORCL_CDBROOT_2017Jul20_19_02_42.log (errors)
   Error at line 8: new   5:                                    p_description   => 'DBMS_STATS ORA-06502: PL/SQL: NUMERIC OR VALUE ERROR',
Patch 21930149 apply (pdb PDB$SEED): WITH ERRORS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/21930149/19649695/21930149_apply_ORCL_PDBSEED_2017Jul20_19_05_14log (errors)
   Error at line 8: new   5:                                    p_description   => 'DBMS_STATS ORA-06502: PL/SQL: NUMERIC OR VALUE ERROR',
Patch 21930149 apply (pdb ORCLDB): WITH ERRORS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/21930149/19649695/21930149_apply_ORCL_ORCLDB_2017Jul20_19_08_09.log (errors)
   Error at line 8: new   5:                                    p_description   => 'DBMS_STATS ORA-06502: PL/SQL: NUMERIC OR VALUE ERROR',

SQL> select BUNDLE_SERIES B_SER,BUNDLE_ID B_ID,PATCH_ID,FLAGS,ACTION,STATUS,ACTION_TIME,DESCRIPTION from dba_registry_sqlpatch ;
..
21930149 N APPLY WITH ERRORS
25-JUL-17 07.12.31.652943 PM DBMS_STATS ORA-06502: PL/SQL: NUMERIC OR VALUE ERROR
..

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

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

12c datapatch Fails with Error:'p_description=>DBMS_STATS ORA-06502: PL/SQL: NUMERIC OR VALUE ERROR' (Doc ID 2292845.1)

Applies to:

Symptoms

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!