My Oracle Support Banner

Fixing Datapatch Error: PLS-00201 - 'DBMS_UTILITY.LNAME_ARRAY' Not Declared (Doc ID 3047618.1)

Last updated on SEPTEMBER 17, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 19.22.0.0.0 and later
Oracle Cloud Infrastructure - Database Service - Version N/A to N/A [Release 1.0]
Oracle Database Cloud Exadata Service - Version N/A to N/A [Release 1.0]
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A to N/A
Information in this document applies to any platform.

Symptoms

 

Datapatch Encountered the Following Error:

-> Error at line 738797: script md/admin/sdosempatch.sql

- 529/19 PLS-00201: identifier 'DBMS_UTILITY.FORMAT_ERROR_BACKTRACE' must

-> Error at line 738800: script md/admin/sdosempatch.sql

- 532/9 PL/SQL: Statement ignored

Patch: 35943157 apply (pdb CDB$ROOT): WITH ERRORS

logfile: /u100/app/abcd/cfgtoollogs/sqlpatch/35943157/25527362/35943157_apply_XYZ_CDBROOT_2024aug01_10_22_02.log (errors)

-> Error at line 363910: script rdbms/admin/execrsa.plb

- Warning: Procedure created with compilation errors.

- 2/19 PLS-00201: identifier 'DBMS_UTILITY.LNAME_ARRAY' must be declared

-> Error at line 417833: script ctx/admin/drvparx.plb

- Warning: Package Body created with compilation errors.

- 19354/36 PLS-00201: identifier 'DBMS_UTILITY.FORMAT_ERROR_STACK' must be

-> Error at line 433704: script rdbms/admin/prvtgwm.sql

- 19451/15 PL/SQL: Statement ignored

 

 Upon reviewing the log file located at /u100/app/abcd/cfgtoollogs/sqlpatch/35943157/25527362/35943157_apply_XYZ_CDBROOT_2024aug01_10_22_02.log

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.LNAME_ARRAY' must be declared

 

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.