jcon.no: Oracle blog

This blogpost looks at installing SQL Developer (this blog looks at version 24.3.1) without Java bundled.

Note! This is not supported by Oracle, so if trouble you are on your own. There is really no reason to actually do this, because SQL Developer is bundled with Oracle Java (which requires no licenses when – at least per today – is used when using SQL Developer together with licensed versions of the Oracle Databases).

Install SQL Developer (Zip)
Step 1: Download the SQL Developer application from https://www.oracle.com/database/sqldeveloper/technologies/download/ (Choose “Other platforms”)

Step 2: Unzip download and place at appropriate directory. I used /Users/myUser/apps

Step 3: Run the following in a terminal window to find path to javafx libraries:

> find / -name libprism_sw.dylib 2>/dev/null

Find the path for your new installation (at /Users/myUser/apps/sqldeveloper/…).

Step 4: Run the following in a terminal window (edit accourding to path found in last step):

xattr -d com.apple.quarantine /Users/myUser/apps/sqldeveloper/modules/javafx/osx-aarch64/lib/libprism_sw.dylib
xattr -d com.apple.quarantine /Users/myUser/apps/sqldeveloper/modules/javafx/osx-aarch64/lib/libglass.dylib
xattr -d com.apple.quarantine /Users/myUser/apps/sqldeveloper/modules/javafx/osx-aarch64/lib/libjfxwebkit.dylib
xattr -d com.apple.quarantine /Users/myUser/apps/sqldeveloper/modules/javafx/osx-aarch64/lib/libjavafx_font.dylib
xattr -d com.apple.quarantine /Users/myUser/apps/sqldeveloper/modules/javafx/osx-aarch64/lib/libdecora_sse.dylib
xattr -d com.apple.quarantine /Users/myUser/apps/sqldeveloper/modules/javafx/osx-aarch64/lib/libgstreamer-lite.dylib
xattr -d com.apple.quarantine /Users/myUser/apps/sqldeveloper/modules/javafx/osx-aarch64/lib/libjfxmedia.dylib
xattr -d com.apple.quarantine /Users/myUser/apps/sqldeveloper/modules/javafx/osx-aarch64/lib/libjfxmedia_avf.dylib

Step 5: Set the path to your Java version in the “.sqldeveloper/24.3.1/product.conf” file (this version requires Java version 17).
Seach for “SetJavaHome” in the product.conf file. Uncomment this line and set the Java Home path (I’m using Azul OpenJDK):

SetJavaHome /Library/Java/JavaVirtualMachines/zulu-17.jdk/Contents/Home

Note! You might need to open SQL Developer first so the “24.3.1” directory is created with the “product.conf” file.

Use Automator to create a shortcut on the Dock

Open the Automator application and go to “Library->Utilities” and double click “Run Shell Script”.
In the Shell command window add the command to startup your SQLDeveloper:

Then choose “File -> Save as …”, and save as “SQLDeveloper 24.3.1.app” for instance in “Desktop”.
Find the icon you want to use in Finder, and mark it and click “Command + c” to copy. Right click your “SQLDeveloper 24.3.1.app” in your Desktop folder, and choose “Get Info”. Click the icon in the top left corner, and click “Command + v” to paste your new Icon.

Now you should be ready to drag your “SQLDeveloper 24.3.1.app” to the Dock.
Hope this helps.