Oracle Instant Client For Mac

Oracle Instant Client is free, easy to install client software for connecting to Oracle databases. It's available on a variety of platforms (Windows, Mac, Solaris, Linux, AIX, and more). It consists of four different component: basic (or basic-lite), JDBC, SQLPlus and SDK. How to install Oracle Instant Client Version 12.1.0.2 (64-bit) on a Mac (OS X 10.11.5) I have downloaded version 12.1.0.2 (64-bit) version and unzipped the file.

A tap of Mac Homebrew formulas for Oracle Instant Client and relateddownloads.

Due to difficulties downloading the files from Instant Client Downloads pagethe process can not be automated. However, if the files are downloaded manuallyand put in the cache then Homebrew can do the rest. You will need at least theinstantclient-basic file downloaded to $HOME/Library/Caches/Homebrew andthen any additional files such as sqlplus related ones.

Usage

Where <formula> is one of the formulas listed in the Formula/ directory. Forexample instantclient-sqlplus would require

You could also tap the repository before installing. This is equivalent to thecalls above:

Installing libraries which depend on Instant Client Basic Lite

When installing libraries which depend on Basic Lite you might need to specifythe DYLD_LIBRARY_PATH environment variable. E.g. in order to installruby-oci8older than 2.2.0 you will need to execute

Mac

You can also set DYLD_LIBRARY_PATH globally but this isdiscouraged and is known tobreak things.

Homebrew Instant Client is licensed under the MIT License (see LICENSE).

Active3 years ago

I have both a PC and Mac environment setup to connect to the same Oracle server. Both are using Oracle instant client 11.2.0.4 and are on the same network. Both machines are similarly configured (e.g., 16GB, flash drive, network connections, etc.).

When I try to execute a select from a relatively small table using SQLPlus, it takes ~2ms on my PC while it takes over 2 seconds on my Mac. I've attempted to dig into the differences using the Oracle trace files and other tools, but have not found anything that I am doing incorrectly.

Google searches have not yielded any helpful results. Is this just a dead end for me?

Burgi
4,53810 gold badges29 silver badges45 bronze badges
KevinKevin

1 Answer

This was a problem with the network connection. Although I thought I had validated my Ethernet network connection was live and valid, the communication was preferring the wireless connection. Once I resolved this problem, I received results comparable to the PC environment.

Oracle Instant Client For Microsoft Windows

KevinKevin
Oracle instant client install

Not the answer you're looking for? Browse other questions tagged networkingmacosperformancedatabase or ask your own question.