# Node-red-contrib-oracledb cannot be installed

**URL:** https://discourse.nodered.org/t/node-red-contrib-oracledb-cannot-be-installed/21477
**Category:** General
**Created:** [10 February 2020 07:59 UTC](https://discourse.nodered.org/t/node-red-contrib-oracledb-cannot-be-installed/21477 "2020-02-10T07:59:12Z")
**Posts on this page:** 6
**Page:** 1

<div class="post-metadata">

### Author: ![mhechthz](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/mhechthz/32/20144_2.png) [@mhechthz](https://discourse.nodered.org/u/mhechthz)
#### Post date: [10 February 2020 07:59 UTC](https://discourse.nodered.org/t/node-red-contrib-oracledb-cannot-be-installed/21477/1 "2020-02-10T07:59:12Z")

</div>

Hi,

I try to install oracledb via:

npm install node-red-contrib-oracledb

But get the appended error file. I din't find any helpful solution in the web.

What can I do. (Win 7 System)

Sorry, I'm not allowed to upload the logfile, so I write it here (furthermore \*.log files cannot be uploaded?!):

0 info it worked if it ends with ok  
1 verbose cli [  
1 verbose cli 'D:\bin\node-red\node.exe',  
1 verbose cli 'D:\bin\node-red\node\_modules\npm\bin\npm-cli.js',  
1 verbose cli 'install',  
1 verbose cli 'node-red-contrib-oracledb'  
1 verbose cli ]  
2 info using npm@6.13.4  
3 info using node@v12.14.1  
4 verbose npm-session 6374790d2eeb0222  
5 silly install loadCurrentTree  
6 silly install readGlobalPackageData  
7 http fetch GET 304 [https://registry.npmjs.org/node-red-contrib-oracledb](https://registry.npmjs.org/node-red-contrib-oracledb) 288ms (from cache)  
8 silly pacote tag manifest for node-red-contrib-oracledb@latest fetched in 314ms  
9 timing stage:loadCurrentTree Completed in 340ms  
10 silly install loadIdealTree  
11 silly install cloneCurrentTreeToIdealTree  
12 timing stage:loadIdealTree:cloneCurrentTree Completed in 1ms  
13 silly install loadShrinkwrap  
14 timing stage:loadIdealTree:loadShrinkwrap Completed in 6ms  
15 silly install loadAllDepsIntoIdealTree  
16 silly resolveWithNewModule node-red-contrib-oracledb@0.5.1 checking installable status  
17 http fetch GET 304 https\_://registry.npmjs.org/oracledb 96ms (from cache)  
18 silly pacote range manifest for oracledb@^1.9.3 fetched in 100ms  
19 warn deprecated oracledb@1.13.1: Update to node-oracledb 4  
20 silly resolveWithNewModule oracledb@1.13.1 checking installable status  
21 http fetch GET 304 https\_://registry.npmjs.org/object-resolve-path 108ms (from cache)  
22 silly pacote range manifest for object-resolve-path@^1.1.0 fetched in 111ms  
23 silly resolveWithNewModule object-resolve-path@1.1.1 checking installable status  
24 http fetch GET 304 https\_://registry.npmjs.org/nan 105ms (from cache)  
25 silly pacote range manifest for nan@~2.5.0 fetched in 112ms  
26 silly resolveWithNewModule nan@2.5.1 checking installable status  
27 timing stage:loadIdealTree:loadAllDepsIntoIdealTree Completed in 235ms  
28 timing stage:loadIdealTree Completed in 246ms  
29 silly currentTree node-red  
30 silly idealTree node-red  
30 silly idealTree `-- node-red-contrib-oracledb@0.5.1 30 silly idealTree +-- nan@2.5.1 30 silly idealTree +-- object-resolve-path@1.1.1 30 silly idealTree `-- oracledb@1.13.1  
31 silly install generateActionsToTake  
32 timing stage:generateActionsToTake Completed in 10ms  
33 silly diffTrees action count 4  
34 silly diffTrees add nan@2.5.1  
35 silly diffTrees add object-resolve-path@1.1.1  
36 silly diffTrees add oracledb@1.13.1  
37 silly diffTrees add node-red-contrib-oracledb@0.5.1  
38 silly decomposeActions action count 32  
39 silly decomposeActions fetch nan@2.5.1  
40 silly decomposeActions extract nan@2.5.1  
41 silly decomposeActions preinstall nan@2.5.1  
42 silly decomposeActions build nan@2.5.1  
43 silly decomposeActions install nan@2.5.1  
44 silly decomposeActions postinstall nan@2.5.1  
45 silly decomposeActions finalize nan@2.5.1  
46 silly decomposeActions refresh-package-json nan@2.5.1  
47 silly decomposeActions fetch object-resolve-path@1.1.1  
48 silly decomposeActions extract object-resolve-path@1.1.1  
49 silly decomposeActions preinstall object-resolve-path@1.1.1  
50 silly decomposeActions build object-resolve-path@1.1.1  
51 silly decomposeActions install object-resolve-path@1.1.1  
52 silly decomposeActions postinstall object-resolve-path@1.1.1  
53 silly decomposeActions finalize object-resolve-path@1.1.1  
54 silly decomposeActions refresh-package-json object-resolve-path@1.1.1  
55 silly decomposeActions fetch oracledb@1.13.1  
56 silly decomposeActions extract oracledb@1.13.1  
57 silly decomposeActions preinstall oracledb@1.13.1  
58 silly decomposeActions build oracledb@1.13.1  
59 silly decomposeActions install oracledb@1.13.1  
60 silly decomposeActions postinstall oracledb@1.13.1  
61 silly decomposeActions finalize oracledb@1.13.1  
62 silly decomposeActions refresh-package-json oracledb@1.13.1  
63 silly decomposeActions fetch node-red-contrib-oracledb@0.5.1  
64 silly decomposeActions extract node-red-contrib-oracledb@0.5.1  
65 silly decomposeActions preinstall node-red-contrib-oracledb@0.5.1  
66 silly decomposeActions build node-red-contrib-oracledb@0.5.1  
67 silly decomposeActions install node-red-contrib-oracledb@0.5.1  
68 silly decomposeActions postinstall node-red-contrib-oracledb@0.5.1  
69 silly decomposeActions finalize node-red-contrib-oracledb@0.5.1  
70 silly decomposeActions refresh-package-json node-red-contrib-oracledb@0.5.1  
71 silly install executeActions  
72 silly doSerial global-install 32  
73 verbose correctMkdir C:\Users...\AppData\Roaming\npm-cache\_locks correctMkdir not in flight; initializing  
74 verbose makeCacheDir UID & GID are irrelevant on win32  
75 verbose lock using C:\Users...\AppData\Roaming\npm-cache\_locks\staging-96f55fe515a345de.lock for D:\bin\node-red\node\_modules.staging  
76 silly doParallel extract 4  
77 silly extract nan@2.5.1  
78 silly extract object-resolve-path@1.1.1  
79 silly extract oracledb@1.13.1  
80 silly extract node-red-contrib-oracledb@0.5.1  
81 silly tarball trying nan@~2.5.0 by hash: sha1-1bAWkSUzJql6K77p5hxV2NYDUeI=  
82 silly tarball trying oracledb@^1.9.3 by hash: sha1-kjFktcGSztoBWQ41Jou3AX4krYk=  
83 silly tarball trying object-resolve-path@^1.1.0 by hash: sha1-p/j5Poogr4DkQhe6fbVDFtnRIjI=  
84 silly tarball trying node-red-contrib-oracledb@latest by hash: sha512-qb5OScM3QntI6Zp0iMMgMkw5WNWPYKwKRHeKQFXlEynJiDQ5RzUuckUp0IbeUPDteIIuGSIOr254gi5D0P203A==  
85 silly extract object-resolve-path@^1.1.0 extracted to D:\bin\node-red\node\_modules.staging\object-resolve-path-8294f31e (83ms)  
86 silly extract nan@~2.5.0 extracted to D:\bin\node-red\node\_modules.staging\nan-12fe1b00 (123ms)  
87 silly extract node-red-contrib-oracledb@latest extracted to D:\bin\node-red\node\_modules.staging\node-red-contrib-oracledb-f4764253 (131ms)  
88 silly extract oracledb@^1.9.3 extracted to D:\bin\node-red\node\_modules.staging\oracledb-80490462 (136ms)  
89 timing action:extract Completed in 140ms  
90 silly doReverseSerial unbuild 32  
91 silly doSerial remove 32  
92 silly doSerial move 32  
93 silly doSerial finalize 32  
94 silly finalize D:\bin\node-red\node\_modules\node-red-contrib-oracledb\node\_modules\nan  
95 silly finalize D:\bin\node-red\node\_modules\node-red-contrib-oracledb\node\_modules\object-resolve-path  
96 silly finalize D:\bin\node-red\node\_modules\node-red-contrib-oracledb\node\_modules\oracledb  
97 silly finalize D:\bin\node-red\node\_modules\node-red-contrib-oracledb  
98 timing action:finalize Completed in 20ms  
99 silly doParallel refresh-package-json 4  
100 silly refresh-package-json D:\bin\node-red\node\_modules\node-red-contrib-oracledb\node\_modules\nan  
101 silly refresh-package-json D:\bin\node-red\node\_modules\node-red-contrib-oracledb\node\_modules\object-resolve-path  
102 silly refresh-package-json D:\bin\node-red\node\_modules\node-red-contrib-oracledb\node\_modules\oracledb  
103 silly refresh-package-json D:\bin\node-red\node\_modules\node-red-contrib-oracledb  
104 timing action:refresh-package-json Completed in 153ms  
105 silly doParallel preinstall 4  
106 silly preinstall nan@2.5.1  
107 info lifecycle nan@2.5.1~preinstall: nan@2.5.1  
108 silly preinstall object-resolve-path@1.1.1  
109 info lifecycle object-resolve-path@1.1.1~preinstall: object-resolve-path@1.1.1  
110 silly preinstall oracledb@1.13.1  
111 info lifecycle oracledb@1.13.1~preinstall: oracledb@1.13.1  
112 silly preinstall node-red-contrib-oracledb@0.5.1  
113 info lifecycle node-red-contrib-oracledb@0.5.1~preinstall: node-red-contrib-oracledb@0.5.1  
114 timing action:preinstall Completed in 5ms  
115 silly doSerial build 32  
116 silly build nan@2.5.1  
117 info linkStuff nan@2.5.1  
118 silly linkStuff nan@2.5.1 has D:\bin\node-red\node\_modules\node-red-contrib-oracledb\node\_modules as its parent node\_modules  
119 silly linkStuff nan@2.5.1 is part of a global install  
120 silly linkStuff nan@2.5.1 is installed into a global node\_modules  
121 silly build object-resolve-path@1.1.1  
122 info linkStuff object-resolve-path@1.1.1  
123 silly linkStuff object-resolve-path@1.1.1 has D:\bin\node-red\node\_modules\node-red-contrib-oracledb\node\_modules as its parent node\_modules  
124 silly linkStuff object-resolve-path@1.1.1 is part of a global install  
125 silly linkStuff object-resolve-path@1.1.1 is installed into a global node\_modules  
126 silly build oracledb@1.13.1  
127 info linkStuff oracledb@1.13.1  
128 silly linkStuff oracledb@1.13.1 has D:\bin\node-red\node\_modules\node-red-contrib-oracledb\node\_modules as its parent node\_modules  
129 silly linkStuff oracledb@1.13.1 is part of a global install  
130 silly linkStuff oracledb@1.13.1 is installed into a global node\_modules  
131 silly build node-red-contrib-oracledb@0.5.1  
132 info linkStuff node-red-contrib-oracledb@0.5.1  
133 silly linkStuff node-red-contrib-oracledb@0.5.1 has D:\bin\node-red\node\_modules as its parent node\_modules  
134 silly linkStuff node-red-contrib-oracledb@0.5.1 is part of a global install  
135 silly linkStuff node-red-contrib-oracledb@0.5.1 is installed into a global node\_modules  
136 silly linkStuff node-red-contrib-oracledb@0.5.1 is installed into the top-level global node\_modules  
137 timing action:build Completed in 2ms  
138 silly doSerial global-link 32  
139 silly doParallel update-linked 0  
140 silly doSerial install 32  
141 silly install nan@2.5.1  
142 info lifecycle nan@2.5.1~install: nan@2.5.1  
143 silly install object-resolve-path@1.1.1  
144 info lifecycle object-resolve-path@1.1.1~install: object-resolve-path@1.1.1  
145 silly install oracledb@1.13.1  
146 info lifecycle oracledb@1.13.1~install: oracledb@1.13.1  
147 verbose lifecycle oracledb@1.13.1~install: unsafe-perm in lifecycle true  
148 verbose lifecycle oracledb@1.13.1~install: PATH: ...  
149 verbose lifecycle oracledb@1.13.1~install: CWD: D:\bin\node-red\node\_modules\node-red-contrib-oracledb\node\_modules\oracledb  
150 silly lifecycle oracledb@1.13.1~install: Args: ['/d /s /c', 'node-gyp rebuild']  
151 silly lifecycle oracledb@1.13.1~install: Returned: code: 1 signal: null  
152 info lifecycle oracledb@1.13.1~install: Failed to exec install script  
153 timing action:install Completed in 35ms  
154 verbose unlock done using C:\Users...\AppData\Roaming\npm-cache\_locks\staging-96f55fe515a345de.lock for D:\bin\node-red\node\_modules.staging  
155 timing stage:rollbackFailedOptional Completed in 156ms  
156 timing stage:runTopLevelLifecycles Completed in 1125ms  
157 verbose stack Error: oracledb@1.13.1 install: `node-gyp rebuild`  
157 verbose stack Exit status 1  
157 verbose stack at EventEmitter. (D:\bin\node-red\node\_modules\npm\node\_modules\npm-lifecycle\index.js:332:16)  
157 verbose stack at EventEmitter.emit (events.js:223:5)  
157 verbose stack at ChildProcess. (D:\bin\node-red\node\_modules\npm\node\_modules\npm-lifecycle\lib\spawn.js:55:14)  
157 verbose stack at ChildProcess.emit (events.js:223:5)  
157 verbose stack at maybeClose (internal/child\_process.js:1021:16)  
157 verbose stack at Process.ChildProcess.\_handle.onexit (internal/child\_process.js:283:5)  
158 verbose pkgid oracledb@1.13.1  
159 verbose cwd D:\bin\node-red  
160 verbose Windows\_NT 6.1.7601  
161 verbose argv "D:\bin\node-red\node.exe" "D:\bin\node-red\node\_modules\npm\bin\npm-cli.js" "install" "node-red-contrib-oracledb"  
162 verbose node v12.14.1  
163 verbose npm v6.13.4  
164 error code ELIFECYCLE  
165 error errno 1  
166 error oracledb@1.13.1 install: `node-gyp rebuild`  
166 error Exit status 1  
167 error Failed at the oracledb@1.13.1 install script.  
167 error This is probably not a problem with npm. There is likely additional logging output above.  
168 verbose exit [1, true]

---

<div class="post-metadata">

### Author: ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)
#### Post date: [10 February 2020 09:13 UTC](https://discourse.nodered.org/t/node-red-contrib-oracledb-cannot-be-installed/21477/2 "2020-02-10T09:13:36Z")

</div>

Did you switch to your .node-red directory before running the install command?

---

<div class="post-metadata">

### Author: ![mhechthz](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/mhechthz/32/20144_2.png) [@mhechthz](https://discourse.nodered.org/u/mhechthz)
#### Post date: [10 February 2020 09:30 UTC](https://discourse.nodered.org/t/node-red-contrib-oracledb-cannot-be-installed/21477/3 "2020-02-10T09:30:56Z")

</div>

No,

I directly install from Node.js base directory where npm.exe and node.exe are (I just called the directory node-red, since I use Node.js only for node-red). From here I installed mysql, postgres, influxdb, s7 support without any problems, but oracledb and opcua fail, starting with the message (from German) "command 'node' is written wrong or could not be found ...". The PATH variable contains the local directory.

---

<div class="post-metadata">

### Author: ![dceejay](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/dceejay/32/38_2.png) [@dceejay](https://discourse.nodered.org/u/dceejay)
#### Post date: [10 February 2020 09:35 UTC](https://discourse.nodered.org/t/node-red-contrib-oracledb-cannot-be-installed/21477/4 "2020-02-10T09:35:27Z")

</div>

You need the Windows build tools installed so that node-gyp can recompile some native bindings

---

<div class="post-metadata">

### Author: ![mhechthz](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/mhechthz/32/20144_2.png) [@mhechthz](https://discourse.nodered.org/u/mhechthz)
#### Post date: [10 February 2020 09:36 UTC](https://discourse.nodered.org/t/node-red-contrib-oracledb-cannot-be-installed/21477/6 "2020-02-10T09:36:02Z")

</div>

OH NO ... SORRY!!! The PATH variable had ".;" but not the "D:\bin\node-red" entry ...

Now I get another problem with building oracledb which I have to analyze first.

opc-ua could now be installed.

---

<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: [10 April 2020 09:36 UTC](https://discourse.nodered.org/t/node-red-contrib-oracledb-cannot-be-installed/21477/7 "2020-04-10T09:36:06Z")

</div>

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