How to connect to 11g using ldap?

[Shaleenee Luximo]

Hi,
I need to compare two databases, one on 10g and the other on 11g. I could connect on 10g databases through tnsnames.ora.

I tried listing 11g connection in the tnsnames.ora but it does not work since the connection is ldap.

Could you advise how can I connect to both 10g and 11g and do the comparison?

Looking forward to a reply.

Thank you!

Kind Regards,
Shalee

 

[Marco Kalter]

If both databases are accessible through the same Oracle Client then you can access both from within PL/SQL Developer. It's just a matter of configuring sqlnet.ora correctly.

 

[Shaleenee Luximo]

Thanks for your reply!

Here is what I have in my sqlnet.ora:
# sqlnet.ora Network Configuration File: C:\oracle\product\10.2.0\client\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.

# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

--------------------------------------------------------------------

All the connections are described in tnsnames.ora. The only trouble is 11g is ldap configured.

 

[Marco Kalter]

I see that this Oracle Client is configured for TNSNAMES and EZCONNECT. You will have to add LDAP.