LLI Wiki — My Digital Knowledge Base

Oracle TNS name resolution with OpenLDAP

Use an OpenLDAP directory instead of Oracle Internet Directory to centralise TNS aliases.

An LDAP directory (OpenLDAP) can act as a central repository for Oracle TNS aliases, replacing Oracle Internet Directory. Two replicated Linux servers provide high availability.

Client configuration

In %ORACLE_HOME%\network\admin:

  1. Edit sqlnet.ora so that LDAP is queried first:
names.directory_path = (LDAP,TNSNAMES)
  1. Add an ldap.ora file:
DIRECTORY_SERVERS = (ldapserver01:389, ldapserver02:389)
DEFAULT_ADMIN_CONTEXT = "dc=example,dc=com"
DIRECTORY_SERVER_TYPE = OID
  1. Remove the local tnsnames.ora file so aliases are resolved through LDAP.

Server configuration

Entries are edited with an LDAP administration client (for example LDAP Admin):

LDAP Admin: LDAP server connection properties

LDAP Admin: copying an existing entry (context menu)

LDAP Admin: editing the orclNetDescString value

Verification

Test name resolution with a simple tnsping on the alias.

Notes

Mastodon LLIMastodon SocialFosstodon