oracle apex part4: configuring ldap as authenticator and some troubleshooting

I' will show you how to configure ldap as authenticator + how to solve the error:
ORA-24247 network access denied by access control list (ACL)

[@IB-fz2oq]

Thank you, I upgraded apex from 19 to 20 but no guide is talking about updating the permissions. Only this video helped me

[@edwardohwat7408]

You saved my day :)
After moving database I was trying to test LDAP connection, and it failed.
It turns out that I missed ACLs .
Solved with your video.

[@TramoTech]

I’m glad it helped

[@omatayoholder3349]

Where do I need to run the scripts that rectified the issue? I am using sqldeveloper

[@TramoTech]

any client will do the work.

[@fabianoteixeira9259]

May you Help us about LDAP SSL?

[@VincenzoSozio]

which is the name of the software you use to do queries? it seems like an alternative to sqldeveloper

[@TramoTech]

PL/SQL Developer: www.allroundautomations.com
It’s much better than sql developer, however, it is not free

[@VincenzoSozio]

@@TramoTech ok, tanks for the quick answer!

[@omatayoholder3349]

Hello, I made the necessary changes that is needed from your video after watching it again but now "simple_bind_s has the wrong number or types of arguments."

[@TramoTech]

Hi, can you post the block your are using and oracle version?

[@omatayoholder3349]

The data represents a test environment.

[@omatayoholder3349]

@@TramoTech Error report -
ORA-06550: line 14, column 13:
PLS-00306: wrong number or types of arguments in call to 'SIMPLE_BIND_S'
ORA-06550: line 14, column 1:
PL/SQL: Statement ignored
06550. 00000 - "line %s, column %s:
%s"
*Cause: Usually a PL/SQL compilation error.
*Action:

[@lulis9817]

Ahmed can you help with the solution of same in this video but with a SSL LDAP?

[@baiie1]

Thanks it works for me too

[@omatayoholder3349]

The script is not present.

[@TramoTech]

DECLARE
l_ldap_host VARCHAR2(100) := '192.168.178.78';
l_ldap_port NUMBER := 389;
l_ldap_user VARCHAR2(100) = *cn=afikri, ou=Peole,dc=ksirisoft,dc=de';
l_ldap_passwd VARCHAR2(100) := 'afikri';
l_session RAW(32);
l_retval NUMBER;
BEGIN
l_session := DBMS_LDAP.init(hostname => l_ldap_host, portnum =>l_ldap_port);
l_retval := DBMS_LDAP.simple_bind_s(id => l_session,
dn => l_ldap_user,
passwd =>l_ldap_passwd);
dbms_output.put_line(l_retval);
END;
You need to adjust your ldap information

[@omatayoholder3349]

Thank you for the info. I'm trying to run this in Sqldeveloper using different tabs like you did but can't. Also, is there anything else I need to do to run this is sqldevloper?

[@omatayoholder3349]

I'm extremely new to implementing LDAP, hence the request to know exactly how to do this.

[@omatayoholder3349]

@@TramoTech this is the error I received:
Error report -
ORA-06550: line 11, column 15:
PLS-00320: the declaration of the type of this expression is incomplete or malformed
ORA-06550: line 11, column 1:
PL/SQL: Statement ignored
ORA-06550: line 14, column 23:
PLS-00302: component 'SIMPLE_BING_S' must be declared
ORA-06550: line 14, column 1:
PL/SQL: Statement ignored
06550. 00000 - "line %s, column %s:
%s"
*Cause: Usually a PL/SQL compilation error.
*Action: