Oracle Instant Client still not working on Mac OS Catalina 10.15.4

• Go to https://www.oracle.com/technical-resources/
• Downloads --> Oracle Instant Client --> macOS(Intel x86) --> Basic Package
• In your download folder you will find a folder named instantclient_19_3
• Add the following to your python script

import cx_Oraclecx_Oracle.init_oracle_client(lib_dir=r'/Users/<username>/Downloads/instantclient_19_3')

Some windows will pop up, so go to System preferences --> Security & Privacy --> General and there you will see a notification. Click on open anyway. You will have to repeat this last step 3-4 times.

After you download instant client from here, create a symbolic link into /usr/local/lib folder (that's where all .dylib files keep their symbolic links).

In my case, I extracted instant client into /opt/oracle/instantclient_19_3. So the command is:

$ ln -s /opt/oracle/instantclient_19_3/libclntsh.dylib /usr/local/lib/

However, there is another problem when I try to create the connection from python:

Error while trying to retrieve text for error ORA-01804

Oracle says: "Instant Client 19.3 and 18.1 support macOS Mojave and High Sierra", and I have macOS Catalina 10.15, don't know if this has anything to do with that, error 01804 says that timezone information is invalid.

More info on this: http://www.dba-oracle.com/t_ora_01804_start_oracle.htm

EDIT: issue resolved.

After downloading the SQL*Plus Package I managed to connect and verify the instant client works. My python issue was also resolved when I restarted IntelliJ (I was running the server from within so the PATH might have not been updated).

Maybe the error is misleading and it is related to general issue with Oracle Instant Client on MacOS Catalina? Have a look at this blog post:

Gary's Oracle On Tap

Hope this helps!