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

Last updated on AUGUST 15, 2022

Applies to:

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:

Additional examples of searches:

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

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

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