Dear Friends,
I am trying to enable LDAP authentication in the Oracle apex 19.2 workspace,
Oracle apex 19.2
Database : Oracle 12c
Checking the permission:
1. select host, acl_owner from dba_network_acls;
host acl_owner
------ -------------
* SYS
localhost SYS
2. select principal, privilege from dba_network_acl_privileges where PRINCIPAL ='APEX_190200';
PRINCIPAL PRIVILEGE
------------------ ------------------
APEX_190200 connect
APEX_190200 connect
For both acl (*, localhost), there is already connect privilege is available.
However when i am connecting the LDAP in APEX_190200 schema in SQL developer, i am getting the error,
DECLARE
l_ldap_host VARCHAR2(256) := 'ldap domain name'; --Supplying the values
l_ldap_port VARCHAR2(256) := '389';
l_ldap_user VARCHAR2(256) := 'CN=user name,OU=OU Name,DC=DC Name,DC=com'; --Supplying the values
l_ldap_password VARCHAR2(256) := 'Password';
l_retval PLS_INTEGER;
l_session DBMS_LDAP.session;
BEGIN
-- Connect to the LDAP server.
l_session := DBMS_LDAP.init(hostname => l_ldap_host,
portnum => l_ldap_port);
l_retval := DBMS_LDAP.simple_bind_s(ld => l_session,
dn => l_ldap_user,
passwd => l_ldap_password);
dbms_output.put_line(l_retval);
l_retval := DBMS_LDAP.unbind_s(ld => l_session);
END;
Error report -
ORA-31202: DBMS_LDAP: LDAP client/server error: Invalid credentials. 80090308: LdapErr: DSID-0C090436, comment: AcceptSecurityContext error, data 52e, v23f0
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_LDAP", line 1487
ORA-06512: at "SYS.DBMS_LDAP", line 79
ORA-06512: at line 14
31202. 00000 - "DBMS_LDAP: LDAP client/server error: %s"
*Cause: There is a problem either on the LDAP server or on the client.
*Action: Please report this error to the LDAP server administrator or
your Database administrator
I am getting the same error in Oracle apex 19.2 Test LDAP login interface in workspace authentication creation screen.
Advance thanks for all your time on this.
Thanks & Regards,
Stalin