DEV Community

Cover image for Running Oracle SQL Developer without Oracle Java: Temurin to the rescue
Sergio Farfan Cardenete
Sergio Farfan Cardenete

Posted on

Running Oracle SQL Developer without Oracle Java: Temurin to the rescue

Connect with me: LinkedIn | X | GitHub

Oracle SQL Developer is still one of the most practical desktop tools for working with Oracle databases. It is free to download and use. The Java runtime that comes inside some of its downloads is a different story, and it is the reason many corporate laptops now show up in Java licence audits.

This post explains why that happens and how to run SQL Developer on Eclipse Temurin, the free and openly licensed OpenJDK build from the Eclipse Adoptium project, on both macOS and Windows. It also covers the two traps I fell into along the way, so you don't have to.


Why bother?

SQL Developer is a Java application. Oracle ships it in two flavours:

  • With a JDK included: the macOS ARM64 / x64 apps and the "Windows 64-bit with JDK 17 included" zip. These carry an Oracle JDK inside the application folder.
  • Without a JDK: the "Other Platforms" zip (the same file Oracle also lists as "Windows 32-bit/64-bit, requires JDK"). You bring your own Java.

The 24.3.1 bundles contain Oracle JDK 17.0.13. That version matters. Oracle's licence FAQ explains that Oracle JDK 17 was covered by the permissive No-Fee Terms and Conditions only up to 17.0.12 (September 2024). From 17.0.13 onwards, JDK 17 updates are under the Oracle Technology Network (OTN) licence, which is much narrower. You can confirm this on your own machine: the licence file inside the bundled JDK (jdk/legal/java.base/LICENSE) simply points to https://java.com/otnlicense.

Whether a JDK embedded in a free Oracle tool needs a separate licence for your use case is a question for your licensing team, not for a blog post. In practice, though, software-asset tools flag any Oracle JDK they find on disk, and the simplest way to make the finding go away is to not have one. SQL Developer runs happily on an OpenJDK build, so that is what we will do.

What you need

Component Version Where to get it
Oracle SQL Developer, no-JDK zip 24.3.1.347.1826 SQL Developer downloads ("Other Platforms"), or direct: sqldeveloper-24.3.1.347.1826-no-jre.zip (about 588 MB)
Eclipse Temurin JDK 17 (17.0.21 at the time of writing) adoptium.net, Temurin 17 releases

The same zip works on macOS, Windows and Linux. At the time of writing it downloads without an Oracle account sign-in.

To check your download, these are the values for the 24.3.1 zip I used:

SHA-256: 3390ef58972f1f255077c49e66b171b8664773bb16e37570a7ca16acc5afb8cb
MD5:     7de67da92e557e6cc3f8104c9fad951e
Enter fullscreen mode Exit fullscreen mode

Why Temurin 17, and not 21 or the latest?

Oracle's release notes and installation guide for SQL Developer 24.3 name JDK 17 as the requirement. I tested the newest Temurin I had installed (JDK 27) out of curiosity, and it fails in two separate places:

  1. The JVM refuses to start: Unrecognized verification option: -Xverify:none. SQL Developer's ide.conf passes an option that has since been removed from Java.
  2. With that option commented out, startup fails again: java.lang.module.FindException: Module jdk.jsobject not found, required by javafx.web. Newer JDKs no longer ship that module, and SQL Developer's embedded JavaFX web component needs it.

You could patch your way around both, but you would be running an untested combination of a tool you depend on every day. Temurin 17 is supported, free, gets security updates, and just works. Use it only for SQL Developer if you like. It can sit alongside any newer JDK you already have.


macOS: step by step

Tested on macOS Tahoe (Apple Silicon) with SQL Developer 24.3.1 and Temurin 17.0.21.

Before you start: do not edit the Mac app bundle

Before the steps, here is the trap I fell into. If you already have the macOS SQL Developer app (the one with the JDK included), it is tempting to delete the jdk folder inside SQLDeveloper.app/Contents/Resources/sqldeveloper/ and point the app at Temurin. Don't.

The macOS app is code-signed, and the signature covers every file inside the bundle. Remove one folder and macOS reports the app as damaged, with an offer to move it to the Trash. That is exactly what happened to mine. Use the no-JDK zip below instead. It is a plain folder rather than a signed bundle, so you can arrange it however you like. Your existing settings and connections live in ~/.sqldeveloper, outside the app, and the new install picks them up as long as it is the same version.

Step 1: install Temurin 17

Option A, Homebrew:

brew install --cask temurin@17
Enter fullscreen mode Exit fullscreen mode

The installer asks for your administrator password.

Option B, installer package: download the .pkg for your Mac (aarch64 for Apple Silicon, x64 for Intel) from Temurin 17 releases and double-click it.

Either way, the JDK lands in /Library/Java/JavaVirtualMachines/temurin-17.jdk. To check it:

/Library/Java/JavaVirtualMachines/temurin-17.jdk/Contents/Home/bin/java -version
Enter fullscreen mode Exit fullscreen mode

You should see OpenJDK Runtime Environment Temurin-17....

Terminal showing java -version for Temurin 17.0.21, and temurin-17.jdk next to a newer JDK in /Library/Java/JavaVirtualMachines

If you have newer JDKs installed, macOS keeps using the newest one as the default java. That is fine, because SQL Developer gets its own explicit setting in step 4.

Step 2: download SQL Developer without a JDK

From the SQL Developer downloads page, pick Other Platforms, or use the direct link from the table above. In Terminal:

mkdir -p ~/Downloads/sqldeveloper-no-jre
cd ~/Downloads/sqldeveloper-no-jre
curl -fLO https://download.oracle.com/otn_software/java/sqldeveloper/sqldeveloper-24.3.1.347.1826-no-jre.zip
shasum -a 256 sqldeveloper-24.3.1.347.1826-no-jre.zip
Enter fullscreen mode Exit fullscreen mode

Compare the SHA-256 with the value above.

Step 3: unzip it

cd ~/Applications
unzip -q ~/Downloads/sqldeveloper-no-jre/sqldeveloper-24.3.1.347.1826-no-jre.zip
ls ~/Applications/sqldeveloper
Enter fullscreen mode Exit fullscreen mode

You should see folders such as ide, jdbc and sqldeveloper, and a sqldeveloper.sh script. There is no jdk folder, which is the point.

If you downloaded the zip with a browser rather than curl, macOS marks the files as quarantined. If SQL Developer later complains about libraries that "cannot be opened", clear the flag on this folder only, after you have verified the checksum:

xattr -dr com.apple.quarantine ~/Applications/sqldeveloper
Enter fullscreen mode Exit fullscreen mode

Step 4: tell SQL Developer which Java to use

SQL Developer reads a per-user file, ~/.sqldeveloper/24.3.1/product.conf. Add a SetJavaHome line pointing at Temurin 17:

mkdir -p ~/.sqldeveloper/24.3.1
echo 'SetJavaHome /Library/Java/JavaVirtualMachines/temurin-17.jdk/Contents/Home' >> ~/.sqldeveloper/24.3.1/product.conf
grep SetJavaHome ~/.sqldeveloper/24.3.1/product.conf
Enter fullscreen mode Exit fullscreen mode

If the file already exists from an earlier install, make sure there is only one uncommented SetJavaHome line.

Step 5: start it

bash ~/Applications/sqldeveloper/sqldeveloper.sh
Enter fullscreen mode Exit fullscreen mode

The first start takes a little longer. The terminal shows a few warnings like the ones below. They are expected on JDK 17 and harmless:

OpenJDK 64-Bit Server VM warning: Options -Xverify:none and -noverify were deprecated in JDK 13 ...
WARNING: System::setSecurityManager will be removed in a future release
Enter fullscreen mode Exit fullscreen mode

SQL Developer 24.3.1 running on Temurin 17 on macOS (connection names blurred)

Step 6 (optional): a proper app icon for the Dock and Spotlight

Starting from Terminal gets old quickly. This creates a small SQL Developer.app launcher in ~/Applications, with SQL Developer's own icon. You create it yourself on your own Mac, so macOS doesn't quarantine it, and it never touches the SQL Developer folder.

A="$HOME/Applications/SQL Developer.app"
mkdir -p "$A/Contents/MacOS" "$A/Contents/Resources"

cat > "$A/Contents/MacOS/sqldeveloper-launcher" <<'EOF'
#!/bin/bash
exec /bin/bash "$HOME/Applications/sqldeveloper/sqldeveloper.sh" >>"$HOME/.sqldeveloper/launcher.log" 2>&1
EOF
chmod 755 "$A/Contents/MacOS/sqldeveloper-launcher"

cat > "$A/Contents/Info.plist" <<'EOF'
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd">
<plist version="1.0">
<dict>
  <key>CFBundleName</key><string>SQL Developer</string>
  <key>CFBundleIdentifier</key><string>local.sqldeveloper.launcher</string>
  <key>CFBundlePackageType</key><string>APPL</string>
  <key>CFBundleExecutable</key><string>sqldeveloper-launcher</string>
  <key>CFBundleIconFile</key><string>sqldeveloper</string>
  <key>LSUIElement</key><true/>
</dict>
</plist>
EOF

cp ~/Applications/sqldeveloper/sqldeveloper/bin/SQLDeveloperIcons.icns "$A/Contents/Resources/sqldeveloper.icns"
open "$A"
Enter fullscreen mode Exit fullscreen mode

Drag SQL Developer.app from ~/Applications onto the Dock to keep it there. While SQL Developer is running, the Dock shows the Java window's icon, not the launcher's.

The SQL Developer.app launcher in Finder, with the original SQL Developer icon


Windows: step by step

Step 1: install Temurin 17

Option A, winget (from an elevated PowerShell or Terminal):

winget install EclipseAdoptium.Temurin.17.JDK
Enter fullscreen mode Exit fullscreen mode

Option B, MSI installer: download the Windows x64 .msi from Temurin 17 releases and run it. The defaults add Java to PATH and associate .jar files. Set JAVA_HOME is an optional extra feature that SQL Developer doesn't need.

Temurin installs to C:\Program Files\Eclipse Adoptium\<package>, for example C:\Program Files\Eclipse Adoptium\jdk-17.0.21.9-hotspot. Check the exact folder name in File Explorer, because you will need it in step 4. To check it from a new terminal:

& "C:\Program Files\Eclipse Adoptium\jdk-17.0.21.9-hotspot\bin\java.exe" -version
Enter fullscreen mode Exit fullscreen mode

Step 2: download SQL Developer without a JDK

From the SQL Developer downloads page, pick Windows 32-bit/64-bit (requires JDK) or Other Platforms. They are the same file. Avoid the "with JDK 17 included" download. In PowerShell:

$dir = "$env:USERPROFILE\Downloads\sqldeveloper-no-jre"
New-Item -ItemType Directory -Force $dir | Out-Null
Invoke-WebRequest -Uri "https://download.oracle.com/otn_software/java/sqldeveloper/sqldeveloper-24.3.1.347.1826-no-jre.zip" -OutFile "$dir\sqldeveloper-24.3.1.347.1826-no-jre.zip"
Get-FileHash "$dir\sqldeveloper-24.3.1.347.1826-no-jre.zip" -Algorithm SHA256
Enter fullscreen mode Exit fullscreen mode

Compare the hash with the value above.

Step 3: extract it

Extract to a folder you own. A path without spaces avoids surprises, for example C:\Tools:

Expand-Archive "$env:USERPROFILE\Downloads\sqldeveloper-no-jre\sqldeveloper-24.3.1.347.1826-no-jre.zip" -DestinationPath "C:\Tools"
Enter fullscreen mode Exit fullscreen mode

This gives you C:\Tools\sqldeveloper\sqldeveloper.exe, with no jdk folder.

Step 4: point SQL Developer at Temurin

Either of these works.

Option A, let it ask. Double-click C:\Tools\sqldeveloper\sqldeveloper.exe. When no Java is configured, it asks once for the full path of a JDK. Enter the Temurin folder from step 1, for example:

C:\Program Files\Eclipse Adoptium\jdk-17.0.21.9-hotspot
Enter fullscreen mode Exit fullscreen mode

Option B, set it up front. Create or edit %APPDATA%\sqldeveloper\24.3.1\product.conf and add one line:

SetJavaHome C:\Program Files\Eclipse Adoptium\jdk-17.0.21.9-hotspot
Enter fullscreen mode Exit fullscreen mode

In PowerShell:

$conf = "$env:APPDATA\sqldeveloper\24.3.1"
New-Item -ItemType Directory -Force $conf | Out-Null
Add-Content "$conf\product.conf" 'SetJavaHome C:\Program Files\Eclipse Adoptium\jdk-17.0.21.9-hotspot'
Enter fullscreen mode Exit fullscreen mode

Option A writes exactly this line for you, so you will find it in the same file afterwards.

Step 5: start it and add a shortcut

Run C:\Tools\sqldeveloper\sqldeveloper.exe. To pin it, right-click the running app in the taskbar and choose Pin to taskbar. Or right-click sqldeveloper.exe and choose Show more options > Send to > Desktop (create shortcut).


Check that you are really on Temurin

In SQL Developer, open Help > About and go to the Properties tab. Look for:

  • java.vendor: should read Eclipse Adoptium
  • java.home: should point to the Temurin folder

Tip: type java.v in the search box at the top of the Properties tab to filter the list.

Help > About > Properties filtered on java.v, showing java.vendor Eclipse Adoptium and java.version 17.0.21

Don't be alarmed by java.vm.specification.vendor = Oracle Corporation. That row names the owner of the Java specification, and every Java build reports it, Temurin included. What counts is java.vendor and java.vm.vendor.

On macOS you can also check from Terminal while SQL Developer is running:

ps -axo command | grep '[t]emurin-17.jdk'
Enter fullscreen mode Exit fullscreen mode

Clean up the old Oracle JDK

Once the Temurin-based install works:

  • macOS: remove the old SQLDeveloper.app as a whole. Don't remove pieces of it, for the code-signing reason above. Then check /Library/Java/JavaVirtualMachines and /usr/libexec/java_home -V for any other Oracle JDKs.
  • Windows: delete the old SQL Developer folder that contains a jdk subfolder. Then check Settings > Apps for any "Java" or "Oracle JDK" entries.

Your connections, preferences and SQL history are stored in your user profile, not in the application folder. A same-version reinstall picks them up automatically. Still, export your connections first (right-click Connections > Export Connections) if you want a safety net.

Troubleshooting

Symptom Cause Fix
macOS: "SQLDeveloper is damaged and can't be opened. You should move it to the Trash." Files inside the signed .app were changed Reinstall using the no-JDK zip, and don't modify the .app
Unrecognized verification option: -Xverify:none Running on a JDK newer than 17 that no longer accepts the option (seen on JDK 27) Point SetJavaHome at Temurin 17
Module jdk.jsobject not found, required by javafx.web Running on a recent JDK that no longer ships jdk.jsobject (seen on JDK 27) Point SetJavaHome at Temurin 17
SQL Developer keeps asking for a JDK, or nothing happens on start SetJavaHome points to a folder that doesn't exist Fix the path in product.conf. It must be the JDK home: the folder that contains bin.
macOS: library "cannot be opened" after a browser download Quarantine flag on the extracted files xattr -dr com.apple.quarantine ~/Applications/sqldeveloper (after verifying the checksum)
Deprecation warnings in the terminal on start Normal on JDK 17 None needed

Summary

  1. Install Temurin 17.
  2. Download the no-JDK SQL Developer zip ("Other Platforms").
  3. Unzip it to a folder you own.
  4. Put SetJavaHome <temurin-17 home> in your per-user product.conf.
  5. Start it, check Help > About > Properties, and remove the old bundle.

Fifteen minutes, no Oracle JDK on disk, and the same SQL Developer you already know.


More from me: Oracle and OCI tools

If you work with Oracle and Oracle Cloud Infrastructure (OCI), these open-source projects may save you some time too. Each has a write-up here on dev.to:

On a Mac? I also maintain a few native macOS utilities: RepoDeck (git status of all your repos in one dashboard), AltTab for macOS (Windows-style window switcher) and NoSleep (keep your Mac awake from the menu bar).

All of my projects are on GitHub, and my other articles are on my dev.to profile. For updates and new write-ups, follow me on LinkedIn or X. If this guide saved you an audit finding, a star on a repo or a follow here helps more people find it. And if you've run SQL Developer on Temurin on Windows or Linux, tell me how it went in the comments.


References

Top comments (0)