How to get the LDAP working for connecting to different databases that we support

Kunwar

Hi,

I am not able to configured the LDAP working.

Below are the content of my ldap.ora and sqlnet.ora in $TNS_ADMIN directory on the our linux prod host.

I have renamed some details for security reason.

[[email protected] ~/TNS]$ cat sqlnet.ora

NAMES.DIRECTORY_PATH= (LDAP, TNSNAMES, EZCONNECT)

AUTOMATIC_IPC = ON

TRACE_LEVEL_CLIENT = OFF

SQLNET.EXPIRE_TIME = 0

BREAK_POLL_SKIP=16

SQLNET_ALLOWED_LOGON_VERSION =10

SQLNET.INBOUND_CONNECT_TIMEOUT=0

[[email protected] ~/TNS]$ cat ldap.ora

DEFAULT_ADMIN_CONTEXT = "dc=db,dc=btc,dc=com"

DIRECTORY_SERVERS=(abc.def.com:3000:3900, abc.dee.com:3000:3900, abc.edf.com:3000:3900, abc.fde.com:3000:3900, abc.efd.com:3000:3900, abc.eff.com:3000:3900)

DIRECTORY_SERVER_TYPE = OID

i have gone through the below link but didnt understand at all how to use it. Can anyone please help here?

Barry McGillin: SQLCl - LDAP anyone?

Regds,

Kunwar.

thatJeffSmith-Oracle

you're doing things that would make sense for a THICK connection, by default SQLcl uses thin jdbc connections

barry's post shows you how to set those same LDAP/SQLNet type settings for thin jdbc

did you try any of them? if you don't understand part of if, ask a specific question, or leave it on barry's blog

thatJeffSmith-Oracle

you're doing things that would make sense for a THICK connection, by default SQLcl uses thin jdbc connections

barry's post shows you how to set those same LDAP/SQLNet type settings for thin jdbc

did you try any of them? if you don't understand part of if, ask a specific question, or leave it on barry's blog

Kunwar

Thanks Jeff! I tried and it worked. Sweeeeeeet