Install Oracle Instant Client 11.2 on Mac OS X
Jump to navigation
Jump to search
- 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 them. They will be automatically unzipped to the same folder instantclient_11_2.
$ unzip instantclient-basic-macos.x64-11.2.0.3.0.zip $ unzip instantclient-sqlplus-macos.x64-11.2.0.3.0
- Update the user's profile.
# SQL Plus Instant Client 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
- Copy the tnsnames.ora to a specified local under TNS_ADMIN.
- Optionally, update the gloing.sql.
- Validate
ichamma1$ sqlplus ittichai@ora11gr2l 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>