# Oracle database in node-red docker

**URL:** <https://discourse.nodered.org/t/oracle-database-in-node-red-docker/11691>\
**Category:** General\
**Created:** [30 May 2019 03:35 UTC](https://discourse.nodered.org/t/oracle-database-in-node-red-docker/11691 "2019-05-30T03:35:27Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![maxwebbi](https://avatars.discourse-cdn.com/v4/letter/m/f0a364/32.png) [@maxwebbi](https://discourse.nodered.org/u/maxwebbi)\
**Post date:** [30 May 2019 03:35 UTC](https://discourse.nodered.org/t/oracle-database-in-node-red-docker/11691/1 "2019-05-30T03:35:27Z")

</div>

Hello everyone,

i'm trying to run my node-red in a docker container with an oracledb node.  
My dockerfile is as follows:

```auto
FROM nodered/node-red-docker

ENV http_proxy <IP:Port>

USER root

RUN apt-get update
RUN npm set proxy <IP:Port>
RUN npm set https-proxy <IP:Port>
RUN apt-get install nano -y
RUN npm install node-red-contrib-oracledb-mod

```

If you are wondering why I'm using the 'mod'-version of the oracledb node: the normal 'node-red-contrib-oracledb' node didn't work to install.

After I start my docker container the node-red client is running and I can open the webinterface. The oracledb node is listed in the left 'node menu'. But unfortunately I get an 'connect error' when I try to connect to my oracle database.  
In my logfile i see this error message

```auto
Oracle-server error connection to <IP>: DPI-1047: Cannot locate a 64-bit Oracle Client library: "libclntsh.so: cannot open shared object file: 
No such file or directory".
 See https://oracle.github.io/odpi/doc/installation.html#linux for helpNode-oracledb installation instructions: 
https://oracle.github.io/node-oracledb/INSTALL.html
You must have 64-bit Oracle client libraries in LD_LIBRARY_PATH, or configured with ldconfig.
If you do not have Oracle Database on this computer, then install the Instant Client Basic or Basic Light package from http://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html

```

I already did my research, but couldn't find any solution

---

<div class="post-metadata">

**Author:** ![Jack](https://avatars.discourse-cdn.com/v4/letter/j/cc9497/32.png) [@Jack](https://discourse.nodered.org/u/Jack)\
**Post date:** [6 August 2019 08:58 UTC](https://discourse.nodered.org/t/oracle-database-in-node-red-docker/11691/2 "2019-08-06T08:58:20Z")

</div>

I had the same problem, and I couldn't solve it.

---

<div class="post-metadata">

**Author:** ![RyuunosukeDS3](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/ryuunosukeds3/32/22503_2.png) [@RyuunosukeDS3](https://discourse.nodered.org/u/RyuunosukeDS3)\
**Post date:** [8 May 2021 19:27 UTC](https://discourse.nodered.org/t/oracle-database-in-node-red-docker/11691/3 "2021-05-08T19:27:40Z")

</div>

> [@Node-RED docker image with oracle instant client](https://discourse.nodered.org/t/node-red-docker-image-with-oracle-instant-client/45374):
>
> I've created a Dorckerfile that when built creates an image with latest Node-RED and an oracle instant client to access oracledb. I was not sure where to post this, but since I've seen a lot of ppl having trouble to use oracledb on Node-RED docker I thought it would be a great idea to share this. Cheers!

@Jack  
@maxwebbi

if you couldn't solve, this should work ^