DBMS_LDAP Against MS AD Returning More than a Thousand (> 1000) Entries Fails with: Ora-31202 Ldap Error: Sizelimit Exceeded
(Doc ID 292932.1)
Last updated on AUGUST 30, 2023
Applies to:
Oracle Internet Directory - Version 9.0.4 and laterInformation in this document applies to any platform.
Symptoms
When executing DBMS_LDAP.search_s against Microsoft Active Directory (MS AD) which returns more than 1000 entries, you get the error messages:
ORA-31202: DBMS_LDAP: LDAP client/server error: Sizelimit exceeded
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_LDAP", line 1342
ORA-06512: at "SYS.DBMS_LDAP", line 241
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_LDAP", line 1342
ORA-06512: at "SYS.DBMS_LDAP", line 241
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |