PL/SQL Developer and LDAP connection

[Piszu]

Hello,

Can someone explain me how to connect to DB with PL/SQL Developer using LDAP connections?

I have this configuration:

Version 13.0.5.1908  (64 bit)
  Windows 10 Build 17134

DLLs

C:\app\User\product.2.0\client_1\oci.dll

TNS File

C:\app\User\product.2.0\client_1\Network\Admin\tnsnames.ora

Directory: C:\app\User\product.2.0\client_1\Network\Admin
Mode                LastWriteTime         Length Name
----                -------------         ------ ----
-a----       2019-06-05     12:02            138 ldap.ora
-a----       2019-06-05     11:48             27 sqlnet.ora
-a----       2019-06-05     11:45            296 tnsnames.ora

sqlnet.ora:

NAMES.DIRECTORY_PATH=(LDAP)

ldap.ora

DEFAULT_ADMIN_CONTEXT = cn=OrcaleContext,dc=XX,dc=XX,dc=XXX
DIRECTORY_SERVERS = (oid.XX.XX.XXX:389)
DIRECTORY_SERVER_TYPE = OID

tnsnames.ora

Empty file

Thanks for help and support!

 

[Marco Kalter]

When using LDAP you can use the database names that are defined through LDAP. PL/SQL Developer will not show LDAP names in the database list though, like it does when using TNSNAMES.

 

[LDAP_KING]

For dummies like me who have got sql developer by default:

Create file ldap.ora in \app\User\product\12.2.0\client_1\Network\Admin\ using:
DEFAULT_ADMIN_CONTEXT = cn=OrcaleContext,dc=XX,dc=XX,dc=XXX
DIRECTORY_SERVERS = (XXX.XX.XX.XXX:389)
DIRECTORY_SERVER_TYPE = OID

Add LDAP into sqlnet.ora:
NAMES.DIRECTORY_PATH=(NTS,LDAP)

Find necessary SID(Service_name) using sql developer:
DB Service field in Connection type LDAP after you pressed "load" and got a list, as was mentioned before.

Use username + password + DB service name in Database field in connection window.