Datapatch Error After Applying Patch 32545013 Along With A Number Of Invalid Objects. (Doc ID 2791580.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

• Datapatch error when apply 19.11 APR21 RU:
  
  Problem Description
  ---------------------------------------------------
  Patch 32545013 apply: WITH ERRORS
   
• Log shows the following errors: 
  

  SQL> show errors;
  Errors for PACKAGE BODY PRVTEMX_PERF:

  LINE/COL ERROR
  -------- -----------------------------------------------------------------
  0/0 PL/SQL: Compilation unit analysis terminated
  11/40 PLS-00302: component 'GET_CLOUD_SERVICE_TYPE' must be declared
  SQL> @?/rdbms/admin/sqlsessend.sql
  |
  |
  SQL> CREATE OR REPLACE PACKAGE BODY dbms_perf wrapped
  2 a000000
  3 1
  4 abcd
  5 abcd
  |
  |
  272
  273 /

  Warning: Package Body created with compilation errors.

  SQL> show errors;
  Errors for PACKAGE BODY DBMS_PERF:

  LINE/COL ERROR
  -------- -----------------------------------------------------------------
  1486/7 PL/SQL: Statement ignored
  1486/34 PLS-00302: component 'GET_TZ_OFFSET' must be declared
  1761/9 PL/SQL: Statement ignored
  1763/54 PLS-00302: component 'GET_CLOUD_SERVICE_TYPE' must be declared
  2592/7 PL/SQL: Statement ignored
  2592/34 PLS-00302: component 'GET_TZ_OFFSET' must be declared
  |
  |
  SQL> show errors;
  Errors for TYPE BODY WRI$_REPT_AWRV:

  LINE/COL ERROR
  -------- -----------------------------------------------------------------
  565/7 PL/SQL: Statement ignored
  565/44 PLS-00302: component 'GET_CLOUD_SERVICE_TYPE' must be declared
  569/7 PL/SQL: Statement ignored
  571/33 PLS-00302: component 'CLOUD_SERVICE_TYPE_ADW_S' must be declared
  SQL> CREATE OR REPLACE TYPE BODY prvt_awrv_metadata wrapped
  |
  |

  SQL> show errors;
  Errors for PACKAGE BODY DBMS_SWRF_REPORT_INTERNAL:

  LINE/COL ERROR
  -------- -----------------------------------------------------------------
  14612/7 PL/SQL: Statement ignored
  14614/33 PLS-00201: identifier 'STAT_CPU_COUNT_B' must be declared
  14616/7 PL/SQL: Statement ignored
  14618/33 PLS-00201: identifier 'STAT_SGA_TARGET_PARAM_B' must be declared
  14621/7 PL/SQL: Statement ignored
  14623/33 PLS-00201: identifier 'STAT_PGA_TARGET_PARAM_B' must be declared
  |
  |
  2273 /

  Warning: Package Body created with compilation errors.

  SQL> show errors;
  Errors for PACKAGE BODY DBMS_SQLTUNE:

  LINE/COL ERROR
  -------- -----------------------------------------------------------------
  26291/3 PL/SQL: Statement ignored
  26315/12 PLS-00375: illegal GOTO statement; this GOTO cannot branch to
  label 'DONE'

  26477/5 PL/SQL: Statement ignored
  26479/30 PLS-00302: component 'GET_CLOUD_SERVICE_TYPE' must be declared

   

Cause

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