Install Oracle Instant Client 10.2 on Mac OS X

From Ittichai Chammavanijakul's Wiki
Jump to navigation Jump to search
  • See link below if you would like to install the instant client 11.2 instead.

Install Oracle Instant Client on Mac OS X Lion

  • 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: