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.

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
 * Set the environment variables in the ~.bash_profile as follows:
 * 1) SQL Plus Instant Client


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

sqlplus username@SID sqlplus username@host:port/SID
 * Validate by:

Related post:
 * Install_Oracle_Instant_Client_11.2_on_Mac_OS_X
 * Configure_rlwrap