title: indexing attributes on oracle internet directory link: https://onemoretech.wordpress.com/2007/07/05/indexing-attributes-on-oracle-internet-directory/ author: lembobro description: post_id: 675 created: 2007/07/05 18:04:00 created_gmt: 2007/07/05 18:04:00 comment_status: open post_name: indexing-attributes-on-oracle-internet-directory status: publish post_type: post

indexing attributes on oracle internet directory

Basic task that we all have to do, no matter what vendor’s directory we use.

For OID, like almost everything else, it requires a special tool to reindex the database. The tool is called catalog. It’s found under $ORACLE_HOME/ldap/bin.

`

$ORACLE_HOME/ldap/bin/catalog connect=[oiddbsid] add="TRUE" 
attribute="[attributename]" [or file="filename"]

`

You can do a bunch of attributes with the optional “file=” parameter instead of “attribute=”, where the value would be the path to a text file containing a simple list of the attributes to be indexed, one attribute name per line.

Sometimes the change will be effective right after running the command (Oracle actually recommends shutting down OID before indexing — which makes sense on a heavily used production system). Other times you’ll have to restart OID to see the change take place.

Copyright 2004-2019 Phil Lembo