My Oracle Support Banner

OID 11g LDAP Search Slow Performance With RDBMS 11gR2 (11.2.0.X, i.e. 11.2.0.3, 11.2.0.4) (Doc ID 1517158.1)

Last updated on APRIL 27, 2018

Applies to:

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

Symptoms

On 11g version, OID LDAP Server
Repository RDBMS Version 11gR2 (11.2.0.X)

After upgrading the database used for OID to version 11.2.0.X
Some LDAP searches, particularly using leading wildcards in the search filter, take a very long time to return a result (eg. up to 10 minutes).

For example:

time $ORACLE_HOME/bin/ldapsearch -p 3060 -D cn=orcladmin -w <password> -b "cn=Users,dc=oracle,dc=com" -s sub "(mail=*doe@oracle*)" mail
cn=johndoe, cn=Users,dc=oracle,dc=com
mail=johndoe@oracle.com

real 8m41.341s
user 0m0.029s
sys 0m0.019s

 

 OID startup may also be very slow. The OID server log shows entries as below for the start cycle.

[2015-10-28T11:30:30+00:00] [OID] [NOTIFICATION:16] [] [OIDLDAPD] [host: oidhost01] [pid: 13393] [tid: 0] Main:: Oid Server Connected to DB store via oiddb connect string.
[2015-10-28T11:30:30+00:00] [OID] [NOTIFICATION:16] [] [OIDLDAPD] [host: oidhost01] [pid: 13393] [tid: 0] Main:: OiD LDAP server started.
[2015-10-28T11:30:30+00:00] [OID] [NOTIFICATION:16] [] [OIDLDAPD] [host: oidhost01] [pid: 13393] [tid: 0] Main:: Loading Root DSE ...
[2015-10-28T11:30:30+00:00] [OID] [NOTIFICATION:16] [] [OIDLDAPD] [host: oidhost01] [pid: 13393] [tid: 0] Main:: Loading subschema subentry ...
[2015-10-28T11:30:30+00:00] [OID] [NOTIFICATION:16] [] [OIDLDAPD] [host: oidhost01] [pid: 13393] [tid: 0] Main:: Loading catalog entry ...
[2015-10-28T11:30:30+00:00] [OID] [NOTIFICATION:16] [] [OIDLDAPD] [host: oidhost01] [pid: 13393] [tid: 0] Main:: Loading Attribute uniqueness constraints ...
[2015-10-28T11:30:30+00:00] [OID] [NOTIFICATION:16] [] [OIDLDAPD] [host: oidhost01] [pid: 13393] [tid: 0] Main:: Loading ACP ...
[2015-10-28T11:30:49+00:00] [OID] [NOTIFICATION:16] [] [OIDLDAPD] [host: oidhost01] [pid: 13393] [tid: 0] Main:: gsldValidteEntry * MissingEdn eid=143799,scp=2,nRows=7700,basedn=,fltr=
[2015-10-28T11:30:50+00:00] [OID] [NOTIFICATION:16] [] [OIDLDAPD] [host: oidhost01] [pid: 13393] [tid: 0] Main:: gsldValidteEntry * MissingEdn eid=152220,scp=2,nRows=10900,basedn=,fltr=
..
<repeats for a long time>
..
[2015-10-28T12:21:07+00:00] [OID] [NOTIFICATION:16] [] [OIDLDAPD] [host: oidhost01] [pid: 13393] [tid: 0] Main:: gsldValidteEntry * MissingEdn eid=1286334,scp=2,nRows=426800,basedn=,fltr=
[2015-10-28T12:22:01+00:00] [OID] [NOTIFICATION:16] [] [OIDLDAPD] [host: oidhost01] [pid: 13393] [tid: 0] Main:: gsldValidteEntry * MissingEdn eid=1296059,scp=2,nRows=433300,basedn=,fltr=
[2015-10-28T12:22:09+00:00] [OID] [NOTIFICATION:16] [] [OIDLDAPD] [host: oidhost01] [pid: 13393] [tid: 0] Main:: Loading Password policy entry ...
[2015-10-28T12:22:09+00:00] [OID] [NOTIFICATION:16] [] [OIDLDAPD] [host: oidhost01] [pid: 13393] [tid: 0] Main:: Loading Verifier profiles ...
..
<proceeds with startup>

  

Changes

Repository RDBMS upgraded to Version 11gR2 (11.2.0.3  in this example)

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
Changes
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.