Resync Catalog failing with ORA-06502: PL/SQL: numeric or value error (Doc ID 2811069.1)

Last updated on SEPTEMBER 30, 2021

Applies to:

Symptoms

• The resync catalog is failing with the following error :
  
  
  DBGMISC: Finished cleanup at 10-SEP-21 [12:16:39.234]
  DBGMISC: ENTERED krmkjcl [12:16:39.234]
  DBGMISC: EXITED krmkjcl [12:16:39.234] elapsed time [00:00:00:00.000]
  DBGMISC: EXITED krmice [12:16:39.234] elapsed time [00:00:00:00.036]
  RMAN-00571: ===========================================================
  RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  RMAN-00571: ===========================================================
  RMAN-03009: failure of resync command on default channel at 09/10/2021 12:16:39
  ORA-06502: PL/SQL: numeric or value error
  DBGMISC: ENTERED krmkursr
    
  
  
• The RMAN Trace file is showing the following information when the PL/SQL error is reported :
  
  
  DBGPLSQL: ENTERED resync [12:16:39.180]
  DBGRESYNC: channel default: resyncing to AM is =1 [12:16:39.180] (resync)
  DBGRPC: krmxrpc - channel default kpurpc2 err=0 db=rcvcat proc=RASYS.DBMS_RCVCAT.LOCKFORCKPT excl: 0
  # DBGRCVMAN: getConfig: configurations exists for this site
  # DBGRCVCAT: lockForCkpt - took 0 seconds
  # DBGRCVCAT: lockForCkpt - Obtained all locks for db 100369104
  DBGRESYNC: channel default: automatic memory management [12:16:39.195] (resync)
  DBGRESYNC: channel default: Instance using automatic memory management, PGA Target size 1073741824 [12:16:39.196] (resync)
  DBGRESYNC: channel default: Starting resync [12:16:39.196] (resync)
  DBGRESYNC: channel default: cfname is [12:16:39.196] (resync)
  DBGRPC: krmxr - channel default returned from peicnt
  DBGMISC: ENTERED krmstrim [12:16:39.197]
  DBGMISC: Trimming message: ORA-06502: PL/SQL: numeric or value error [12:16:39.197] (krmstrim)
  DBGMISC: ORA-06512: at line 1966 (krmstrim)
   

Cause

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