My Oracle Support Banner

OID Database upgrade to 19c - Ldapsearch Slow Performance "Does the orcldboptparam parameter need to be updated to a 19.x version?" (Doc ID 2718521.1)

Last updated on OCTOBER 09, 2020

Applies to:

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

Symptoms

1.  Upgraded the database used by 11.1.1.9 OID from 11.2.0.4 to 19c (19.8 in this case).

2.  Ldapsearch performs slower after upgrade

time ldapsearch -h <OID_HOSTNAME> -p <OID_PORT> -D "cn=orcladmin" -w <PASSWORD> -T -L -s sub -b "cn=users, dc=<COMPANY>" "(&(objectclass=person)(uid=*<UID_VALUE*))"

real    0m11.782s
user    0m0.006s
sys     0m0.004s


#######using 11.2.0.4 DB #######
time ldapsearch -h <OID_HOSTNAME> -p <OID_PORT> -D "cn=orcladmin" -w <PASSWORD> -T -L -s sub -b "cn=users, dc=<COMPANY>" "(&(objectclass=person)(uid=*<UID_VALUE*))"

real    0m0.028s
user    0m0.009s
sys     0m0.004s

 

3.  Question: Does the orcldboptparam parameter/attribute need to be updated to a 19.x version? (as per Doc ID 1517158.1)

4. Attempts to modify orcldboptparam in OID to valid OPTIMIZER_FEATURES_ENABLE version number, e.g. 19.1.0 errors with

"ldap_modify: additional info: Invalid value for orcldboptparam"

example ldif file used

dn: cn=dsaconfig,cn=configsets,cn=oracle internet directory
changetype: modify
replace: orcldboptparam
orcldboptparam: 19.1.0

ldapmodify -h <OID_HOSTNAME> -p <OID_PORT> -D cn=orcladmin -w <PASSWORD> -f <LDIF FILENAME>
ldap_modify: additional info: Invalid value for orcldboptparam

 

Changes

 Upgraded OID database to 19c

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


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