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!

sql developer can't load instant client on mac os

I vanJan 7 2022

When i was windows user i used instant client in sql developer and there are no problems but now i've got this:

Testing the Instant Client located at /Applications/ora/client/instantclient_19_8
Testing client directory ... OK
Testing loading Oracle JDBC driver ... OK
Testing checking Oracle JDBC driver version ... OK
 Driver version: 19.8.0.0.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/ora/client/instantclient_19_8 is present and precedes any other client installations.
 java.library.path = /Users/ivan/Library/Java/Extensions:/Library/Java/Extensions:/Network/Library/Java/Extensions:/System/Library/Java/Extensions:/usr/lib/java:

What should i do?
Before write this I removed apple quarantine attribute:

chmod -R u+w /Applications/ora/client/instantclient_19_8
xattr -r -d -s com.apple.quarantine /Applications/ora/client/instantclient_19_8/*

Also i tried to set DYLD_LIBRARY_PATH in sqldeveloper.sh file:

export DYLD_LIBRARY_PATH=/Applications/ora/client/instantclient_19_8

My specs:

Sql Developer Version: Version 21.4.1.349 Build 349.1822
JAVA version: 17
Instant client version: 19.8
Mac OS version:  12.1
This post has been answered by John McGinnis-Oracle on Jan 7 2022
Jump to Answer
Comments
Post Details
Added on Jan 7 2022
3 comments
2,174 views