Installing ruby-oci8 with Oracle Instant Client 11g

While trying to use ruby-oci8 and Oracle Instant Client 11g I run into problems when compiling ruby-oci8 extensions (I was following the guide at ruby-oci8 site).

The problem seems to be the Oracle Client packages (only tried with the .rpm) (tried the same with 10g and it worked fine).

Versions used:
ruby-oci8: 1.0.3
Oracle Instant Client: 11g
OS: Ubuntu 8.1

Steps:

Download .rpm packages and convert them to .deb with alien.

alien oracle-instantclient11.1-basiclite_11.1.0.7.0-2_i386.rpm
alien oracle-instantclient11.1-devel_11.1.0.7.0-2_i386.rpm

Install them:

dpkg -i oracle-instantclient11.1-basiclite_11.1.0.7.0-2_i386.dev
dpkg -i oracle-instantclient11.1-devel_11.1.0.7.0-2_i386.dev

Now we need to set LD_LIBRARY_PATH to were the libraries got installed:

dpkg -L oracle-instantclient11.1-basiclite


...
/usr/lib/oracle
/usr/lib/oracle/11.1
/usr/lib/oracle/11.1/client
/usr/lib/oracle/11.1/client/bin
/usr/lib/oracle/11.1/client/bin/adrci
/usr/lib/oracle/11.1/client/bin/genezi
/usr/lib/oracle/11.1/client/lib
/usr/lib/oracle/11.1/client/lib/ojdbc5.jar
/usr/lib/oracle/11.1/client/lib/libocijdbc11.so
/usr/lib/oracle/11.1/client/lib/libocci.so.11.1
/usr/lib/oracle/11.1/client/lib/libnnz11.so
/usr/lib/oracle/11.1/client/lib/ojdbc6.jar
/usr/lib/oracle/11.1/client/lib/libclntsh.so.11.1
/usr/lib/oracle/11.1/client/lib/libociicus.so


export LD_LIBRARY_PATH=/usr/lib/oracle/11.1/client/lib
gem install ruby-oci8

But all I got was this error:

...
error messages:
'/usr/lib/oracle/11.1/client/lib//sdk/include/oci.h' does not exist.
Install 'Instant Client SDK'.
...

Checking where the files for the devel package were installed:
dpkg -L oracle-instantclient11.1-devel
gives us this /usr/include/oracle/11.1/client. So we’ll make a link to make the compilation script happy:


mkdir /usr/lib/oracle/11.1/client/lib/sdk
ln -s /usr/include/oracle/11.1/client /usr/lib/oracle/11.1/client/lib/sdk/include

We try again:

gem install ruby-oci8
Successfully installed ruby-oci8-1.0.3
1 gem installed
Installing ri documentation for ruby-oci8-1.0.3...
Installing RDoc documentation for ruby-oci8-1.0.3...

Tags: , , , ,

Leave a comment