My Oracle Support Banner

OID 10g ( Returns Nothing / No Results (Or Partial Results) From Ldap Searches (Doc ID 1151713.1)

Last updated on AUGUST 15, 2022

Applies to:

Oracle Internet Directory - Version and later
Information in this document applies to any platform.


Oracle Internet Directory (OID) 10g

Two systems, for example, INT and DEV.

After applying database init.ora workaround from <Note 798287.1>, the DEV instance now works fine, however the INT instance still experiences the problem.

Compared all %ORACLE_HOME% exe's, dll's, versions, patches, etc., between the working and non-working systems but found minimal differences (i.e., only for a few unrelated EM files).

Both nodes have the same in memory filter settings for OAM integration as outlined in <Note 558040.1>.  The only difference found between the two systems is that INT uses a RAC Database as backend whereas DEV uses a standalone Database (but that was not relevant to the issue).

Also tried applying <Patch 7650481> but the problem persits.

Problem Details:
Searches are not returning expected results, i.e., return nothing / return no results or only partial results.

Sample problem search:

ldapsearch -h <int oid host> -p <port> -D "cn=orcladmin" -w <pasword> -b "ou=internal,o=myorg,c=mycountry" -s sub "(&(objectclass=inetOrgPerson)(modifytimestamp>=20090313205713Z))"

Additional examples of searches:

ldapsearch -h <int oid host> -p <port> -D "cn=orcladmin" -w <pasword> -b "ou=internal,o=myorg,c=mycountry" -s one (objectclass=inetOrgPerson) dn

ldapsearch -h <int oid host> -p <port> -D "cn=orcladmin" -w <pasword> -b "ou=internal,o=myorg,c=mycountry" -s one "(modifytimestamp>=20090909000000)" dn

Getting results (where overlap exists) for the first 2 queries above.

ldapsearch -h <int oid host> -p <port> -D "cn=orcladmin" -w <pasword> -b "ou=internal,o=myorg,c=mycountry" -s one "(&(objectclass=inetOrgPerson)(modifytimestamp>=20090909000000))" dn

This third query returns nothing.

Steps to Reproduce:
After further testing, the issue can be reproduced consistently by using the following steps on a typical OID installation on Windows with typical standalone Database included:

1. Set environment variables correct for the OID home, i.e. in Windows:


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.