oracle - How do you connect to an LDAP server using node-oracledb?

Question

I have a database that I can connect to using jdbc using the string "jdbc:oracle:thin@ldap://SERVER_NAME:1234/SERVICE,cn=OracleContext,dc-world".

However, when I use node-oracledb, this connection string does not work, presumably because Node doesn't use jdbc. What connection string could I use to connect to the database?

Answer 1

There is no "Easy Connect" syntax available for LDAP so you will need to configure ldap.ora and sqlnet.ora files and use a non-Easy Connect string alias in node-oracledb (or in other tools like SQL*Plus, PHP OCI8, Python cx_Oracle, Golang godror etc).

I'm told (!) the steps are:

1. Invoke netca -> Directory Usage

2. Configure naming to use LDAP by netca->Naming Methods Configuration. This sets up sqlnet.ora for name lookup.

3. run netmgr to setup the entry in ldap or Enterprise Manager to setup ldap.

4. Copy those files to a subdirectory on the machine where you run Node.js, and set TNS_ADMIN to the directory containing the files. With Instant Client you can put it in the networkadmin subdirectory under the Instant Client libraries. See the manaul entry Optional Oracle Net Configuration

5. Set node-oracledb's connectString to the connect alias configured in 3, e.g. "orcl"