Ldap.ora

The ldap.ora configuration file sets the LDAP properties.

Note that Oracle 10g cannot use Oracle Names Servers to resolve SQL*Net service names anymore. As workaround, users must convert to use LDAP directory naming.

Configuration

To use a LDAP server for SQL*Net directory naming, set the following parameter in your sqlnet.ora file:

NAMES.DIRECTORY_PATH=(LDAP)

or, if you are using more than one name resolution adapters:

NAMES.DIRECTORY_PATH=(LDAP, TNSNAMES, ...)

Create a LDAP.ORA file in your $ORACLE_HOME/network/admin directory. Here is an example:

DEFAULT_ADMIN_CONTEXT = “ou=oracledatabases,dc=mycompany,dc=com”
DIRECTORY_SERVERS = (ldap_server1.mycompany.com:389:636, ldap_server2.mycompany.com:389:636, ...)
DIRECTORY_SERVER_TYPE = OID

To test connectivity, just do a tnsping or connect to the database from your application.