Archive for May 4th, 2008

Installing Oracle Instant Client for Intel Mac(leopard)

Sunday, May 4th, 2008

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’

  • change to ‘-arch i386′

14.Go to directory where you extracted ruby-oci8 source
15.Execute ruby-oci8 standard installation sequence:

  • ruby setup.rb config
  • make
  • sudo make install

16.Change back file ‘/usr/lib/ruby/1.8/universal-darwin9.0/rbconfig.rb’

  • change to ‘-arch ppc -arch i386′

17.Done. try connect to your oracle database

Popularity: 52% [?]

Posted in Mac, Ruby On Rails | No Comments »

Lost Car

Sunday, May 4th, 2008

Just help my friend…

Plat Number: WNH 6209
Type / Color: Proton Wira SE (Hitam)

When: 3 May 2008 (antara 12:00am - 8:30am)
Location: Blok Dahlia, Seksyen 8, Kota Damansara

If found this car, please contact (019)2605758 or report to nearest police station.

Popularity: 22% [?]

Posted in Other | No Comments »