Installing node-oracledb on Microsoft Windows

As well instead of each time writing "npm install --msvs_version=2015"

you can make system variable GYP_MSVS_VERSION = '2015'.

I've just installed oraclebd on Win'7 x64 with this howto. Thanks a lot @bchr02 for this!

Before installation VS2015 CE was already installed but without C++ part. So I have got same errors. Then I start VS2015 and choose New project - C++ - Add WindowsSDK 10. After installation has finished and creating GYP_MSVS_VERSION env. variable node-gyp started to compile without errors.

BTW, it said that Microsoft Visual C++ Build Tools 2015 Technical Preview could be used now instead of installing MS VisualStudio. I didn't try it yet.

This is what worked for me too......I did a default install of Community edition 2015; create project; add Visual C++

Hep me!Help me!

  njsOracle.cpp

  njsPool.cpp

  njsConnection.cpp

  njsResultSet.cpp

C:\Users\Yuan\AppData\Roaming\npm\node_modules\oracledb\src\dpi\include\dpiLob.h(34): fatal error C1083: Cannot

clude file: 'oci.h': No such file or directory (compiling source file ..\src\njs\src\njsConnection.cpp) [C:\Use

AppData\Roaming\npm\node_modules\oracledb\build\oracledb.vcxproj]

  njsMessages.cpp

C:\Users\Yuan\AppData\Roaming\npm\node_modules\oracledb\src\dpi\include\dpiLob.h(34): fatal error C1083: Cannot

clude file: 'oci.h': No such file or directory (compiling source file ..\src\njs\src\njsResultSet.cpp) [C:\User

ppData\Roaming\npm\node_modules\oracledb\build\oracledb.vcxproj]

  njsIntLob.cpp

C:\Users\Yuan\AppData\Roaming\npm\node_modules\oracledb\src\dpi\include\dpiLob.h(34): fatal error C1083: Cannot

clude file: 'oci.h': No such file or directory (compiling source file ..\src\njs\src\njsOracle.cpp) [C:\Users\Y

ata\Roaming\npm\node_modules\oracledb\build\oracledb.vcxproj]

C:\Users\Yuan\AppData\Roaming\npm\node_modules\oracledb\src\dpi\include\dpiLob.h(34): fatal error C1083: Cannot

clude file: 'oci.h': No such file or directory (compiling source file ..\src\njs\src\njsPool.cpp) [C:\Users\Yua

a\Roaming\npm\node_modules\oracledb\build\oracledb.vcxproj]

  dpiEnv.cpp

  dpiEnvImpl.cpp

C:\Users\Yuan\AppData\Roaming\npm\node_modules\oracledb\src\dpi\src\dpiEnvImpl.h(30): fatal error C1083: Cannot

clude file: 'oci.h': No such file or directory (compiling source file ..\src\dpi\src\dpiEnv.cpp) [C:\Users\Yuan

\Roaming\npm\node_modules\oracledb\build\oracledb.vcxproj]

C:\Users\Yuan\AppData\Roaming\npm\node_modules\oracledb\src\dpi\src\dpiEnvImpl.h(30): fatal error C1083: Cannot

clude file: 'oci.h': No such file or directory (compiling source file ..\src\dpi\src\dpiEnvImpl.cpp) [C:\Users\

Data\Roaming\npm\node_modules\oracledb\build\oracledb.vcxproj]

  dpiException.cpp

  dpiExceptionImpl.cpp

  dpiConnImpl.cpp

C:\Users\Yuan\AppData\Roaming\npm\node_modules\oracledb\src\dpi\src\dpiConnImpl.h(30): fatal error C1083: Canno

nclude file: 'oci.h': No such file or directory (compiling source file ..\src\dpi\src\dpiConnImpl.cpp) [C:\User

ppData\Roaming\npm\node_modules\oracledb\build\oracledb.vcxproj]

  dpiDateTimeArrayImpl.cpp

  dpiPoolImpl.cpp

C:\Users\Yuan\AppData\Roaming\npm\node_modules\oracledb\src\dpi\src\dpiEnvImpl.h(30): fatal error C1083: Cannot

clude file: 'oci.h': No such file or directory (compiling source file ..\src\dpi\src\dpiPoolImpl.cpp) [C:\Users

pData\Roaming\npm\node_modules\oracledb\build\oracledb.vcxproj]

  dpiStmtImpl.cpp

C:\Users\Yuan\AppData\Roaming\npm\node_modules\oracledb\src\dpi\src\dpiUtils.h(30): fatal error C1083: Cannot o

ude file: 'oci.h': No such file or directory (compiling source file ..\src\dpi\src\dpiDateTimeArrayImpl.cpp) [C

Yuan\AppData\Roaming\npm\node_modules\oracledb\build\oracledb.vcxproj]

  dpiUtils.cpp

C:\Users\Yuan\AppData\Roaming\npm\node_modules\oracledb\src\dpi\include\dpiLob.h(34): fatal error C1083: Cannot

clude file: 'oci.h': No such file or directory (compiling source file ..\src\njs\src\njsIntLob.cpp) [C:\Users\Y

ata\Roaming\npm\node_modules\oracledb\build\oracledb.vcxproj]

  dpiLob.cpp

C:\Users\Yuan\AppData\Roaming\npm\node_modules\oracledb\src\dpi\include\dpiStmt.h(30): fatal error C1083: Canno

nclude file: 'oci.h': No such file or directory (compiling source file ..\src\dpi\src\dpiStmtImpl.cpp) [C:\User

ppData\Roaming\npm\node_modules\oracledb\build\oracledb.vcxproj]

  dpiCommon.cpp

C:\Users\Yuan\AppData\Roaming\npm\node_modules\oracledb\src\dpi\include\dpiLob.h(34): fatal error C1083: Cannot

clude file: 'oci.h': No such file or directory (compiling source file ..\src\dpi\src\dpiLob.cpp) [C:\Users\Yuan

\Roaming\npm\node_modules\oracledb\build\oracledb.vcxproj]

  win_delay_load_hook.cc

..\src\dpi\src\dpiCommon.cpp(28): fatal error C1083: Cannot open include file: 'oci.h': No such file or directo

sers\Yuan\AppData\Roaming\npm\node_modules\oracledb\build\oracledb.vcxproj]

C:\Users\Yuan\AppData\Roaming\npm\node_modules\oracledb\src\dpi\src\dpiUtils.h(30): fatal error C1083: Cannot o

ude file: 'oci.h': No such file or directory (compiling source file ..\src\dpi\src\dpiUtils.cpp) [C:\Users\Yuan

\Roaming\npm\node_modules\oracledb\build\oracledb.vcxproj]

gyp ERR! build error

gyp ERR! stack Error: `C:\Program Files (x86)\MSBuild\14.0\bin\msbuild.exe` failed with exit code: 1

gyp ERR! stack     at ChildProcess.onExit (C:\Program Files\nodejs\node_modules\npm\node_modules\node-gyp\lib\b

76:23)

gyp ERR! stack     at emitTwo (events.js:106:13)

gyp ERR! stack     at ChildProcess.emit (events.js:194:7)

gyp ERR! stack     at Process.ChildProcess._handle.onexit (internal/child_process.js:215:12)

gyp ERR! System Windows_NT 10.0.10240

gyp ERR! command "C:\\Program Files\\nodejs\\node.exe" "C:\\Program Files\\nodejs\\node_modules\\npm\\node_modu

-gyp\\bin\\node-gyp.js" "rebuild"

gyp ERR! cwd C:\Users\Yuan\AppData\Roaming\npm\node_modules\oracledb

gyp ERR! node -v v7.7.1

gyp ERR! node-gyp -v v3.5.0

gyp ERR! not ok

npm WARN Error: EPERM: operation not permitted, rmdir 'C:\Users\Yuan\AppData\Roaming\npm\node_modules'

npm WARN  { Error: EPERM: operation not permitted, rmdir 'C:\Users\Yuan\AppData\Roaming\npm\node_modules'

npm WARN   errno: -4048,

npm WARN   code: 'EPERM',

npm WARN   syscall: 'rmdir',

npm WARN   path: 'C:\\Users\\Yuan\\AppData\\Roaming\\npm\\node_modules' }

npm ERR! Windows_NT 10.0.10240

npm ERR! argv "C:\\Program Files\\nodejs\\node.exe" "C:\\Program Files\\nodejs\\node_modules\\npm\\bin\\npm-cli

tall" "-g" "oracledb"

npm ERR! node v7.7.1

npm ERR! npm  v4.1.2

npm ERR! code ELIFECYCLE

npm ERR! [email protected] install: `node-gyp rebuild`

npm ERR! Exit status 1

npm ERR!

npm ERR! Failed at the [email protected] install script 'node-gyp rebuild'.

npm ERR! Make sure you have the latest version of node.js and npm installed.

npm ERR! If you do, this is most likely a problem with the oracledb package,

npm ERR! not with npm itself.

npm ERR! Tell the author that this fails on your system:

npm ERR!     node-gyp rebuild

npm ERR! You can get information on how to open an issue for this project with:

npm ERR!     npm bugs oracledb

npm ERR! Or if that isn't available, you can get their info via:

npm ERR!     npm owner ls oracledb

npm ERR! There is likely additional logging output above.

npm ERR! Please include the following file with any support request:

npm ERR!     C:\Users\Yuan\npm-debug.log

C:\Users\Yuan>npm install -g oracledb

> [email protected] install C:\Users\Yuan\AppData\Roaming\npm\node_modules\oracledb

> node-gyp rebuild

C:\Users\Yuan\AppData\Roaming\npm\node_modules\oracledb>if not defined npm_config_node_gyp (node "C:\Program Fi

s\node_modules\npm\bin\node-gyp-bin\\..\..\node_modules\node-gyp\bin\node-gyp.js" rebuild )  else (node "" rebu

gyp WARN install got an error, rolling back install

gyp ERR! configure error

gyp ERR! stack Error: read ECONNRESET

gyp ERR! stack     at exports._errnoException (util.js:1029:11)

gyp ERR! stack     at TLSWrap.onread (net.js:575:26)

gyp ERR! System Windows_NT 10.0.10240

gyp ERR! command "C:\\Program Files\\nodejs\\node.exe" "C:\\Program Files\\nodejs\\node_modules\\npm\\node_modu

-gyp\\bin\\node-gyp.js" "rebuild"

gyp ERR! cwd C:\Users\Yuan\AppData\Roaming\npm\node_modules\oracledb

gyp ERR! node -v v7.7.1

gyp ERR! node-gyp -v v3.5.0

gyp ERR! not ok

npm ERR! Windows_NT 10.0.10240

npm ERR! argv "C:\\Program Files\\nodejs\\node.exe" "C:\\Program Files\\nodejs\\node_modules\\npm\\bin\\npm-cli

tall" "-g" "oracledb"

npm ERR! node v7.7.1

npm ERR! npm  v4.1.2

npm ERR! code ELIFECYCLE

npm ERR! [email protected] install: `node-gyp rebuild`

npm ERR! Exit status 1

npm ERR!

npm ERR! Failed at the [email protected] install script 'node-gyp rebuild'.

npm ERR! Make sure you have the latest version of node.js and npm installed.

npm ERR! If you do, this is most likely a problem with the oracledb package,

npm ERR! not with npm itself.

npm ERR! Tell the author that this fails on your system:

npm ERR!     node-gyp rebuild

npm ERR! You can get information on how to open an issue for this project with:

npm ERR!     npm bugs oracledb

npm ERR! Or if that isn't available, you can get their info via:

npm ERR!     npm owner ls oracledb

npm ERR! There is likely additional logging output above.

npm ERR! Please include the following file with any support request:

npm ERR!     C:\Users\Yuan\npm-debug.log

I follow all steps but when execute node app.js

ORA-12541: TNS:no listener

Help me!

Hi,

I am able to install and configure everything. But when I run above example I get the error

ORA-12541: TNS:no listener

Is there anything I am missing? Do I need to start oracle server? I dont see any instruction here?