Installing Oracle Instant Client for Intel Mac(leopard)

Custom Search

May 4, 2008 – 5:58 am

This is i found out how to connect ruby to oracle database

1.Download “Instant Client Package - Basic”
2.Download “Instant Client Package - SDK”
3.Unzip all instant client to ‘/usr/local/oracle/instantclient_10_2′ using sudo function

sudo unzip instantclient-basic-macosx-10.2.0.4.0.zip /usr/local/oracle
sudo unzip instantclient-sdk-macosx-10.2.0.4.0.zip /usr/local/oracle

4.Go to ‘/usr/local/oracle/instantclient_10_2′
5.Make symbolic links for dynamic libraries.

sudo ln -s libclntsh.dylib.10.1 libclntsh.dylib
sudo ln -s libocci.dylib.10.1 libocci.dylib

6.Create ‘/usr/local/oracle/network/admin’
7.Put your tnsnames.ora inside ‘/usr/local/oracle/network/admin’.

sudo mkdir /usr/local/oracle/network/admin

8.Setup enviroment in your .bash_profile script. In your home folder.
9.Then added :

export DYLD_LIBRARY_PATH=”/usr/local/oracle/instantclient_10_2″
export SQLPATH=”/usr/local/oracle/instantclient_10_2″
export TNS_ADMIN=”/usr/local/oracle/network/admin”
export NLS_LANG=”AMERICAN_AMERICA.UTF8″
export PATH=$PATH:$DYLD_LIBRARY_PATH

10.Relaunch Terminal application
11.Specify database connection in tnsnames.ora
12.Download ruby-oci8 and extract the file. Extract to any location you like.
13.Edit line 17 in ‘/usr/lib/ruby/1.8/universal-darwin9.0/rbconfig.rb’