My Oracle Support Banner

datapatch fails with error:"PLS-00201: identifier 'DBMS_UTILITY' (Doc ID 2801046.1)

Last updated on AUGUST 20, 2021

Applies to:

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

Symptoms

datapatch fails with error:

Validating logfiles...done
Patch 32545013 apply : WITH ERRORS
logfile: $ORACLE_BASE/cfgtoollogs/sqlpatch/32545013/24175065/32545013_apply_dbname_<timestamp>.log (errors)
-> Error at line 241030: script rdbms/admin/execrsa.plb
- 2/19 PLS-00201: identifier 'DBMS_UTILITY' must be declared

 

32545013_apply_dbname_<timestamp>.log (errors) shows:

SQL> CREATE OR REPLACE PROCEDURE remote_scheduler_agent.submit_filewatch_results wrapped
2 a000000
3 1
4 abcd
5 abcd

::::::::::::::::::::::::::::::

26 jQac+8ZSBCyvRuu9fa3mqAYqVwikhChTPbS++OFUDNAx
27
28 /

Warning: Procedure created with compilation errors.

SQL> show errors;
Errors for PROCEDURE REMOTE_SCHEDULER_AGENT.SUBMIT_FILEWATCH_RESULTS:

LINE/COL ERROR
-------- -----------------------------------------------------------------
0/0 PL/SQL: Compilation unit analysis terminated
2/19 PLS-00201: identifier 'DBMS_UTILITY' must be declared

 

 

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
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.