'ORA-24244' error while granting 'resolve' privilege on ACE (Doc ID 2706038.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

select distinct HOST||' ['||LOWER_PORT||'-'||UPPER_PORT||'] ' hst , PRINCIPAL ,substr(PRIVILEGE,1,10) priv from DBA_HOST_ACES;

HST                                    PRINCIPAL    PRIV
------------------------------------------------------------ 
h1.oracle.com [8080-8080]   APPS            CONNECT

BEGIN
DBMS_NETWORK_ACL_ADMIN.append_host_ace (
host => 'h1.oracle.com',
lower_port => 8080,
upper_port => 8080,
ace => xs$ace_type(privilege_list => xs$name_list('RESOLVE'),
principal_name => 'APPS' ,
principal_type => xs_acl.ptype_db));
end;
/
BEGIN
*
ERROR at line 1:
ORA-24244: invalid host or port for access control list (ACL) assignment
ORA-06512: at "SYS.DBMS_NETWORK_ACL_ADMIN", line 1132
ORA-06512: at line 2

Cause

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