Configure Oracle LDAP Support
You can create Oracle Lightweight Directory Access Protocol (LDAP) connections when your Oracle client is configured for LDAP. Once the client is configured, Toad retrieves names from your LDAP server and displays them in the Database Name list in the Create New Connection window.
Notes:
- To connect using LDAP, you must install an Oracle client on the computer.
- Toad supports a 9i, 10g, and 11 client and the Oracle Instant client. If you want to use the instant client, you must configure it to work with Toad. Configure the Oracle Instant Client
To configure the Oracle client for LDAP
-
Obtain the LDAP.ORA file from your database administrator.
-
Copy the LDAP.ORA file to the folder where the SQLNET.ORA file for your Oracle client is located. The default folder is: ORACLE_HOME\network\admin
-
Open the SQLNET.ORA file and enter "(LDAP)" as the value for the NAMES.DIRECTORY_PATH as follows:
NAMES.DIRECTORY_PATH= (LDAP)
Note: If you are using multiple naming methods, add the (LDAP) value to existing parameter values. For example, if you are using both the TNSNAMES and LDAP naming methods, add LDAP to TNSNAMES as follows:
NAMES.DIRECTORY_PATH= (TNSNAMES, LDAP)
-
Save the SQLNET.ORA file.
-
Launch Toad and select File | New | Connection.
-
Create an LDAP connection following the procedure in Create Oracle Connections. In step 3, select a database on the LDAP server from the Database Name list. Toad retrieves the list of LDAP names from the LDAP server once per Toad session. To refresh the list, click
.