My Oracle Support Banner

datapatch fails with PL/SQL Errors : "Warning: Package Body created with compilation errors. " ,"PLS-00201: identifier ' ' must be declared" (Doc ID 2657716.1)

Last updated on AUGUST 25, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Information in this document applies to any platform.

Symptoms

Symptom 1)

datapatch fails with error:

Validating logfiles...
Patch patchnum rollback: WITH ERRORS
  logfile: $ORACLE_BASE/cfgtoollogs/sqlpatch/~/patch_rollback_SID_<timestamp>.log (errors)
  Error at line 4992: Warning: Package Body created with compilation errors.
  Error at line 4998: 18788/3 PL/SQL: Statement ignored
  Error at line 4999: 18788/6 PLS-00201: identifier
  Error at line 5002: 18792/3 PL/SQL: Statement ignored
  Error at line 5003: 18792/3 PLS-00201: identifier

 

<patchnum>_apply or rollback SID_<timestamp>.log shows:

?/rdbms/admin/prvtawrs.plb

Warning: Package Body created with compilation errors.

Errors for PACKAGE BODY DBMS_AWR_REPORT_LAYOUT:

LINE/COL ERROR
-------- -----------------------------------------------------------------
18788/3 PL/SQL: Statement ignored
18788/6 PLS-00201: identifier
'DBMS_AWR_PROTECTED.COMMON_SECTIONS_INITIALIZED' must be declared

18792/3 PL/SQL: Statement ignored
18792/3 PLS-00201: identifier
'DBMS_AWR_PROTECTED.COMMON_SECTIONS_INITIALIZED' must be declared

 

Symptom 2)

datapatch fails with error:

logfile: $ORACLE_BASE/cfgtoollogs/sqlpatch/30445968/23303757/30445968_rollback_SID_<timestamp>.log.log (errors)
Error at line 80679: Warning: Package Body created with compilation errors.
Error at line 80686: 18788/3 PL/SQL: Statement ignored
Error at line 80687: 18788/6 PLS-00201: identifier
Error at line 80690: 18792/3 PL/SQL: Statement ignored
Error at line 80691: 18792/3 PLS-00201: identifier
Error at line 94171: Warning: Package Body created with compilation errors.
Error at line 94178: 242/6 PL/SQL: Statement ignored
Error at line 94179: 242/6 PLS-00201: identifier 'DBMS_BDSQL.SEL_USERMAP' must be declared

 

<patchnum>_rollback_SID_<timestamp>.log.log shows:

SQL> @?/rdbms/admin/prvthadoop1.plb
Session altered.
..
..
Warning: Package Body created with compilation errors.

SQL> show errors
Errors for PACKAGE BODY DBMS_HADOOP:

LINE/COL ERROR
-------- -----------------------------------------------------------------
242/6 PL/SQL: Statement ignored
242/6 PLS-00201: identifier 'DBMS_BDSQL.SEL_USERMAP' must be declared

  

Symptom 3)

datapatch fails with error:

   Error at line 29457: Warning: Package Body created with compilation errors.
   Error at line 29464: 0/0      PL/SQL: Compilation unit analysis terminated
   Error at line 29465: 1/14     PLS-00201: identifier 'DBMS_ASH' must be declared
   Error at line 29466: 1/14     PLS-00304: cannot compile body of 'DBMS_ASH'

 

<patchnum>_apply _SID_<timestamp>.log shows:

?/rdbms/admin/prvtash.plb

Warning: Package Body created with compilation errors.

Errors for PACKAGE BODY DBMS_ASH:

 PL/SQL: Compilation unit analysis terminated
 PLS-00201: identifier 'DBMS_ASH' must be declared
 PLS-00304: cannot compile body of 'DBMS_ASH' without its   specification

 

Changes

 

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
Symptoms
 Symptom 1)
 Symptom 2)
 Symptom 3)
Changes
Cause
 Cause 1)
 
Cause 2)
 Cause 3)
Solution
 Solution 1)
 Solution 2)
 Solution 3)
References


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