Oracle InstantClient setup

env-instantclient-osx.md

1. Download Oracle InstantClient basic, sqlplus, and SDK packages

    instantclient-basic-macos.x32-11.2.0.4.0.zip
    instantclient-sqlplus-macos.x32-11.2.0.4.0.zip
    instantclient-sdk-macos.x32-11.2.0.4.0.zip
   

2. Extract files and rename directory, if desired

    /instantclient
    |
    +-- BASIC_README
    +-- SQLPLUS_README
    +-- [...]
    |	
    +-- /sdk
    |	|
    |   +-- SDK_README
    |   [...]
   

3. Move directory somewhere

    mv instantclient /usr/local/instantclient		
   

4. Symlink dylib file

    cd /usr/local/instantclient
    ln -s libclntsh.dylib.11.1 libclntsh.dylib
   

5. Add InstantClient to $PATH, e.g. create a symlink in the user's /bin to the new location of /instantclient

    ln -s /usr/local/bin/instantclient instantclient
   

6. Configure for your application by adding a tnsnames.ora file and confirming the path to that file is available in an environment variable called TNS_ADMIN

---

tip: watch for quarantine problems with the files if you downloaded them to /Downloads

sudo xattr -r -d com.apple.quarantine instantclient

http://entropytc.com/got-com-apple-quarantine-problems/