Arch Linux User Repository

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

Just to complement step by step:

1. git clone the current repository [$ git clone https://aur.archlinux.org/oracle-sqldeveloper.git]
2. manually download the no-jre archive from Oracle Site [https://aur.archlinux.org/cgit/aur.git/tree/PKGBUILD?h=oracle-sqldeveloper]
3. copy the zipped file that you already downloaded from Oracle site to the repository cloned on step 1 [cp -r ~/Downloads/sqldeveloper-CURRENT-VERSION ~/oracle-sqldeveloper]
4. run makepkg --install

The package is out of date. I'd like to upgrade PKGBUILD with new version.

There is a nice workaround for packages that rely on login protected oracle sources, as used by

https://aur.archlinux.org/packages/jdk8

where the dependency is searched in the users download directory. That way the user does not have to copy the downloaded file to PKGBUILD directory which is quite nice. Can this be added to this package as well?