instantclienttap / homebrew-instantclient

A tap of Mac Homebrew formulas for Oracle Instant Client.

Homebrew Instant Client

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

Usage

$ brew install InstantClientTap/instantclient/<formula>

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

$ brew install InstantClientTap/instantclient/instantclient-sqlplus

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

$ brew tap InstantClientTap/instantclient
$ brew install <formula>

Installing libraries which depend on Instant Client Basic Lite

When installing libraries which depend on Basic Lite you might need to specify the DYLD_LIBRARY_PATH environment variable. E.g. in order to install ruby-oci8 older than 2.2.0 you will need to execute

$ DYLD_LIBRARY_PATH=$(brew --prefix)/lib gem install ruby-oci8

You can also set DYLD_LIBRARY_PATH globally but this is discouraged and is known to break things.

License

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

homebrew-instantclient's Issues

When installing php --with-pdo-oci: oci.h file not found

Hello!

When trying to install php --with-pdo-oci we get the following error:

ext/pdo_oci/php_pdo_oci_int.h:21:10: fatal error: 'oci.h' file not found

I guess this is due when we install instantclient-sdk, the installation script does not copy *.h files into /usr/local/include/ folder. Shouldn't it do that?

Support for Oracle 18.1.0.0.0

Oracle has released 18.1.0.0.0 and the tap doesn't work which this version.

Formula for tools package

I mean http://download.oracle.com/otn/mac/instantclient/122010/instantclient-tools-macos.x64-12.2.0.1.0-2.zip .

It's useful at least for the command sqlldr which allows to load files into the db.

Installing ROracle

Hello,
thank you for writing these recipes.

The installation of the InstantClient worked correctly, but now I would like to install ROracle (R package for accessing Oracle using instanclient), but I am not sure how to set up the flags.

This are the install instructions: https://cran.r-project.org/web/packages/ROracle/INSTALL

I've tried with all the combinations of LD_LIBRARY_PATH (e.g. adding .linuxbrew/Cellar/instantclient-sdk/12.1.0.2.0/lib/), but none of them worked. I always get the error:

$ R CMD INSTALL ROracle_1.1-1.tar.gz
normal, x[x<0], x[x>=0], 19/01/2038 03:14:07,
"string", NA/NaN/NULL, FALSE, TRUE, Inf, stderror, warn, error.
* installing to library ‘/home/user/linuxbrew/lib/R/3.3/site-library’
* installing *source* package ‘ROracle’ ...
** package ‘ROracle’ successfully unpacked and MD5 sums checked
configure: error: OCI headers not found
ERROR: configuration failed for package ‘ROracle’
* removing ‘/home/user/linuxbrew/lib/R/3.3/site-library/ROracle’

After install I can't run the expdp tool

I get error

dyld: Library not loaded: @rpath/libclntsh.dylib.19.1
Referenced from: /usr/local/bin/expdp
Reason: image not found
[1] 61611 abort expdp

sqlplus returns Message file sp1<lang>.msb not found

Hi , I've installed sqlplus and basic. Everything looks to be installed ok. however, when I run sqlplus I get the following error: 

OS: Mac OS X: Mojave

➜ ~ sqlplus
Error 6 initializing SQL*Plus
SP2–0667: Message file sp1<lang>.msb not found
SP2–0750: You may need to set ORACLE_HOME to your Oracle software directory

I've ran export ORACLE_HOME=/usr/local/Cellar/instantclient-basic/12.2.0.1.0–2/lib & export ORACLE_HOME=/usr/local/Cellar/instantclient-basic/12.2.0.1.0–2/ with the same issue.

Any ideas?

brew 1.7.2 breaks `CacheWoDownloadStrategy`

Brew recently updated their CurlDownloadStrategy class that doesn't use a @tarball_path instance var.

In the meantime I duplicated the files to to match the new caching file name expectation.

Example: cp -a instantclient-sdk-macos.x64-12.2.0.1.0-2.zip instantclient-sdk--12.2.0.1.0-2.zip

Support for Oracle 19.3.0.0.0

Oracle has bumped their instantclient version to 19.3.0.0.0: https://www.oracle.com/database/technologies/instant-client/macos-intel-x86-downloads.html

Tap installs x86 on ARM

I just discovered that the code has fix architecture: https://github.com/InstantClientTap/homebrew-instantclient/blob/master/Formula/instantclient-basic.rb#L6

There is official ARM client downloads also https://www.oracle.com/database/technologies/instant-client/linux-arm-aarch64-downloads.html

Feature Request: JDBC Supplement Package

According to this link, the JDBC package is required by JetBrain's DataGrip IDE.

Thanks,
Jerry

The JDBC drivers not packaged anywhere?

Downloading https://download.oracle.com/otn_software/mac/instantclient/instantclient-basic-macos.zip, I see that ojdbc8.jar is part of that zip.

But you do not package it.

$ cd /opt/homebrew/Cellar
$ find . -iname ojdbc8.jar
$

Any chance to add this to the basic package, or create an instantclient-jdbc package?

The JDBC client jar is needed by DBeaver.app, for example, which is also avaiable in Homebrew.

Installation of oracle 19 sqlldr failed

$ cat ......./Library/Logs/Homebrew/instantclient-tools/01.install_name_tool
2020-05-06 15:00:06 +1000

/usr/bin/install_name_tool
-add_rpath
......./homebrew/lib
tools

error: /Library/Developer/CommandLineTools/usr/bin/install_name_tool: can't open file: tools (No such file or directory)

HOMEBREW_VERSION: 2.2.15
ORIGIN: https://github.com/Homebrew/brew
HEAD: e1f3b0b971dccb72780b2ef33fafde158cb3909e
Last commit: 2 days ago
Core tap ORIGIN: https://github.com/Homebrew/homebrew-core
Core tap HEAD: 317b27f86273ad232a54412371f4a4dd8a1900fb
Core tap last commit: 3 hours ago
HOMEBREW_PREFIX: ......./homebrew
HOMEBREW_REPOSITORY: ......./homebrew
HOMEBREW_CELLAR: ......./homebrew/Cellar
HOMEBREW_DISPLAY: /private/tmp/com.apple.launchd.m9kdCle800/org.macosforge.xquartz:0
HOMEBREW_MAKE_JOBS: 12
CPU: dodeca-core 64-bit kabylake
Homebrew Ruby: 2.6.3 => ......./homebrew/Library/Homebrew/vendor/portable-ruby/2.6.3/bin/ruby
Clang: 10.0 build 1001
Git: 2.20.1 => /Library/Developer/CommandLineTools/usr/bin/git
Curl: 7.54.0 => /usr/bin/curl
Java: 1.8.0_181, 1.8.0_141, 1.7.0_80
macOS: 10.14.6-x86_64
CLT: 10.3.0.0.1.1562985497
Xcode: N/A
XQuartz: 2.7.11 => /opt/X11

HOMEBREW_CC: clang
HOMEBREW_CXX: clang++
MAKEFLAGS: -j12
CMAKE_PREFIX_PATH: ......./homebrew
CMAKE_INCLUDE_PATH: /Library/Developer/CommandLineTools/SDKs/MacOSX10.14.sdk/usr/include/libxml2:/Library/Developer/CommandLineTools/SDKs/MacOSX10.14.sdk/System/Library/Frameworks/OpenGL.framework/Versions/Current/Headers
CMAKE_LIBRARY_PATH: /Library/Developer/CommandLineTools/SDKs/MacOSX10.14.sdk/System/Library/Frameworks/OpenGL.framework/Versions/Current/Libraries
PKG_CONFIG_LIBDIR: /usr/lib/pkgconfig:......./homebrew/Library/Homebrew/os/mac/pkgconfig/10.14
HOMEBREW_GIT: git
HOMEBREW_SDKROOT: /Library/Developer/CommandLineTools/SDKs/MacOSX10.14.sdk
ACLOCAL_PATH: ......./homebrew/share/aclocal
PATH: ......./homebrew/Library/Homebrew/shims/mac/super:/usr/bin:/bin:/usr/sbin:/sbin

$ unzip -v instantclient-tools--19.3.0.0.0dbru.zip
Archive:  instantclient-tools--19.3.0.0.0dbru.zip
 Length   Method    Size  Cmpr    Date    Time   CRC-32   Name
--------  ------  ------- ---- ---------- ----- --------  ----
    5780  Defl:N     2374  59% 02-23-2019 11:26 cb5e9337  instantclient_19_3/TOOLS_LICENSE
    1670  Defl:N      837  50% 09-06-2019 19:11 c741ccfd  instantclient_19_3/TOOLS_README
  715336  Defl:N   245148  66% 09-06-2019 19:11 4bf46b91  instantclient_19_3/exp
  228196  Defl:N    74794  67% 09-06-2019 19:11 589916ee  instantclient_19_3/expdp
  385436  Defl:N   136999  65% 09-06-2019 19:11 9cac78ed  instantclient_19_3/imp
  240444  Defl:N    79258  67% 09-06-2019 19:11 aa80b5c0  instantclient_19_3/impdp
   23252  Defl:N     6789  71% 07-04-2019 02:29 e45e5cdf  instantclient_19_3/libnfsodm19.dylib
 1868868  Defl:N   362522  81% 09-06-2019 19:11 eb858e56  instantclient_19_3/sqlldr
 1062136  Defl:N   301566  72% 09-06-2019 19:11 2c63edf7  instantclient_19_3/wrc
--------          -------  ---                            -------
 4531118          1210287  73%                            9 files

! No 'tools'

[stable] $ diff -u ./Library/Taps//instantclienttap/homebrew-instantclient/Formula/instantclient-tools.rb.orig ./Library/Taps//instantclienttap/homebrew-instantclient/Formula/instantclient-tools.rb
--- ./Library/Taps//instantclienttap/homebrew-instantclient/Formula/instantclient-tools.rb.orig	2020-05-07 09:17:44.000000000 +1000
+++ ./Library/Taps//instantclienttap/homebrew-instantclient/Formula/instantclient-tools.rb	2020-05-07 09:15:05.000000000 +1000
@@ -13,9 +13,18 @@

   def install
     if HOMEBREW_PREFIX.to_s != "/usr/local"
-      system DevelopmentTools.locate("install_name_tool"), "-add_rpath", HOMEBREW_PREFIX/"lib", "tools"
+      # original system DevelopmentTools.locate("install_name_tool"), "-add_rpath", HOMEBREW_PREFIX/"lib", "tools"
+      system DevelopmentTools.locate("install_name_tool"), "-add_rpath", HOMEBREW_PREFIX/"lib", "sqlldr"
+      system DevelopmentTools.locate("install_name_tool"), "-add_rpath", HOMEBREW_PREFIX/"lib", "impdp"
+      system DevelopmentTools.locate("install_name_tool"), "-add_rpath", HOMEBREW_PREFIX/"lib", "expdp"
+      system DevelopmentTools.locate("install_name_tool"), "-add_rpath", HOMEBREW_PREFIX/"lib", "imp"
+      system DevelopmentTools.locate("install_name_tool"), "-add_rpath", HOMEBREW_PREFIX/"lib", "exp"
+      system DevelopmentTools.locate("install_name_tool"), "-add_rpath", HOMEBREW_PREFIX/"lib", "wrc"
     end
     lib.install Dir["*.dylib"]
     bin.install %w[impdp expdp exp imp wrc sqlldr]
+    if MacOS.version == :catalina
+      bin.env_script_all_files(libexec, "DYLD_LIBRARY_PATH" => HOMEBREW_PREFIX/"lib")
+    end
   end
 end

[stable] $ brew reinstall instantclient-tools
==> Reinstalling instantclienttap/instantclient/instantclient-tools
==> Downloading https://download.oracle.com/otn_software/mac/instantclient/193000/instantclient-tools-macos.x64-19.3.0.0.0dbru.zip
Already downloaded: ......../Library/Caches/Homebrew/downloads/363ae83a1afaf22e2708b34e45b12efe3805a7ae2d361d5b6d5645368e1fd71e--instantclient-tools-macos.x64-19.3.0.0.0dbru.zip
==> /usr/bin/install_name_tool -add_rpath ......./homebrew/lib sqlldr
==> /usr/bin/install_name_tool -add_rpath ......./homebrew/lib impdp
==> /usr/bin/install_name_tool -add_rpath ......./homebrew/lib expdp
==> /usr/bin/install_name_tool -add_rpath ......./homebrew/lib imp
==> /usr/bin/install_name_tool -add_rpath ......./homebrew/lib exp
==> /usr/bin/install_name_tool -add_rpath ......./homebrew/lib wrc
🍺  ......../homebrew/Cellar/instantclient-tools/19.3.0.0.0dbru: 9 files, 4.3MB, built in 2 seconds

Use Homebrew to set a cookie?

Can Homebrew set a cookie? If so, perhaps you could follow the logic that Scoop's oraclejdk package uses; essentially set the oraclelicense to accept-securebackup-cookie.

network/admin setup

hey,

great stuff!

any ideas on what is the right path after installing instant client to setup configuration of ldap.ora and tnsnames.ora to be resolved from?
Should it be any path exported with ORACLE_HOME variable ? Can't locate network/admin folder anywhere.

Br,
Tadas

Error installing instantclient-sqlplus. Calling MacOS.locate is disabled!

I ran into the following error when installing instantclient-sqlplus on MacOS Sierra (10.12.6)

Error: Calling MacOS.locate is disabled!
Use DevelopmentTools.locate instead.
/Users/ldrf/homebrew/Library/Taps/instantclienttap/homebrew-instantclient/Formula/instantclient-sqlplus.rb:24:in `install'

The following sdk11 link is invalid

http://download.oracle.com/otn/mac/instantclient/11204/instantclient-sdk-macos.x64-11.2.0.4.0.zip

The above link no longer works from oracle.

Why does sqlplus conflict with basiclite?

First of all, this is an awesome project, thanks for making this easier!

I wanted to install basiclite and sqlplus. I downloaded the files and put them in my cache. basiclite installed fine, but sqlplus threw an error:

Error: Cannot install instantclienttap/instantclient/instantclient-basic because conflicting formulae are installed.
  instantclient-basiclite

Please `brew unlink instantclient-basiclite` before continuing.

Does sqlplus only work with basic for some reason?

Broken README.md link

Link in README is broken for Oracle Instant Client

Link

Issue installing instantclient-basic

Hello,

I have been using the instantclient tap successfully with ruby-oci8 gem for a while, and just got this report during brew upgrade:

 brew install InstantClientTap/instantclient/instantclient-basic
==> Installing instantclient-basic from instantclienttap/instantclient
==> Downloading http://download.oracle.com/otn/mac/instantclient/122010/instantclient-basic-macos.x64-12.2.0.1.0.zip
Already downloaded: /Users/kingdonb/Library/Caches/Homebrew/instantclient-basic-macos.x64-12.2.0.1.0.zip
Error: File exists @ syserr_fail2_in - libclntsh.dylib

I have tried to remove all of the related libraries (instantclient-{basic,sqlplus,sdk}) and I get this error with only instantclient-basic. Is there an error in this? If you can you reproduce the issue, I'd love to know the solution as I have little understanding of how homebrew works. If you cannot, I'll be glad to provide more information!

Thanks

feature request: formula for ODBC package

Thanks for this helpful tap. Has there been any consideration of adding the Instant Client ODBC package? I routinely connect to Oracle Database via ODBC, so this would be very helpful.

Executing sqlplus fails

When trying to execute sqlplus after installing it using brew install instantclient-sqlplus I get the following error:

Error 6 initializing SQL*Plus
SP2-0667: Message file sp1<lang>.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory

The same thing happens if I install with --with-basiclite

Please add instant client 11.2 option

Instant client 19.8 cannot be use for old oracle such as 9i.
Please consider add option for instant client 11.2