Skip to Main Content
Forums

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

APEX send email，denied by ACL

wanglei_CNJan 12 2020 — edited Jan 12 2020

Hello everyone.

 oracle db 19C  + APEX 19.2

 I want to send email in my apps.But I can't make it,please give me some advice.

 Thanks for any help.
  1. I run this pl/sql refer to the Oracle APEX 19.2 Guide.

BEGIN DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE( host => '*', ace => xs$ace_type(privilege_list => xs$name_list('connect'), principal_name => 'APEX_190200', -- I have changed it to my schema,you can see next picture principal_type => xs_acl.ptype_db)); END; /

 2. then I check the acl privilege,it seems like no error.

pastedImage_6.png

 3. and then I configure my email server:

pastedImage_7.png

 4. finally I got ACL error when I attempt to send test email,I can find them in Mail Queue,just can't send.

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

pastedImage_8.png
Comments
Post Details
Added on Jan 12 2020
#apex-discussions
2 comments
866 views