Installing Oracle Instant Client on Mac OS X
Getting right down to business...
- Download the Instant Client Packages (4 files)
- Unzip the files into
instantclient10_1CODE:-
unzip instantclient-basic-macosx-10.1.0.3.zip
-
unzip instantclient-sqlplus-macosx-10.1.0.3.zip
-
unzip instantclient-sdk-macosx-10.1.0.3.zip
-
unzip instantclient-jdbc-macosx-10.1.0.3.zip
-
- Create two symbolic links for the files that have the version appended. This is so the Ruby
OCI8driver can find what it’s looking for.CODE:-
cd instantclient10_1
-
ln -s libclntsh.dylib.10.1 libclntsh.dylib
-
ln -s libocci.dylib.10.1 libocci.dylib
-
cd ..
-
- Create directory
/usr/local/oracleand then copyinstantclient10_1into itCODE:-
sudo mkdir /usr/local/oracle
-
sudo mv instantclient10_1 /usr/local/oracle/instantclient10_1
-
- Open the system
/etc/profile
sudo pico /etc/profile - Add these lines to
/etc/profileCODE:-
DYLD_LIBRARY_PATH="/usr/local/oracle/instantclient10_1"
-
export DYLD_LIBRARY_PATH
-
SQLPATH="/usr/local/oracle/instantclient10_1"
-
export SQLPATH
Add
/usr/local/oracle/instantclient10_1to yourPATHwhile you have/etc/profileopen. Then save it. -
- Reload your profile
source /etc/profile
- Test it out with the
sqlpluscommand line app.CODE:-
sqlplus [username][/password]@//[hostname][:port][/database]
-
If you can connect with that, then you’re good to go.

Thanks! Now all we need is Toad for Mac Os X… :-)
BOK
9 Aug 07 at 3:46 pm
Sorry, i did what you said and when trying to connect to my db i got the error message:
dyld: Library not loaded: /b/729/sqlplus/lib/libsqlplus.dylib
Referenced from: /usr/local/oracle/instantclient10_1/sqlplus
Reason: image not found
Trace/BPT trap
any ideas?
Peter
8 Nov 07 at 12:20 pm
I’m guessing it’s an environment issue. Check out the following for more info:
http://www.google.com/search?q=dyld%3A+Library+not+loaded%3A+%2Fb%2F729%2Fsqlplus%2Flib%2Flibsqlplus.dylib&sourceid=navclient-ff&ie=UTF-8&rlz=1B3GGGL_enUS219US220
Shane
10 Nov 07 at 9:17 am
Thank you! Great instructions - everything worked perfectly.
Tom C
21 Jan 08 at 2:54 pm