APEX

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