I recently upgraded to Ubuntu 14.04 (using Update Manager), and it works fine with no issues.
In which I am using SQL Developer 3.2.20.09 and it works fine. Now a newer version was released on May 5th 2014, and I would like to use it, as it works fine with JDK 1.7. I followed the installation instructions provided by Oracle, but it fails to install.
Downloaded sqldeveloper-4.0.2.15.21-1.noarch.rpm from
Followed installation instructions from using the command:
rpm -Uhv sqldeveloper-4.0.2.15.21-1.noarch.rpmwhich resulted in:
rpm: RPM should not be used directly install RPM packages, use Alien instead! rpm: However assuming you know what you are doing... error: Failed dependencies: /bin/sh is needed by sqldeveloper-4.0.1.14.48-1.noarchUsed Alien to install the RPM package:
sudo alien sqldeveloper-4.0.1.14.48-1.noarch.rpmwhich resulted in this error:
error: db5 error(-30969) from dbenv->open: BDB0091 DB_VERSION_MISMATCH: Database environment version mismatch error: cannot open Packages index using db5 - (-30969) error: cannot open Packages database in /home/arthanarisamy/.rpmdb
Should any package be updated manually, or have I missed updating while upgrading to Ubuntu 14.04?
44 Answers
You should first convert .rpm file to .deb which is the installation file format in ubuntu.
sudo alien -d sqldeveloper-4.0.2.15.21-1.noarch.rpmThen install that .deb file by :
sudo dpkg -i sqldeveloper-4.0.2.15.21-1.noarch.deb 2 I don't like using converted RPM for installation in Ubuntu, if there is an alternative.
I prefer manually using a binary package, specially with Java applications that usually does not have specific dependency (obviously JRE / JDK).
In this case, I install SQLDeveloper in this way:
- download the "Other Platforms" package: sqldeveloper-4.0.2.15.21-no-jre.zip
- unzip the package in /opt/sqldeveloper (or other directory if you like, I put all manually installed packages in /opt)
- create a sqldeveloper.desktop file in /usr/share/applications (for all users) or ~/.local/share/applications (for your user only)
For me while rpm was not installed when I double click on the document it extracts it and I was able to run sqldeveloper by running /opt/sqldeveloper/sqldeveloper.sh bash file
The error: db5 error(-30969) from dbenv->open: BDB0091 DB_VERSION_MISMATCH: Database environment version mismatch error happens the first time you run rpm (or alien) on Ubuntu.
Create the RPM DB with:
sudo rpm --rebuilddbto get rid of it.