How to index an attribute in OID
This could be easy task but I thought it would be useful for somebody. I had to index an attribute in Oracle Internet Directory for some other purpose.
First of all, not all attributes are indexed in OID by default. You can search whether your attribute is indexed or not using Oracle Directory Manager.
You can see the above screenshot to find a seperate column for Index and a checkbox representing whether the specific attribute is indexed or not.
How to configure index to an attribute:
There is a utility called catalog which is located in $OID_HOME/ldap/bin. Please note that it is not shell script or something.
Suppose if I want to index the attribute userPassword, then execute the catalog script as shown below.
The input parameters denote:
connect : database string used by OID to connect to the database, it is Oracle SID.
add: adding index
attribute: attribute name (to find this, see the Oracle Directory Manager for exact attribute name)
Please also note that indexing will also lead to performance issues and hence don’t perform unless required.
About the Author Mahendra
I am engulfed in Oracle Identity & Access Management domain. I have expertise on providing the optimized solutions for user provisioning, web access management, Single Sign-On and federation capabilities etc., I am also well versed with complex integrations within Identity Management and other product domains. I have expertise on building demos and implementation experience on products Oracle Access Manager, Oracle Adaptive Access Manager, Oracle Entitlement Server, Oracle Virtual Directory, Oracle Internet Directory etc., Look @ my blog: http://talkidentity.blogspot.com