# Oracle db connection

**URL:** <https://discourse.nodered.org/t/oracle-db-connection/43415>\
**Category:** General\
**Created:** [30 March 2021 18:18 UTC](https://discourse.nodered.org/t/oracle-db-connection/43415 "2021-03-30T18:18:36Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Kins](https://avatars.discourse-cdn.com/v4/letter/k/c67d28/32.png) [@Kins](https://discourse.nodered.org/u/Kins)\
**Post date:** [30 March 2021 18:18 UTC](https://discourse.nodered.org/t/oracle-db-connection/43415/1 "2021-03-30T18:18:36Z")

</div>

Can someone help me with the oracle database connection in node-red.  
I've installed the node-red-contrib-oracledb-mod node. I'm not able to proceed ahead with the connection.  
I don't understand what is the oracle instant client path etc..I have oracle database working in my machine though.  
Need your support as I'm very much new to node red and to oracle database.

---

<div class="post-metadata">

**Author:** ![Steve-Mcl](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/steve-mcl/32/4826_2.png) [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)\
**Post date:** [1 April 2021 00:08 UTC](https://discourse.nodered.org/t/oracle-db-connection/43415/2 "2021-04-01T00:08:34Z")

</div>

> [@Kins](#):
>
> I don't understand what is the oracle instant client path etc..I have oracle database working in my machine though.

oracle instant client is database access binaries for data access. They are typically installed on machines where you need to query an oracle database.

I have never used this node but a quick bit of investigation lead me to [this](http://oracle.github.io/node-oracledb/doc/api.html#-33411-options)...

> This specifies the directory containing the Oracle Client libraries. If `libDir` is not specified, the default library search mechanism is used. If your client libraries are in a full Oracle Client or Oracle Database installation, such as Oracle Database “XE” Express Edition, then you must have previously set environment variables like `ORACLE_HOME` before calling `initOracleClient()` . On Windows, remember to double each backslash used as a directory separator. See [Locating the Oracle Client Libraries](http://oracle.github.io/node-oracledb/doc/api.html#oracleclientloading).

So if you have not installed the oracle instant client, do so and make note of where it is installed. If you have already installed oracle instant client, then enter the directory path of where it is installed into the node config.

Thats all the help i can offer i'm afraid.

If you need more help, then try contacting the nodes author.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [31 May 2021 00:09 UTC](https://discourse.nodered.org/t/oracle-db-connection/43415/3 "2021-05-31T00:09:04Z")

</div>

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.