Good morning,
I am attempting to leverage the OCI/Thick driver in SQL Developer 4.1.1 running on OS X Yosemite (10.10.5).
For clarity, I've downloaded the 64bit drivers
- instantclient-basic-macos.x64-12.1.0.2.0.zip
- instantclient-sqlplus-macos.x64-12.1.0.2.0.zip
- instantclient-odbc-macos.x64-12.1.0.2.0.zip
and have extracted them to /Applications/instantclient_12_1
I've also followed the directions at the end for 12_1 (Instant Client downloads for Mac OS X (Intel x86) ) for creating the soft links.
Below is my general configuration.
[09:29 AM] cjtravis@MBP01 /Applications/instantclient_12_1
# echo $DYLD_LIBRARY_PATH
/Applications/instantclient_12_1
[09:29 AM] cjtravis@MBP01 /Applications/instantclient_12_1
# echo $PATH
/opt/local/bin:/opt/local/sbin:/Applications/instantclient_12_1:/opt/local/bin:/opt/local/sbin:/Applications/instantclient_12_1:/usr/local/bin:/usr/bin:/bin:/usr/sbin:/sbin:/opt/X11/bin:/opt/local/bin:/opt/local/sbin:/opt/local/bin:/opt/local/sbin
[09:29 AM] cjtravis@MBP01 /Applications/instantclient_12_1
# echo $TNS_ADMIN
/Applications/instantclient_12_1/network/admin
[09:30 AM] cjtravis@MBP01 /Applications/instantclient_12_1
# file /Applications/instantclient_12_1/*
/Applications/instantclient_12_1/BASIC_README: ASCII text
/Applications/instantclient_12_1/ODBC_IC_Readme_Unix.html: HTML document text
/Applications/instantclient_12_1/SQLPLUS_README: ASCII text
/Applications/instantclient_12_1/adrci: Mach-O 64-bit executable x86_64
/Applications/instantclient_12_1/genezi: Mach-O 64-bit executable x86_64
/Applications/instantclient_12_1/glogin.sql: ASCII English text
/Applications/instantclient_12_1/jdbc: directory
/Applications/instantclient_12_1/libclntsh.dylib: Mach-O 64-bit dynamically linked shared library x86_64
/Applications/instantclient_12_1/libclntsh.dylib.12.1: Mach-O 64-bit dynamically linked shared library x86_64
/Applications/instantclient_12_1/libclntshcore.dylib.12.1: Mach-O 64-bit dynamically linked shared library x86_64
/Applications/instantclient_12_1/libnnz12.dylib: Mach-O 64-bit dynamically linked shared library x86_64
/Applications/instantclient_12_1/libocci.dylib: Mach-O 64-bit dynamically linked shared library x86_64
/Applications/instantclient_12_1/libocci.dylib.12.1: Mach-O 64-bit dynamically linked shared library x86_64
/Applications/instantclient_12_1/libociei.dylib: Mach-O 64-bit bundle x86_64
/Applications/instantclient_12_1/libocijdbc12.dylib: Mach-O 64-bit bundle x86_64
/Applications/instantclient_12_1/libons.dylib: Mach-O 64-bit dynamically linked shared library x86_64
/Applications/instantclient_12_1/liboramysql12.dylib: Mach-O 64-bit dynamically linked shared library x86_64
/Applications/instantclient_12_1/libsqlplus.dylib: Mach-O 64-bit dynamically linked shared library x86_64
/Applications/instantclient_12_1/libsqlplusic.dylib: Mach-O 64-bit bundle x86_64
/Applications/instantclient_12_1/libsqora.dylib.12.1: Mach-O 64-bit dynamically linked shared library x86_64
/Applications/instantclient_12_1/network: directory
/Applications/instantclient_12_1/odbc_update_ini.sh: POSIX shell script text executable
/Applications/instantclient_12_1/ojdbc6.jar: Zip archive data, at least v1.0 to extract
/Applications/instantclient_12_1/ojdbc7.jar: Zip archive data, at least v1.0 to extract
/Applications/instantclient_12_1/sqlplus: Mach-O 64-bit executable x86_64
/Applications/instantclient_12_1/uidrvci: Mach-O 64-bit executable x86_64
/Applications/instantclient_12_1/xstreams.jar: Zip archive data, at least v1.0 to extract
When I configure SQL Developer to use the OCI/Thick client:
I receive the following message:
Testing the Instant Client located at /Applications/instantclient_12_1
Testing client directory ... OK
Testing loading Oracle JDBC driver ... OK
Testing checking Oracle JDBC driver version ... OK
Driver version: 12.1.0.2.0
Testing testing native OCI library load ... Failed:
Error loading the native OCI library
The native OCI driver could not be loaded. The system propertyjava.library.path contains the entries from the environment variable DYLD_LIBRARY_PATH. Check it to verify that
the expected native library directory /Applications/instantclient_12_1 is present and precedes any other client installations.
java.library.path = /Users/cjtravis/Library/Java/Extensions:/Library/Java/Extensions:/Network/Library/Java/Extensions:/System/Library/Java/Extensions:/usr/lib/java:.
I've spent more time than I'd like to admit troubleshooting this issue. I've set my $DYLD_LIBRARY_PATH with no luck.
Any feedback is appreciated. Have I overlooked a painfully obvious configuration setting somewhere? Thanks in advance.