I was doing some Windows username and password testing this morning and ran into the following error.
ORA-31223: DBMS_LDAP: cannot open more than 63 LDAP server connections
After some research and examination of my function, there was a “leak” in that not every session opened was being closed.
lv_session := dbms_ldap.init(lv_host, 389);
lv_return := dbms_ldap.simple_bind_s(lv_session, p_username, p_password);
lv_return := dbms_ldap.unbind_s(lv_session);
The critical code is shown above. The unbind_s was being done in my error handler, but not in the main body. Obviously, this was dumb and has been corrected. The problem is, my server is now jammed up with active sessions.
Is there a SQL command or do I have to bounce the server?
Rob