Katsumi's Blog

SQL Developer doing LDAP lookup

SQL Developer can certainly use LDAP naming and I'm pasting animation GIF of SQL Developer doing LDAP lookup.

Directory Usage Parameters (ldap.ora)

list the host names and port number of the primary and alternate LDAP directory servers

This is the sequence.

  1. In "Connections" pane, create a new connection.
  2. Connection Type == "LDAP"
  3. Type in 3 LDAP server hosts and non-secure ports and SSL ports. You can copy working "DIRECTORY_SERVERS" line in ldap.ora file.
  4. SQLDev accesses one of LDAP server so you can see list of DNs.
  5. Choose one and click "Load" button. Now "DB Service" drop-down has stuff.

Join the discussion

Comments ( 1 )
  • guest Thursday, October 27, 2016

    Thank you very Much its Really helpful & Solved my problem

Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.