Error: DPI-1047 using Instant Client on macOS Catalina 10.15

[nchillal]

I recently upgrade my mac to Mac OS Catalina Beta version. After that cx-Oracle is not working. Fails with error message below.

cx_Oracle.DatabaseError: DPI-1047: Cannot locate a 64-bit Oracle Client library: "dlopen(libclntsh.dylib, 1): image not found". See https://oracle.github.io/odpi/doc/installation.html#macos for help

Version
Python 3.7.4
cx-Oracle 7.2.0

This looks to me due to Apple dropping support of 32-bit apps. Can you confirm?

[anthony-tuininga]

Did you install a 64-bit Oracle Instant Client? If you were running a 32-bit Python installation before the upgrade, the answer is probably no. :-) You'll need to do that, especially if macOS no longer has a 32-bit Python installation available for you to use! And 64-bit is a good idea in any case!

[nchillal]

Yes i did install 64-bit client. I have also reinstall just to make sure using below link.

https://download.oracle.com/otn/mac/instantclient/181000/instantclient-basic-macos.x64-18.1.0.0.0.zip

W.r.t python its 64-bit.

I have following under ~/lib

libclntsh.dylib.18.1 -> ${HOME}/Downloads/instantclient_18_1/libclntsh.dylib.18.1
libclntshcore.dylib.18.1 -> ${HOME}/Downloads/instantclient_18_1/libclntshcore.dylib.18.1
libons.dylib -> ${HOME}/Downloads/instantclient_18_1/libons.dylib
libnnz18.dylib -> ${HOME}/Downloads/instantclient_18_1/libnnz18.dylib
libociei.dylib -> ${HOME}/Downloads/instantclient_18_1/libociei.dylib

Note: everything was working fine before upgrading to mac os catalina.

[anthony-tuininga]

I don't own a machine running macOS, so I can't help directly. Perhaps @cjbj who does own a machine running macOS can help more.

Did you look at the cx_Oracle installation documentation? Take note of the first paragraph in that section.

[nchillal]

Yes i have followed installation documention. It worked before i installed Mac OS Catalina.

[cjbj]

Which Python are you actually using? What is the output of which python ?

[nchillal]

I use python3. I don't use the built python version. Python3 is installed by homebrew package.

➜ brew list python
/usr/local/Cellar/python/3.7.4/bin/2to3
/usr/local/Cellar/python/3.7.4/bin/2to3-3.7
/usr/local/Cellar/python/3.7.4/bin/easy_install-3.7
/usr/local/Cellar/python/3.7.4/bin/idle3
/usr/local/Cellar/python/3.7.4/bin/idle3.7
/usr/local/Cellar/python/3.7.4/bin/pip3
/usr/local/Cellar/python/3.7.4/bin/pip3.7
/usr/local/Cellar/python/3.7.4/bin/pydoc3
/usr/local/Cellar/python/3.7.4/bin/pydoc3.7
/usr/local/Cellar/python/3.7.4/bin/python3
/usr/local/Cellar/python/3.7.4/bin/python3-config
/usr/local/Cellar/python/3.7.4/bin/python3.7
/usr/local/Cellar/python/3.7.4/bin/python3.7-config
/usr/local/Cellar/python/3.7.4/bin/python3.7m
/usr/local/Cellar/python/3.7.4/bin/python3.7m-config
/usr/local/Cellar/python/3.7.4/bin/pyvenv
/usr/local/Cellar/python/3.7.4/bin/pyvenv-3.7
/usr/local/Cellar/python/3.7.4/bin/wheel3
/usr/local/Cellar/python/3.7.4/Frameworks/Python.framework/ (2914 files)
/usr/local/Cellar/python/3.7.4/IDLE 3.app/Contents/ (8 files)
/usr/local/Cellar/python/3.7.4/lib/pkgconfig/ (3 files)
/usr/local/Cellar/python/3.7.4/libexec/bin/ (7 files)
/usr/local/Cellar/python/3.7.4/libexec/pip/ (699 files)
/usr/local/Cellar/python/3.7.4/libexec/setuptools/ (346 files)
/usr/local/Cellar/python/3.7.4/libexec/wheel/ (38 files)
/usr/local/Cellar/python/3.7.4/Python Launcher 3.app/Contents/ (16 files)
/usr/local/Cellar/python/3.7.4/share/man/ (2 files)

[cjbj]

What does which python show or how do you know you are running the brew python?

Does SQL*Plus work?

[nchillal]

➜ head -1 $HOME/my_script.py
#!/usr/bin/env python3

➜ which python
/usr/bin/python

Note: This was working before in Mac OS Mojave after i upgrade to Mac OS Catalina Beta its not working.

[cjbj]

Does SQL*Plus work? There have been several macOS versions in the past that broke Oracle client tools.

[cjbj]

Reading the message buried the screenshot (reminder to everyone: don't use screenshots!) It rang a bell with:

• https://www.reddit.com/r/virtualbox/comments/bjwwvd/virtualbox_in_macos_mojave_10145_beta_4/
• https://forums.virtualbox.org/viewtopic.php?f=8&t=84092&p=448559#p448559

I don't have any other info at the moment specific to Instant Client.

[nchillal]

Does SQL*Plus work? There have been several macOS versions in the past that broke Oracle client tools.

I have not tried it. Will try and let you know.

[cjbj]

Hmm. Notarization: https://developer.apple.com/documentation/security/notarizing_your_app_before_distribution

[nchillal]

Latest release of catalina has fixed this issue.