Arch Linux User Repository

This worked like a charm. Thanks a lot @mariansam!

@gtarch I had the same problem when using JDK 25. Use the command sudo archlinux-java set java-17-openjdk to switch JDK 17 (installed as a dependency), check by archlinux-java status

sqldeveloper fails to start with the following error:

OpenJDK 64-Bit Server VM warning: Options -Xverify:none and -noverify were deprecated in JDK 13 and will likely be removed in a future release.
Error occurred during initialization of VM
java.lang.Error: A command line option has attempted to allow or enable the Security Manager. Enabling a Security Manager is not supported.
    at java.lang.System.initPhase3(java.base@25.0.1/System.java:1969)

23.1.1+ have problems to connect over ssh, use 23.1.0 if you have problems! according to oracle support its still not fixed.

I couldn't download the no-jre.zip from Oracle (my login credentials where denied, trying to create a new account didn't result in me receiving the required confirmation mail) - but I found a copy of "sqldeveloper-23.1.0.097.1607.noarch.rpm" here: https://www.fileeagle.com/software/2784/Oracle-SQL-Developer/23.1/

I managed to use that rpm package instead of the zip archive by adapting the PKGBUILD file like this:

diff --git a/PKGBUILD b/PKGBUILD
index 535ab4e..020fccb 100644
--- a/PKGBUILD
+++ b/PKGBUILD
@@ -22,28 +22,28 @@ optdepends=(
 )
 install="${pkgname}.install"
 source=(
-  "manual://${pkgname#oracle-}-${pkgver}-no-jre.zip"
+  "manual://${pkgname#oracle-}-${pkgver}-noarch.rpm"
   "${pkgname}.desktop"
   "${pkgname}.sh"
   "LICENSE"
   "java_home.patch"
 )
 md5sums=(
-  "b191ae7b67149045ec384e2a8add4ad1"
+  "cf3ce5702e08babbd3f17400a9a57249"
   "1d17d18e10ab85dead0770e8840273b3"
   "26c1dc933a9ab58a4245f4f351717645"
   "71a4092467209c160d0f34abbc08e049"
   "f732d162c751dc096bbe0e0f96b78754"
 )
 sha1sums=(
-  "e20967b34f4db1b1395deb10cfd9fe61031a3e11"
+  "cef98eb24bad6fa9a69f3467f618a2b611f2d6c0"
   "056bef8e3caa25e62c1395346c34f8a83c532aa8"
   "f33177179a2c6ea8b3fa8db5465dc36cf4317b1b"
   "524dfbd8baf17e348d529a831abf639029c56c7b"
   "f78dd599d2804dedabccf6e1746aa9bb27c2b7ee"
 )
 sha256sums=(
-  "5cb6d77e62b4856255e6b3a6fe3afa876a9af6f1f3c560ceb1b5c7d6532bddc5"
+  "66f825fba46f1e39c6062c7186414f6cb763d2894fd19cbc06b1664b1b72b647"
   "bd028a137c83ab3698a562e9a7ec4006fb396178ab4a6ebdbaa60c75b5c0974c"
   "43b16049fbf85740767c45f0387a7c5e6118b8876509a8f0bb621ed0b5576a25"
   "7b3a6fd8a1ade4427382ee36dc28432655902a0a68547b29c5ce089bd85fe3de"
@@ -51,12 +51,12 @@ sha256sums=(
 )

 prepare() {
-  cd "${srcdir}/${pkgname#oracle-}"
+  cd "${srcdir}/opt/${pkgname#oracle-}"
   patch -Np1 -i "${srcdir}/java_home.patch"
 }

 package() {
-  cd "${srcdir}/${pkgname#oracle-}"
+  cd "${srcdir}/opt/${pkgname#oracle-}"

   find . \( -iname "*.exe" -o -iname "*.dll" \) -exec rm -f "{}" +
   find . -type f -exec install -Dm644 "{}" "${pkgdir}/opt/${pkgname}/{}" \;

I couldn't get this to run as it kept coming up with this error:

java.lang.UnsatisfiedLinkError: /usr/lib/jvm/java-11-openjdk/lib/libnio.so: /usr/lib/jvm/java-11-openjdk/lib/libnio.so: undefined symbol: reuseport_available

For me, the fix was to add these to lines to /usr/bin/oracle-sqldeveloper just above the exec line:

export JAVA_HOME=/usr/lib/jvm/java-11-openjdk
export LD_LIBRARY_PATH=/usr/lib/jvm/java-11-openjdk/lib/server:/usr/lib/jvm/java-11-openjdk/lib

@s3rj1k nope, oracle-sqldeveloper.install file is right there and it's working in both, arch-chroot environment and using yay.

==> ERROR: install file (oracle-sqldeveloper.install) does not exist or is not a regular file.

I guess this PKGBUILD is missing .install file :)

following steps from @bj-pieri worked fine for me.

@nettnikl

after running

yay -S oracle-sqldeveloper

there was no folder created in ~/.cache/yay/oracle-sqldeveloper

I created it manually and pasted the sqldeveloper-*-no-jre.zip file there

after rerunning yay still the older version is reinstalled:

$ yay -S oracle-sqldeveloper
warning: oracle-sqldeveloper-19.1.0.094.2042-1 is up to date -- reinstalling
resolving dependencies...
looking for conflicting packages...

Packages (1) oracle-sqldeveloper-19.1.0.094.2042-1

any tips how to force yay to use the version from cache?

For users of yay, the commands, ready for copy and paste looks like the following (ymmv):

yay -S oracle-sqldeveloper
cp ~/Downloads/sqldeveloper-*-no-jre.zip ~/.cache/yay/oracle-sqldeveloper/
yay -S oracle-sqldeveloper