Unlike the other connectors and as of this writing, the Oracle bindings for Node.js, oracledb, do not include the necessary Oracle Client libraries and users are required to create an account on Oracle before downloading them.
Although the installation procedure is very well documented here, see below a quick guide for Windows, Mac and Ubuntu.
(instructions taken from oracledb)
- Download the free 64-bit Instant Client Basic ZIP file from Oracle Technology Network.
- Extract
instantclient-basic-windows.x64-12.2.0.1.0.zipto a folder, such asC:\oracle\instantclient_12_2. - Add this folder to
PATH. For example on Windows 7, updatePATHinControl Panel -> System -> Advanced System Settings -> Advanced -> Environment Variables -> System variables -> PATHand add your path, such asC:\oracle\instantclient_12_2. - Download and install the correct Visual Studio Redistributable from Microsoft. Instant Client 12.2 requires the Visual Studio 2013 redistributable.
(instructions taken from oracledb)
Download the free Basic 64-bit ZIP from Oracle Technology Network and unzip it, for example:
mkdir -p /opt/oracle
unzip instantclient-basic-macos.x64-12.2.0.1.0.zip
Create a symbolic link for the 'client shared library' in the user default library path such as in ~/lib or /usr/local/lib. For example:
mkdir ~/lib
ln -s instantclient_12_2/libclntsh.dylib.12.1 ~/lib/
Alternatively, copy the required OCI libraries, for example:
mkdir ~/lib
cp instantclient_12_2/{libclntsh.dylib.12.1,libclntshcore.dylib.12.1,libons.dylib,libnnz12.dylib,libociei.dylib} ~/lib/
- Install requirements:
sudo apt-get -qq update && sudo apt-get --no-install-recommends -qq install alien bc libaio1 - Create an account on Oracle
- Download the Oracle Instant Client from here
- Unzip
rpmpackage:unzip oracle-xe-11.2.0-1.0.x86_64.rpm.zip - Convert
rpmpackage intodeb:alien oracle-xe-11.2.0-1.0.x86_64.rpm - Install
debpackage:sudo dpkg -i oracle-instantclient12.2-basiclite_12.2.0.1.0-2_amd64.deb