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

Problem:

ORA-24247: network access denied by access control list (ACL)
ORA-06512: at "SYS.UTL_TCP", line 17
ORA-06512: at "SYS.UTL_TCP", line 246
ORA-06512: at "SYS.UTL_SMTP", line 127
ORA-06512: at "SYS.UTL_SMTP", line 150
ORA-06512: at "GEOPP.SEND_MAIL", line 240
ORA-06512: at "GEOPP.SEND_MAIL", line 118
ORA-06512: at "GEOPP.GEOPP_ALARM_MAIL", line 115
ORA-06512: at line 1

Cause:

Solution:

http://www.oracle-base.com/articles/11g/FineGrainedAccessToNetworkServices_11gR1.php

begin

dbms_network_acl_admin.create_acl ( acl => 'utlpkg.xml', description => 'Normal Access', principal => 'GEOPP', is_grant => TRUE, privilege => 'connect', start_date => null, end_date => null );

dbms_network_acl_admin.assign_acl ( acl => 'utlpkg.xml', host => '10.200.123.135', lower_port => 1, upper_port => 1000);

commit;

end;
/