Database connection through Directory Naming

[Joe Simunac]

Our DBAs are converting from Local Naming to Directory Naming for connecting to our Oracle DB. This works fine in SQL*PLUS, but I can't figure out how to set it up in PL/SQL Developer.

We have a few copies of Toad 9.x and it gives you the choice of TNS, Direct or LDAP. Is this possible in Developer? I sure hope so, since we're going to be forced to use LDAP after April.

Thanks!

-Joe

 

[Marco Kalter]

This is transparent to the application. You can simply pass the username, password and database, and Oracle Net will use the name resolution method as configured.

 

[Joe Simunac]

Great. That explains why I couldn't find anything. Thanks.

-Joe

 

[martinbalint]

Is it possible, that PL/SQL Developer lists all available databases on LDAP?

 

[Marco Kalter]

No, this is not possible. The database list is restricted to tnsnames.ora.

 

[Lexus]

Is it planned that for future releases it is possible to connect to LDAP-databases?

 

[Marco Kalter]

You can connect with any naming method, including LDAP. You will have to enter the database name by hand though.

 

[Liming]

Hi how do I setup an LDAP database connection manually?
What is the syntax?

These are my LDAP database details.
ldap.ora:
DIRECTORY_SERVERS = (XXX.XX.XXXXXX.XXX::XXXX)
DEFAULT_ADMIN_CONTEXT = "dc=XX,dc=XXXXXXXX,dc=XXX,dc=XX"
DIRECTORY_SERVER_TYPE = OID

database connection name: XXXXXXXXX

Where do I put these details in the connection dialog box?
I've tried everything with no luck.

Thanks in advance.

 

[Marco Kalter]

You can simply enter the database name as defined in LDAP.