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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

jariola

You need give ACL only to APEX schema (APEX_190200).

After you did run procedure, did you commit? If I recall correctly, you need commit.

wanglei_CN

hi jariola.

 thanks for your advice. As you see I have given ACL only to APEX schema (APEX\_190200).And I'm very sure it had committed.

 But it didn't work well,still raise ORA-24247: network access denied by access control list (ACL).

pastedImage_0.png

pastedImage_1.png

1 - 2

Post Details

Added on Jan 12 2020
#apex-discussions
2 comments
815 views