Install Oracle instant client and sqlplus using Homebrew

After upgrading to El Capitan I was no longer able to run sqlplus from the command line. Apparently the upgrade moved some stuff to a Migration directory.

$ locate sqlplus
/Library/SystemMigration/History/Migration-B5D75827–387E-42F7–8478–560D7C14C848/QuarantineRoot/bin/oracle/instantclient_11_2/sqlplus

As I couldn’t be bothered to figure out how to reverse this I just installed Oracle instant client and sqlplus again.

Here’s how to do it:

(Update 10/06/2020: Step 1 is no longer necessary, just run the brew commands!)

1. Download the two files below from http://www.oracle.com/technetwork/topics/intel-macsoft-096467.html. This is necessary because of Oracle licenses.

instantclient-basic-macos.x64–11.2.0.4.0.zip
instantclient-sqlplus-macos.x64–11.2.0.4.0.zip

Put the files in ~/Library/Caches/Homebrew

2. Next run the following commands

$ brew tap InstantClientTap/instantclient
$ brew install instantclient-basic
$ brew install instantclient-sqlplus

3. All done :)

Originally published at vanwollingen.nl.