My Oracle Support Banner

[OCI] Datapatch Fails For DVSYS.DBMS_MACUTL In PDB. (Doc ID 2768332.1)

Last updated on MAY 14, 2021

Applies to:

Oracle Database Cloud Service - Version N/A to N/A [Release 1.0]
Information in this document applies to any platform.

Symptoms

Datapatch was failing and the invocation log shows the following:

...
Installing patches...
Patch installation complete.  Total patches installed: 4

Validating logfiles...
Patch 29665074 rollback (pdb <pdb>): WITH ERRORS
 logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/29665074/22882839/29665074_rollback_<DB name>_<pdb>_2021Mar18_10_35_33.log (errors)
   Error at line 2205: Warning: Package Body created with compilation errors.
   Error at line 2245: Warning: Package Body created with compilation errors.
   Error at line 2285: Warning: Package Body created with compilation errors.
   Error at line 2329: Warning: Package Body created with compilation errors.
   Error at line 2370: Warning: Package Body created with compilation errors.
   Error at line 2410: Warning: Package Body created with compilation errors.
   Error at line 2450: Warning: Package Body created with compilation errors.
   Error at line 2490: Warning: Package Body created with compilation errors.
   Error at line 2530: Warning: Package Body created with compilation errors.
   Error at line 2537: 0/0      PL/SQL: Compilation unit analysis terminated
   Error at line 2538: 1/14     PLS-00201: identifier 'DBMS_MACOUT' must be declared
   Error at line 2539: 1/14     PLS-00304: cannot compile body of 'DBMS_MACOUT' without its
   Error at line 2652: Warning: Package Body created with compilation errors.
   Error at line 2911: Warning: Package Body created with compilation errors.
   Error at line 2979: Warning: Procedure created with compilation errors.
   Error at line 2986: 16/5     PL/SQL: Item ignored
   Error at line 2987: 20/15    PLS-00201: identifier 'KZV$ADM_LIBT' must be declared
   Error at line 2988: 23/5     PL/SQL: Item ignored
   Error at line 2989: 27/15    PLS-00201: identifier 'KZV$ADM_LIBT' must be declared
   Error at line 2990: 30/5     PL/SQL: Item ignored
   Error at line 2991: 34/15    PLS-00201: identifier 'KZV$ADM_LIBT' must be declared
   Error at line 2992: 61/7     PL/SQL: Statement ignored
   Error at line 2996: 61/7     PLS-00201: identifier 'DVSYS.DBMS_MACUTL' must be declared
   Error at line 2997: 66/5     PL/SQL: SQL Statement ignored
   Error at line 2999: 69/7     PL/SQL: Statement ignored
   Error at line 3000: 69/7     PLS-00201: identifier 'DVSYS.DBMS_MACUTL' must be declared
   Error at line 3001: 80/7     PL/SQL: Statement ignored
   Error at line 3002: 80/7     PLS-00201: identifier 'DVSYS.DBMS_MACUTL' must be declared
   Error at line 3006: 87/11    PL/SQL: Statement ignored
   Error at line 3007: 87/11    PLS-00201: identifier 'DVSYS.DBMS_MACUTL' must be declared
   Error at line 3008: 102/11   PL/SQL: Statement ignored
   Error at line 3009: 102/11   PLS-00201: identifier 'DVSYS.DBMS_MACUTL' must be declared
   Error at line 3010: 109/7    PL/SQL: Statement ignored
   Error at line 3011: 109/7    PLS-00201: identifier 'DVSYS.DBMS_MACUTL' must be declared
   Error at line 3041: Warning: Package Body created with compilation errors.
   Error at line 3048: 0/0      PL/SQL: Compilation unit analysis terminated
   Error at line 3049: 1/14     PLS-00201: identifier 'DBMS_MACAUD' must be declared
   Error at line 3050: 1/14     PLS-00304: cannot compile body of 'DBMS_MACAUD' without its
   Error at line 3099: Warning: Package Body created with compilation errors.
   Error at line 3106: 0/0      PL/SQL: Compilation unit analysis terminated
   Error at line 3107: 1/14     PLS-00201: identifier 'DBMS_MACSEC_RULES' must be declared
   Error at line 3108: 1/14     PLS-00304: cannot compile body of 'DBMS_MACSEC_RULES' without its
   Error at line 3176: Warning: Package Body created with compilation errors.
   Error at line 3183: 0/0      PL/SQL: Compilation unit analysis terminated
   Error at line 3184: 1/14     PLS-00201: identifier 'DBMS_MACSEC' must be declared
   Error at line 3185: 1/14     PLS-00304: cannot compile body of 'DBMS_MACSEC' without its
   Error at line 3253: Warning: Package Body created with compilation errors.
   Error at line 3260: 0/0      PL/SQL: Compilation unit analysis terminated
   Error at line 3261: 1/14     PLS-00201: identifier 'DBMS_MACOLS' must be declared
   Error at line 3262: 1/14     PLS-00304: cannot compile body of 'DBMS_MACOLS' without its

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
Changes
Cause
Solution


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