This site is currently read-only as we are migrating to Oracle Forums for an improved community experience. You will not be able to initiate activity until January 30th, when you will be able to use this site as normal.

    Forum Stats

  • 3,889,831 Users
  • 2,269,775 Discussions
  • 7,916,823 Comments

Discussions

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

Kunwar
Kunwar Member Posts: 342
edited Jun 12, 2016 8:57PM in SQLcl

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.

Best Answer

  • thatJeffSmith-Oracle
    thatJeffSmith-Oracle Master Product Manager NC, USAPosts: 8,927 Employee
    edited Jun 9, 2016 11:51AM Answer ✓

    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

Answers