Using LDAP to connect

dgs!

Member³
I just started working for a new company. They use Oracle's SQL Developer as their editor. It's alright, but its no PL/SQL Developer.
I am struggling to connect to the database. They only use LDAP. I don't know what to enter as the database connector.
 
Last edited:
Cam some on give me an example of how to complete the connection set up?
Username:
Database:
Password

No databases show up in the drop down display

Should I use??
Username: name/password@database
Database: empty
password: empty
 
I was able to cobble together a TNSNAMES.ora file based on a few things.
1) Review the contents of the LDAP.ora file to obtain the service name
2) Execute SELECT sys_context('USERENV','DB_NAME'), sys_context('USERENV','HOST') from dual

Using that info you can create a TNSNAMES.ora file that can be used by PL/SQL Developer.
 
Back
Top