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 AUGUST 16, 2022
Applies to:
Oracle Internet Directory - Version 11.1.1.9.0 and laterInformation 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
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 |