The following error:

java.sql.SQLException: ORA-24247: network access denied by access control list (ACL)
ORA-06512: at “SYS.UTL_INADDR”, line 4
ORA-06512: at “SYS.UTL_INADDR”, line 35
ORA-06512: at line 1


A new security measure is introduced in Oracle 11g Release 1 (11.1) for the following network-related PL/SQL packages: UTL_TCP, UTL_HTTP, UTL_SMTP, UTL_MAIL, UTL_INADDR, DBMS_LDAP and the HttpUriType type.
The invoker of those packages needs additional privileges to connect to an external host or to resolve the name or the IP address of a host.
The packages check the invoker for the necessary privileges only when the calls are made at runtime and raises an exception if the invoker lacks the privileges. T
his new security measure is implemented by the XML DB access control list (ACL) mechanism and, therefore, requires XML DB to be installed and Configure network Access Control Lists (ACLs) in the database before these packages can work as they were working in prior releases.

Set the ACL for your 11g schema :

1. Connect to the database with SYS user as SYSDBA
2. Execute the following script after updating the email server name and port number :

SQL> exec dbms_network_acl_admin.create_acl(acl => ‘resolve.xml’,description => ‘resolve acl’, principal =>’ZABBIX’, is_grant => true, privilege => ‘resolve’);
SQL> exec dbms_network_acl_admin.assign_acl(acl => ‘resolve.xml’, host =>’*’);

You can verify the above is correct by running:

select utl_inaddr.get_host_name(‘’) from dual;

and everything should working fine;

Tags: , , , ,

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this. To know all the policy detais click here.