Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 28 2016
Added on Nov 30 2016
10 comments
16,051 views