Install Oracle Instant Client 10.2 on Mac OS X

From Ittichai Chammavanijakul's Wiki
Revision as of 15:27, 16 May 2012 by Ittichai (talk | contribs) (Created page with "== 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...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

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:

  • Configure_rlwrap
Retrieved from "https://ittichaicham.com/wiki/index.php?title=Install_Oracle_Instant_Client_10.2_on_Mac_OS_X&oldid=734"