My Oracle Support Banner

ORA-24247 After Using DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE (Doc ID 2656533.1)

Last updated on JULY 20, 2024

Applies to:

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

Symptoms

After granting all required network privileges to a user principal using DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE,
the following error is still received:

ORA-24247: network access denied by access control list (ACL)

Changes

Previously, DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE was being used to add CONNECT/RESOLVE privileges to a user.

As this is a deprecated approach, DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE is now being used instead.

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
References


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