My Oracle Support Banner

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

Last updated on FEBRUARY 25, 2019

Applies to:

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

Symptoms

Oracle Internet Directory (OID) 10g 10.1.4.3.0.

Scenario:
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 10.1.4.3 OID installation on Windows with typical 10.1.0.5 standalone Database included:

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

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!


In this Document
Symptoms
Cause
Solution
References


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