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.
Comments are closed.