Oracle with Ruby 1.9.2 / rvm

Thanks mikecomstock for pointing me to this ruby oracle tut

How To Install ruby-oci8 on Ubuntu Server 64bits

I’m running rvm so a couple things to note

remove sudo before building the ruby-oci8 gem

$ sudo env LD_LIBRARY_PATH=/opt/oracle/instantclient_11_2 /usr/bin/gem install ruby-oci8

just run

$ env LD_LIBRARY_PATH=/opt/oracle/instantclient_11_2 /usr/bin/gem install ruby-oci8

with rvm, you’ll need to specify your env before executing the sql.rb script from the tutorial

$ env LD_LIBRARY_PATH=/opt/oracle/instantclient_11_2 ruby sql.rb

Useful link: http://www.pixellatedvisions.com/2009/03/25/rails-on-oracle-part-1-installing-the-oracle-instant-client-on-mac-os-x