There are some community nodes but they are not updated for long time. Hoping n8n will create one. Need that too.
This is something I would love to have, to āvalidateā n8n in our environment.
@BadRequest @Mulen
I finally made the time yesterday to fork from one of the community oracle nodes and add parameterizzation. The code for that is published here now: https://www.npmjs.com/package/n8n-nodes-oracle-database-parameterization
(not going to claim itās perfect or anything since Iāve barely tested it, but so far it looks like itās working)
3 Likes
Wow thanks. Will definetely try this out.
Thanks for the great work
Is there any way to access Oracle through an ssh tunnel?
Not sure? Thatās not something Iāve ever tried before. But the magical world of npmjs.com probably has some libraries related to ssh tunneling. So Iām sure that if you fork from my repo: jgriffin1/n8n-nodes-oracle-database-parameterization: An N8N node for Oracle database queries that utilizes parameterization to increase security. (github.com) youāll be able to modify the code in way that gets that working. My team ended up going a different direction and is no longer using N8N, so this isnāt something Iām going to explore myself right now. But feel free to update this chat if you figure something out!
Can anyone integrate oracledb with n8n?
Since 2020, the community has been asking for it, but it has not been done. So they wonāt do it 
An Oracle Node would be great because then with just one node developers would have access to the Oracle Converged Database, which means they could do relational, graph, spatial, machine learning, ā¦ all from one node.
Hi
I just managed to work with oracle database using n8n-nodes-oracle and Oracle Instant Client in docker
For this a new image must be created on top of the base image adding n8n-nodes-oracle and instantclient-basic
hello, can you share the steps or the dockerfile for me to try in my environment? Im trying using base n8n and external access to instantclient (db is on another server) but had no successā¦
FROM docker.n8n.io/n8nio/n8n
USER root
RUN npm_config_user=root npm install -g n8n-nodes-oracle
ENV N8N_CUSTOM_EXTENSIONS "/usr/local/lib/node_modules/n8n-nodes-oracle"
RUN apk add --no-cache libaio wget unzip
COPY instantclient-basic-linux.x64-21.12.0.0.0dbru.el9.zip /tmp/
RUN cd /tmp && \
unzip instantclient-basic-linux.x64-21.12.0.0.0dbru.el9.zip && \
mkdir -p /opt/oracle && \
mv instantclient_* /opt/oracle/instantclient && \
rm -rf /tmp/instantclient-basic-linux.x64-21.12.0.0.0dbru.el9.zip
ENV LD_LIBRARY_PATH=/opt/oracle/instantclient:$LD_LIBRARY_PATH
ENV PATH=/opt/oracle/instantclient:$PATH
ENV TNS_ADMIN=/opt/oracle/instantclient/network/admin
RUN rm -rf /var/cache/apk/*
USER root
4 Likes
was there any update on this? would be great to have Oracle node on cloud. It will be a game changer.
ty @Gerson_Monteiro !
sadly i am a newbie with docker and iām having difficulty creating a āmodifiedā n8n image via your dockerfile that will remain persistent for me in case of a reboot.
you wouldnāt happen to have a link to an already compiled n8n image including the addition of oracle instant client?
my oracle db is version 11 so i need the instantclient to connect
I just added the oracle working image to my docker hub repository, you pull now
https://hub.docker.com/r/gersonmonteiro/n8n
1 Like
TY so much!! you saved me! <3
1 Like
Still no word on when this will be available? We need Oracle 23ai features with n8n!
@bill383929 what particular Oracle Database 23ai features are you looking for?
Vector, RDMS, Json all in one db.
Any update on this? Oracle support is mandatory for our use caseā¦
Hi @Jon , Hope you are doing well!
As you are part of the n8n team, I am hoping that you will be able to answer my query.
I was wondering what is the procedure for a Source Code contribution for Oracle Database support?
Do we raise a separate PR?
How do I get in touch with the n8n team?
Who do I talk to understand the licensing agreements?