Skip to Main Content

General Cloud Infrastructure

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!

How to connect to LDAP?

CamZAJul 18 2023

Good Day Community

I am experiment connect to my AD but I am having an issues connecting in Oracle OCI Free Tier, I added the ACLs using DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE

BEGIN
 DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE(
        host    => 'MYHOST',
        lower_port => 636,
        upper_port => 636,
        ace        => xs$ace_type(privilege_list => xs$name_list('CONNECT'),
                                  granted => true,
                                  principal_name => 'MYPRINCIPALNAME',
                                  principal_type => xs_acl.ptype_db
                                  )
    );
END;

I also granted execute

GRANT EXECUTE ON DBMS_LDAP TO MYUSER;

However when I execute the following:

DECLARE
	x_results VARCHAR2(3000);
BEGIN
	x_results := dbms_ldap.init(hostname => 'MYHOST',
								portnum  => 636);
END;

I get the following error:

ORA-24247: network access denied by access control list (ACL) ORA-06512: at "SYS.DBMS_LDAP_API_FFI", line 25 ORA-06512: at "SYS.DBMS_LDAP", line 48 ORA-06512: at line 5 Error at Line: 7 Column: 0

Can you please advise, what am I missing as I added other ACLs that those are working fine.

Kind Regards

Comments
Post Details
Added on Jul 18 2023
0 comments
260 views