I am trying to test out the Instant Client which is located /Users/username/Library/Java/Extensions but I keep getting the following:
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 /Users/jesthomp/Library/Java/Extensions is present and precedes any other client installations.
java.library.path = /Users/username/Library/Java/Extensions:/Library/Java/Extensions:/Network/Library/Java/Extensions:/System/Library/Java/Extensions:/usr/lib/java:.
I have attempted putting my instantclient folder in many places and when I set the setting in Preferences -> Database -> Advanced for Configure Oracle client whenever I set it to a directory that contains a ojdbc file I keep getting that error. I set the sqldeveloper.sh file under /Applications/SQLDeveloper.app/Contents/Resources/sqldeveloper to this:
#!/bin/bash
export DYLD_LIBRARY_PATH=/Users/username/Downloads/instantclient_19_8
cd "`dirname $0`"/sqldeveloper/bin && bash sqldeveloper $*
which seemed to set sqldeveloper.oci.available to true under Help -> About -> Properties
Now that I moved my ojdbc8.jar file to the first directory listed under java.library.path I actually have no idea why it is not working now.
This is sqldeveloper-19.1.0.094.2042-macosx running on the following:
Version MacOS Monterey 12.6
Model Name: MacBook Pro (16-inch, 2019)
Model Identifier: MacBookPro16,1
Processor Name: 6-Core Intel Core i7
Processor Speed: 2.6 GHz
Number of Processors: 1
Total Number of Cores: 6
L2 Cache (per Core): 256 KB
L3 Cache: 12 MB
Hyper-Threading Technology: Enabled
Memory: 16 GB
System Firmware Version: 1731.140.2.0.0 (iBridge: 19.16.16067.0.0,0)
Graphics AMD Radeon Pro 5300M 4 GB
Intel UHD Graphics 630 1536 MB