DBMS STATS Package Fails with Error 'ORA-04063: package body "SYS.DBMS_REGISTRY_SYS" has errors' (Doc ID 2595466.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

• DBMS STATS package is failing with the errors below:
  
  LINE/COL ERROR
  -------- -----------------------------------------------------------------
  4285/5 PL/SQL: Statement ignored
  4285/27 PLS-00302: component 'IS_STATS_FROM_UPGRADE' must be declared

  SQL> @?/rdbms/admin/utlrp.sql
  SELECT dbms_registry_sys.time_stamp('utlrp_bgn') as timestamp from dual
  *
  ERROR at line 1:
  ORA-04063: package body "SYS.DBMS_REGISTRY_SYS" has errors

  *
  ERROR at line 1:
  ORA-04063: package body "SYS.DBMS_STATS" has errors
  ORA-06512: at "SYS.UTL_RECOMP", line 899
  ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_STATS"
  ORA-06512: at "SYS.UTL_RECOMP", line 260
  ORA-06512: at "SYS.UTL_RECOMP", line 803
  ORA-06512: at line 4

    
  
  

Cause

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