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

Last updated on AUGUST 06, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 to 12.1.0.2 [Release 12.1]
Generic UNIX

Symptoms

 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
..

Changes

 

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