title: Tuning Oracle Internet Directory link: https://onemoretech.wordpress.com/2009/08/25/tuning-oracle-internet-directory/ author: lembobro description: post_id: 265 created: 2009/08/25 14:25:34 created_gmt: 2009/08/25 14:25:34 comment_status: open post_name: tuning-oracle-internet-directory status: publish post_type: post

Tuning Oracle Internet Directory

Short of taking hostages from the Oracle consulting team before the production turnover of your first OAS (Oracle Application Server) 10g implementation, anyone responsible for an environment dependent on Oracle Internet Directory (OID) is going to have to familiarize themselves with the basics of managing what is a remarkably complex RDBMS-backed LDAP directory server.

For those new to LDAP it will be difficult enough, but for veteran directory admins there’s about a ninety degree learning curve — straight up. Most directory servers use relatively simple hash table managers to store, index and retrieve data. Oracle (and IBM, with it’s DB2-backed eDirectory) instead uses its own Oracle 10g RDBMS (the next generation of OID, part of OAS 11g, uses the 11g database).

Don’t look to Oracle’s in classroom or online training for any help in doing this. Currently they don’t touch on the database management aspects of the OID product. Instead, you’ll need to scour Oracle’s web site and do some Googling for resources.

One of those resources is Oracle Internet Directory Tuning and Configuration: A Quick Reference Guide. I happened upon this during an Internet search that took me to the One Size Doesn’t Fit All blog of Australian Oracle consultant Chris Muir. The specific post in question is OID Performance Tuning and uses a case study approach to lay out what needs to be done in getting an existing mis-configured environment up to snuff.

Even after working with OID for a couple of years, I am embarrassed to say that much of what I found in Chris’s post was new to me at the time. That embarrassment is tinged with disappointment over the abject failure of Oracle and its army of consultants to provide my team with the requisite basic education and, for those who worked at our site, configuration guidelines, to actually run this stuff successfully in production. From the “Quick Reference Guide”:

The out of box OID configuration is not optimal for most production or test deployments. It is hence imperative that some basic tuning and configuration changes are performed after OID installation to achieve optimal performance and availability.

Copyright 2004-2019 Phil Lembo