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 JULY 05, 2017

Applies to:

Oracle Internet Directory - Version 9.0.4 and later
Information 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

 

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms