Install Oracle Instant Client 11.2 on Mac OS X


 * Download the instantclient-basic-macos.x64-11.2.0.3.0.zip file from http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html > Instant Client for Mac OS X (Intel x86) (32-bit and 64-bit).
 * Also download the Instant Client Package - SQL*Plus: Additional libraries and executable for running SQL*Plus with Instant Client.

$ unzip instantclient-basic-macos.x64-11.2.0.3.0.zip $ unzip instantclient-sqlplus-macos.x64-11.2.0.3.0
 * Unzip them. They will be automatically unzipped to the same folder instantclient_11_2.

export INSTANT_CLIENT_PATH=/Users/ichamma1/Documents/instantclient_11_2 export DYLD_LIBRARY_PATH=$INSTANT_CLIENT_PATH export TNS_ADMIN=$INSTANT_CLIENT_PATH export PATH=$PATH:$INSTANT_CLIENT_PATH
 * Update the user's profile.
 * 1) SQL Plus Instant Client


 * Copy the tnsnames.ora to a specified local under TNS_ADMIN.


 * Optionally, update the gloing.sql.

ichamma1$ sqlplus ittichai@ora11gr2l
 * Validate

SQL*Plus: Release 11.2.0.3.0 Production on Sat Feb 2 16:23:51 2013

Copyright (c) 1982, 2012, Oracle. All rights reserved.

Enter password:

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options

16:23:53 ITTICHAI @ora11gr2l>


 * Configure_rlwrap
 * Install_Oracle_Instant_Client_10.2_on_Mac_OS_X