Here are some of the commonly seen issues during integrating a database with Directory Services:
Issue 1: The Directory Service tab is not displayed in DBCA
- Is ldap.ora correctly configured? Compare with the example earlier in this section.
Create an ldap.ora in $ORACLE_HOME/network/admin that points to your directory services instance. The file may be created using the Network Configuration Assistant (netca) or any text editor. Below is an example of the content of the file.
DEFAULT_ADMIN_CONTEXT = "dc=ziontech,dc=net"
DIRECTORY_SERVER_TYPE = OID
- Is the correct ldap.ora located in DBCA? Check that the correct ldap.ora is located first in the search path.
Issue 2: DBCA fails to complete registration, Database Configuration Assistant: Error. Unable to create database entry in the directory service. – No Listeners configured
- Check that a copy of the listener.ora exists in the default network admin directory and that it was created via the Oracle network tools (i.e., Net Manager or Net Configuration Assistant).
- Check if the environment variables, such as TNS_ADMIN, are configured to point to the correct directory.
Issue 3: DBCA fails to complete registration, Database Configuration Assistant: Error.Unable to create database entry in the directory service
- Check if the database is already configured for LDAP Naming resolution. If the entry exists, the DBCA failed to register to OID.
- Remove the current LDAP entry before trying to register the database again. A LDAP naming entry have to be deleted using Net Manager.
I will keep updating this post with any new issues that I encounter.