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