# Need to connect with oracle 9i

**URL:** <https://discourse.nodered.org/t/need-to-connect-with-oracle-9i/100058>\
**Category:** General\
**Created:** [31 December 2025 15:43 UTC](https://discourse.nodered.org/t/need-to-connect-with-oracle-9i/100058 "2025-12-31T15:43:09Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![redodistira](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/redodistira/32/75525_2.png) [@redodistira](https://discourse.nodered.org/u/redodistira)\
**Post date:** [31 December 2025 15:43 UTC](https://discourse.nodered.org/t/need-to-connect-with-oracle-9i/100058/1 "2025-12-31T15:43:09Z")

</div>

Hi, I need to connect oracle 9i with jdbc connection. I was try to install node-red-contrib-jdbc but failed with log

```auto
npm WARN deprecated inflight@1.0.6: This module is not supported, and leaks memory. Do not use it. Check out lru-cache if you want a good and tested way to coalesce async requests by a key value, which is much more comprehensive and powerful.
npm WARN deprecated glob@7.1.6: Glob versions prior to v9 are no longer supported
npm ERR! code 1
npm ERR! path C:\Users\Admin\node_modules\java
npm ERR! command failed
npm ERR! command C:\Windows\system32\cmd.exe /d /s /c node-gyp rebuild
npm ERR! gyp info it worked if it ends with ok
npm ERR! gyp info using node-gyp@9.4.0
npm ERR! gyp info using node@18.18.1 | win32 | x64
npm ERR! gyp info find Python using Python version 3.14.2 found at "C:\Python314\python.exe"
npm ERR! gyp info find VS using VS2019 (16.11.36631.11) found at:
npm ERR! gyp info find VS "C:\Program Files (x86)\Microsoft Visual Studio\2019\Community"
npm ERR! gyp info find VS run with --verbose for detailed information
npm ERR! gyp info spawn C:\Python314\python.exe
npm ERR! gyp info spawn args [
npm ERR! gyp info spawn args 'C:\\Program Files\\nodejs\\node_modules\\npm\\node_modules\\node-gyp\\gyp\\gyp_main.py',
npm ERR! gyp info spawn args 'binding.gyp',
npm ERR! gyp info spawn args '-f',
npm ERR! gyp info spawn args 'msvs',
npm ERR! gyp info spawn args '-I',
npm ERR! gyp info spawn args 'C:\\Users\\Admin\\node_modules\\java\\build\\config.gypi',
npm ERR! gyp info spawn args '-I',
npm ERR! gyp info spawn args 'C:\\Program Files\\nodejs\\node_modules\\npm\\node_modules\\node-gyp\\addon.gypi',
npm ERR! gyp info spawn args '-I',
npm ERR! gyp info spawn args 'C:\\Users\\Admin\\AppData\\Local\\node-gyp\\Cache\\18.18.1\\include\\node\\common.gypi',
npm ERR! gyp info spawn args '-Dlibrary=shared_library',
npm ERR! gyp info spawn args '-Dvisibility=default',
npm ERR! gyp info spawn args '-Dnode_root_dir=C:\\Users\\Admin\\AppData\\Local\\node-gyp\\Cache\\18.18.1',
npm ERR! gyp info spawn args '-Dnode_gyp_dir=C:\\Program Files\\nodejs\\node_modules\\npm\\node_modules\\node-gyp',
npm ERR! gyp info spawn args '-Dnode_lib_file=C:\\\\Users\\\\Admin\\\\AppData\\\\Local\\\\node-gyp\\\\Cache\\\\18.18.1\\\\<(target_arch)\\\\node.lib',
npm ERR! gyp info spawn args '-Dmodule_root_dir=C:\\Users\\Admin\\node_modules\\java',
npm ERR! gyp info spawn args '-Dnode_engine=v8',
npm ERR! gyp info spawn args '--depth=.',
npm ERR! gyp info spawn args '--no-parallel',
npm ERR! gyp info spawn args '--generator-output',
npm ERR! gyp info spawn args 'C:\\Users\\Admin\\node_modules\\java\\build',
npm ERR! gyp info spawn args '-Goutput_dir=.'
npm ERR! gyp info spawn args ]
npm ERR! Traceback (most recent call last):
npm ERR! File "C:\Program Files\nodejs\node_modules\npm\node_modules\node-gyp\gyp\gyp_main.py", line 42, in <module>
npm ERR! import gyp # noqa: E402
npm ERR! ^^^^^^^^^^
npm ERR! File "C:\Program Files\nodejs\node_modules\npm\node_modules\node-gyp\gyp\pylib\gyp\ __init__.py", line 9, in <module>
npm ERR! import gyp.input
npm ERR! File "C:\Program Files\nodejs\node_modules\npm\node_modules\node-gyp\gyp\pylib\gyp\input.py", line 19, in <module>
npm ERR! from distutils.version import StrictVersion
npm ERR! ModuleNotFoundError: No module named 'distutils'
npm ERR! gyp ERR! configure error
npm ERR! gyp ERR! stack Error: `gyp` failed with exit code: 1
npm ERR! gyp ERR! stack at ChildProcess.onCpExit (C:\Program Files\nodejs\node_modules\npm\node_modules\node-gyp\lib\configure.js:325:16)
npm ERR! gyp ERR! stack at ChildProcess.emit (node:events:517:28)
npm ERR! gyp ERR! stack at ChildProcess._handle.onexit (node:internal/child_process:292:12)
npm ERR! gyp ERR! System Windows_NT 10.0.22621
npm ERR! gyp ERR! command "C:\\Program Files\\nodejs\\node.exe" "C:\\Program Files\\nodejs\\node_modules\\npm\\node_modules\\node-gyp\\bin\\node-gyp.js" "rebuild"
npm ERR! gyp ERR! cwd C:\Users\Admin\node_modules\java
npm ERR! gyp ERR! node -v v18.18.1
npm ERR! gyp ERR! node-gyp -v v9.4.0
npm ERR! gyp ERR! not ok

npm ERR! A complete log of this run can be found in: C:\Users\Admin\AppData\Local\npm-cache\_logs\2025-12-31T15_39_08_084Z-debug-0.log

```

any idea for this issue, or any other way to connect oracle 9i with jdbc connection?

---

<div class="post-metadata">

**Author:** ![omrid](https://avatars.discourse-cdn.com/v4/letter/o/77aa72/32.png) [@omrid](https://discourse.nodered.org/u/omrid)\
**Post date:** [31 December 2025 15:55 UTC](https://discourse.nodered.org/t/need-to-connect-with-oracle-9i/100058/2 "2025-12-31T15:55:27Z")

</div>

Did you try `node-red-contrib-oracledb-mod` (which is what I use) or `node-red-oracle`?

---

<div class="post-metadata">

**Author:** ![redodistira](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/redodistira/32/75525_2.png) [@redodistira](https://discourse.nodered.org/u/redodistira)\
**Post date:** [31 December 2025 16:26 UTC](https://discourse.nodered.org/t/need-to-connect-with-oracle-9i/100058/3 "2025-12-31T16:26:04Z")

</div>

> [@omrid](#):
>
> node-red-contrib-oracledb-mod

not yet try this tools, but already tried to used node-red-contrib-oracle with oracle instant client version 10 but not succeded. I was success tried to connect it with dbviewer software and see the connection is using like below

```auto
"jdbc:oracle:thin:@localhost:1526:xe"

```

so that why i suggest to connect with oracle 9i is using jdbc connection.

---

<div class="post-metadata">

**Author:** ![omrid](https://avatars.discourse-cdn.com/v4/letter/o/77aa72/32.png) [@omrid](https://discourse.nodered.org/u/omrid)\
**Post date:** [1 January 2026 00:17 UTC](https://discourse.nodered.org/t/need-to-connect-with-oracle-9i/100058/4 "2026-01-01T00:17:20Z")

</div>

Without looking too deep, it looks as if there are dependency issues with this node, which has last been updated 4.5 years ago and requires java & python.

I would try the other node I suggested you, though I have not tried it with Oracle 9

---

<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:** [1 April 2026 00:17 UTC](https://discourse.nodered.org/t/need-to-connect-with-oracle-9i/100058/5 "2026-04-01T00:17:47Z")

</div>

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