Subject: | Troubleshooting Doc Update Request [ New Section factoids ] |
Date: | Sat, 13 Jun 2020 19:22:49 -0400 |
To: | bug-DBD-Oracle [...] rt.cpan.org |
From: | Gary Allen Vollink <gary [...] vollink.com> |
This might be too wordy, but this would be super helpful in
Troubleshooting, so nobody else has to do the digging for this...
===================
macOS 10.15.5 - Catalina (Darwin Kernel 19.5.0) -- Oracle instantclient-19.3
Though the tar should already do this for you, verify that in the
instantclient_19.1 directory, the following softlinks are correct
libclntsh.dylib -> libclntsh.dylib.19.1
libclntshcore.dylib -> libclntshcore.dylib.19.1
libocci.dylib -> libocci.dylib.19.1
THEN use the xcode included command install_name_tool to set the
libclntsh.dylib.19.1 tag as a FULL PATH tag like this.
Assuming Oracle instant client (base, sqlplus and oracle SDK) is
extracted into /usr/local/oracle...
*install_name_tool -id
/usr/local/oracle/instantclient_19_3/libclntsh.dylib.19.1
/usr/local/oracle/instantclient_19_3/libclntsh.dylib.19.1*
THEN bring up System Preferences and select the Security and Privacy
panel. Make sure it is unlocked, leave it open and in Terminal, start
Oracle's sqlplus (it doesn't have to connect to anything). It will
probably fail, but in the Security and Privacy panel, the blocked library
will appear, unblock it. Keep doing this until no Oracle library is still
blocked and sqlplus starts (even if it fails with a connect error, that's
fine as long as there isn't a dialog outside of the Terminal).
Build the Perl module (but keep the Security and Privacy panel open just in
case a different Oracle library/by a different tag location is blocked
again during build).
=====================
Ultimately, I had success, I'm hoping this information helps others.
Thank you,
Gary Allen Vollink