ERROR:-
Error starting at line : 20 in command –
BEGIN
APEX_INSTANCE_ADMIN.VALIDATE_EMAIL_CONFIG;
END;
Error report –
ORA-24247: network access denied by access control list (ACL)
ORA-06512: at “SYS.UTL_TCP”, line 19
ORA-06512: at “SYS.UTL_TCP”, line 295
ORA-06512: at “SYS.UTL_SMTP”, line 164
ORA-06512: at “SYS.UTL_SMTP”, line 201
ORA-06512: at “APEX_210200.WWV_FLOW_MAIL”, line 1040
ORA-06512: at “APEX_210200.WWV_FLOW_MAIL”, line 2375
ORA-06512: at “APEX_210200.WWV_FLOW_INSTANCE_ADMIN”, line 1609
ORA-06512: at line 2
- 00000 – “network access denied by access control list (ACL)”
*Cause: 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.
*Action: Ensure that an access control list (ACL) has been assigned to
the target host and the privilege necessary to access the target
host has been granted to the user.
INTRODUCTION
ORA-24247 means that the user should have the right network privilege in Access Control List (ACL) to resolve hostname or connect to any external servers.
ISSUE
In our case the issue has been occurred due to the wrong id in the hostname.
SOLUTION
STEP1: Check whether the host was properly configured in the dba_network_acls by the below query.
SELECT host FROM dba_network_acls;
HOST
——————————————————————————–
Hostname
STEP2: Create an ACL: In this case, we create an ACL with USERNAME as user , and the privilege is resolve.
BEGIN
DBMS_NETWORK_ACL_ADMIN.CREATE_ACL (
acl => ‘mail_access.xmll’,
description => ‘Connect Network’,
principal => ‘USERNAME’,
is_grant => TRUE,
privilege => ‘resolve’,
start_date => NULL,
end_date => NULL);
END;
/
PL/SQL procedure successfully completed.
NOTE: USERNAME is the username it must be in upper case.
STEP3: After checking the query and creating the new ACL assign the ACL to the correct network (ACL)
BEGIN
DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL (
acl => ‘mail_access.xml’,
host => ‘localhost’);
COMMIT;
END;
/
PL/SQL procedure successfully completed.
STEP4: validate the email configuration settings for the specific APEX instance.
BEGIN
APEX_INSTANCE_ADMIN.VALIDATE_EMAIL_CONFIG;
END;
PL/SQL procedure successfully completed.
After this steps the issue will be resolved.
