We are running several AEPX application and all of them use LDAP authentication.
Authentication works fine... but recently we started facing an interesting issue which locks up all the application and prevents all user from logging into the Applications using LDAP authentication.
The issue came up when multiple users (around 80) logged into a single application simultaneously (Student Orientation to be precise).
Login process is pretty basic
=========================
wwv_flow_custom_auth_std.login(
p_uname => :P10_USERNAME,
p_password => :P10_PASSWORD,
P_SESSION_ID => v('APP_SESSION'),
P_FLOW_PAGE => :APP_ID||':4' );
by debugging the issue found the following error message
Error:
=======
get the following error:
0.11464 0.00028
Exception in "ADLDAP":
Sqlerrm: ORA-31223: DBMS_LDAP: cannot open more than 63 LDAP server connections
Backtrace: ORA-06512: at "SYS.DBMS_LDAP_API_FFI", line 25
ORA-06512: at "SYS.DBMS_LDAP", line 48
ORA-06512: at "APEX_050100.WWV_FLOW_CUSTOM_AUTH_LDAP", line 69
2
0%
0.11492 0.00056
Exception in "ADLDAP":
Sqlerrm: ORA-31204: DBMS_LDAP: PL/SQL - Invalid LDAP Session.
Backtrace: ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.DBMS_LDAP", line 135
ORA-06512: at "APEX_050100.WWV_FLOW_CUSTOM_AUTH_LDAP", line 122
2
0%
0.11548 0.01529
... Authentication failed: Invalid Login Credentials<div id="apex_login_throttle_div">Please wait <span id="apex_login_throttle_sec">5</span> seconds to login again.</div>
Did any of you face this issue. The only fix we have found so far is to bounce the ORDS. I am able to reproduce the issue in SQL developer session. This has to do with unbinding the LDAP session the PLSQL code. Is it possible that the call to wwv_flow_custom_auth_std.login has a call somewhere that is not ubinding the ldap session? Major issue for us. Any help is greatly appreciated.