- ORA-29273: HTTP request failed ORA-06512: at "SYS.UTL_HTTP", line 1722 ORA-24247: network access denied by access control list (ACL)
We have our own system in our server room , that IP No is ex(192.167.3.65) and got Global IP for that ex(111.115.12.34). i have installed Apex in
192.167.3.65, but from ourstde access, we have refereed Global IP in our code. I tried all the way to create/assign ACL , enabled Both IPs and Port numbers
(8080/8090) , but still system throws error.
How to
i have executed below comments to have ACL
begin
dbms_network_acl_admin.create_acl (
acl => 'local-access-users.xmll',
description => 'HTTP Access',
principal => 'APEX_040200',
is_grant => TRUE,
privilege => 'connect',
start_date => null,
end_date => null
);
dbms_network_acl_admin.add_privilege (
acl => 'local-access-users.xml',
principal => 'APEX_040200',
is_grant => TRUE,
privilege => 'resolve',
start_date => null,
end_date => null
);
dbms_network_acl_admin.assign_acl (
acl => 'local-access-users.xml',
host => '111.115.12.34',
lower_port => 8090,
upper_port => NULL
);
commit;
end;
GRANT EXECUTE ON UTL_HTTP TO APEX_040200;
Could you please help me to resolve the issue