ORA-24247: network access denied by access control list (ACL)
Kiểm tra bằng cách chạy câu lệnh
select * from dba_network_acls;
Nếu có data dạng:
HOST LOWER_PORT UPPER_PORT ACL ACLID mail.vstv.vn 1 1024 /sys/acls/send_mail.xml D285E04B69B942688587AB8FE5B41C69
Chạy câu lệnh này:
BEGIN DBMS_NETWORK_ACL_ADMIN.create_acl ( acl => 'send_mail.xml', description => 'Purpose of the acl is to send mail', principal => 'INTRANET', is_grant => TRUE, privilege => 'connect', start_date => SYSTIMESTAMP, end_date => NULL); DBMS_NETWORK_ACL_ADMIN.assign_acl ( acl => 'send_mail.xml', host => 'mail.trituenhantao.info', lower_port => 1, upper_port => 1024); COMMIT; END;