Install

• Install Instant Client Package - Basic Lite

• Install Instant Client Package - SDK

• Finally install using Node Package Manager (npm):

  npm install oracle

Develop

Install Oracle/Oracle Express

• Download Oracle Express 10g
• Download Instant Client
• Instant Client Package - Basic Lite
• Instant Client Package - SQL*Plus
• Instant Client Package - SDK
• Install Oracle Express (Ubuntu)

sudo dpkg -i oracle-xe_10.2.0.1-1.0_i386.deb
sudo apt-get install alien
sudo alien oracle-instantclient-basiclite-10.2.0.5-1.i386.rpm 
sudo alien oracle-instantclient-devel-10.2.0.5-1.i386.rpm
sudo alien oracle-instantclient-sqlplus-10.2.0.5-1.i386.rpm
sudo dpkg -i oracle-instantclient-basiclite_10.2.0.5-1.i386.deb
sudo dpkg -i oracle-instantclient-devel_10.2.0.5-1.i386.deb
sudo dpkg -i oracle-instantclient-sqlplus_10.2.0.5-1.i386.deb
sudo /etc/init.d/oracle-xe configure

• Open http://localhost:9999/apex/ change 9999 to the port you configured. Log-in with "sys" and the password.
• Create a user called "test" with password "test" and give all accesses.

sudo vi /etc/ld.so.conf.d/oracle.conf -- add this line /usr/lib/oracle/10.2.0.5/client/lib/
sudo ldconfig

export ORACLE_SID=test
export ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
export OCI_INCLUDE_DIR=/usr/include/oracle/10.2.0.5/client/
export OCI_LIB_DIR=/usr/lib/oracle/10.2.0.5/client/lib/
sqlplus test@XE

Build

node-waf configure
node-waf build
nodeunit tests/*