Skip to Main Content

Error loading the native OCI library on OS X using 12.1.0.2.0

cj.travisNov 30 2016 — edited Nov 30 2016

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.

Screenshot 2016-11-30 09.36.05.png

[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:

Screenshot 2016-11-30 09.32.49.png

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:.

Screenshot 2016-11-30 09.36.13.png

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.

Comments
Post Details
Added on Nov 30 2016
10 comments
14,693 views