OID Connectivity for Oracle

25 Oct 2013

OID allows Oracle DBAs to centralize name management, instead of us all having our out-of-date local connection data in our many separate tnsnames.ora files (tnsnames can still be used as a fallback if needed).

Example contents of sqlnet.ora:

#SQLNET.AUTHENTICATION_SERVICES= (NTS)  
NAMES.DIRECTORY_PATH=(LDAP,TNSNAMES)

Example contents of ldap.ora:

DIRECTORY_SERVERS=(oidsrv01:3060:3131,oidsrv02:3060:3131)  
DEFAULT_ADMIN_CONTEXT = "dc=oracle,dc=local"  
DIRECTORY_SERVER_TYPE = OID

In this example, oidsrv01 and oidsrv02 (and more as needed) have to be replaced by actual OID server names, of course.