Datapatch Failed PLS-00201: identifier 'DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE' must be declared (Doc ID 2907784.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

Datapatch failed with errors:

-> Error at line 60063: script rdbms/admin/catgwmcat.sql
- ORA-04042: procedure, function, package, or package body does not exist
-> Error at line 62139: script rdbms/admin/catgwmcat.sql
- ORA-06550: line 2, column 3:
- PLS-00201: identifier 'DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE' must be declared
- ORA-06550: line 2, column 3:
- PL/SQL: Statement ignored

 ----------

No errors.
 dbms_network_acl_admin.append_host_ace(
 *
ERROR at line 2:
ORA-06550: line 2, column 3:
PLS-00201: identifier 'DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE' must be declared
ORA-06550: line 2, column 3:
PL/SQL: Statement ignored

Changes

Cause

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