Skip to Main Content

SQLcl: MCP Server & SQL Prompt

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

KunwarJun 7 2016 — edited Jun 12 2016

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.

[kunwar@prodhost ~/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

[kunwar@prodhost ~/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.

This post has been answered by thatJeffSmith-Oracle on Jun 9 2016
Jump to Answer

Comments

Post Details

Added on Jun 7 2016
2 comments
968 views