Install Oracle Instant Client 10.2 on Mac OS X

• See link below if you would like to install the instant client 11.2 instead.

Install Oracle Instant Client on Mac OS X Lion

• Download the installation files from http://www.oracle.com/technetwork/topics/intel-macsoft-096467.html

• Unfortunately at this moment, the 64-bit version does not work. When starting the SQL Plus, the "Segmentation fault: 11" will be displayed.

• Download the 32-bit version instead. You will need the Instant Client Package: Basic and SQL Plus.
  • instantclient-basic-10.2.0.4.0-macosx-x86.zip
  • instantclient-sqlplus-10.2.0.4.0-macosx-x86.zip

• Unzip both files into a folder.

• Set the environment variables in the ~.bash_profile as follows:

# SQL Plus Instant Client
export INSTANT_CLIENT_PATH=/Users/ichamma1/Documents/Oracle_instantclient
export DYLD_LIBRARY_PATH=$INSTANT_CLIENT_PATH
export TNS_ADMIN=$INSTANT_CLIENT_PATH
export PATH=$PATH:$INSTANT_CLIENT_PATH

• The TNS_ADMIN is where the tnsnames.ora file will be placed. Note that it can be the same as the Instant Client files

• Validate by:

sqlplus username@SID
sqlplus username@host:port/SID

Related post:

• Install_Oracle_Instant_Client_11.2_on_Mac_OS_X
• Configure_rlwrap