Oracle Internet Directory

Oracle Internet Directory (OID) is a standard LDAP directory server. OID is part of the Oracle Application Server.

Start .stop and Status the OID server

To start OID:

${ORACLE_HOME}/opmn/bin/opmnctl startall

To stop:

${ORACLE_HOME}/opmn/bin/opmnctl stopall

To get OID process status using opmnctl:

${ORACLE_HOME}/opmn/bin/opmnctl status

To start a specific OID instance using opmnctl:

${ORACLE_HOME}/opmn/bin/opmnctl startproc ias-component=oid1

To get OID process using oidctl (OID Version 11g and higher):

${ORACLE_HOME}/oidctl connect=oiddb status

OID Utilities

Some related utilities to manage OID entries:

LDAP bind

Test if you can bind (connect) to the OID server:

$ ldapbind -p 389 -h my-host-name 
bind successful

Add OID entries

Add an entry/ entries to the OID server:

$ ldapadd -h my-host-name -p 389 -D "cn=orcladmin" -w mypassword -f onames.ldif

Lookup OID entries

Lookup an SQL*Net Service Name (in the example below, extract orclnetdescstring for TESTENTRY) in the OID directory:

$ ldapsearch -h my-host-name -p 389 -D "cn=orcladmin" -w mypassword -b "cn=TESTENTRY,cn=OracleContext,dc=mycompany,dc=com" -s base "objectclass=*" orclnetdescstring

Lookup all user information using the mail attribute as the filter under a specified domain

$ ldapsearch -h my-host-name -p 389 -D "cn=orcladmin" -w mypassword -b "dc=mycompany,dc=com" -s sub "mail=*" 

Lookup a specific user in LDAP using a specific mail value

$ ldapsearch -h my-host-name -p 389 -D "cn=orcladmin" -w mypassword -b "dc=mycompany,dc=com" -s sub "mail=john.smith@mail.com" 

Looking up a specifici user in LDAP but returning only the values for mail and uid attributes.

$ ldapsearch -h my-host-name -p 389 -D "cn=orcladmin" -w mypassword -b "dc=mycompany,dc=com" -s sub "mail=john.smith@mail.com" mail uid

Lookup all user information using the inetorgperson attribute as the filter under a specified domain and only returning the dn record

$ ldapsearch -h my-host-name -p 389 -D "cn=orcladmin" -w mypassword -b "dc=mycompany,dc=com" -s sub "objectclass=inetorgperson" dn

Modify an OID entry

$ ldapmodify -h my-host-name -p 389 -D cn=orcladmin -w mypassword -c -v -f <filename>.ldif

Delete an OID entry

$ ldapdelete -h my-host-name -p 389 -D "cn=orcladmin" -w mypassword "cn=TESTENTRY,cn=OracleContext,dc=mycompany,dc=com"

Diagnostic Data

The following can only be performed on 11G and above.

$ oidctl connect=oiddb status -diag

Also see

• Ldap.ora, file used to configure directory naming for SQL*Net