DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Monday, January 16, 2017

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

Error:
ERROR at line 1:
ORA-29273: HTTP request failed
ORA-24247: network access denied by access control list (ACL)
ORA-06512: at "SYS.UTL_HTTP", line 1491
ORA-06512: at line 1

Workaround:
No access control list (ACL) has been assigned to the target host or the privilege necessary to access the target host has not been granted to the user in the access control list.

Solution:
1)give the privileges to the corresponding schema.

grant execute on utl_http to HR

2)assign the acl for corresponding  hostname (or) IP

exec dbms_network_acl_admin.assign_acl ( acl => 'utl_http.xml', host => '(hostname)',lower_port => null, upper_port => null);

No comments: