Oracle database in node-red docker

General
1

Hello everyone,

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

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

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

2

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

3

@Jack
@maxwebbi

if you couldn't solve, this should work ^

1 Like