Skip to Main Content

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.

Once again: Network access denied by access control list (ORA-24247)

Hans Körber6 days ago

Dear All,

I installed Apex 24.1 and ORDS 24.1 in Oracle 21c XE on Oracle Linux 7.9.

I imported a small Apex 5 application that uses a plugin to connect to an LDAP server. During the first call to DBMS_LDAP.INIT the error

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

consistently occurs. I used

SYS_CONTEXT('USERENV', 'SESSION_USER') 

to identify the user executing the app. Based on this, I added an ACE:

BEGIN
   DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE(
     host => '172.31.14.200',
     ace  =>  xs$ace_type(privilege_list => xs$name_list('connect', 'resolve'),
                          principal_name => 'apex_public_user',
                          principal_type => xs_acl.ptype_db));
END;

then added some more for users APEX_240100, ENTWICKLUNG (the parsing scheme for the app), DLA_AUTH (the owner of the plugin code). However, the error persists.

The application functioned well on Oracle 11g / Application Express 5.1.4 with ACL modifications similar to those described above.

Any help would be most appreciated.

Kind regards

Hans

This post has been answered by Hans Körber on Jul 11 2024
Jump to Answer
Comments
Post Details
Added 6 days ago
8 comments
74 views