Friday, November 1, 2013

Oracle SQLDeveloper 4 on Debian/Ubuntu/Mint

Oracle SQLDeveloper is one of those tools you just kind of need around, but with its slew of bugs around so once its setup, you try not to touch it. Occasionally, Oracle releases a new version (or an early preview) with some of the bugs fixed and this appears to be the case with version 4 Early Preview.

Unfortunately, these early previews are no longer distributed as general gzip archives to work on any Linux/Mac distro, there's only a RedHat RPM installer for the Linux platform. Thankfully, this is easy to fix using the utility we known and love as Alien.

Conversion of RPM to DEB

Start by ensuring you have the Alien utility installed.

~$ sudo apt-get install alien

Then after downloading the RPM package from Oracle, run it through the alien utility.

~$ sudo alien sqldeveloper-
Warning: Skipping conversion of scripts in package sqldeveloper: postinst
Warning: Use the --scripts parameter to include the scripts.
sqldeveloper_4. generated

Great, now we have a Debian package. Let's continue to install this one.

~$ sudo dpkg -i sqldeveloper_4.
Selecting previously unselected package sqldeveloper.
(Reading database ... 571042 files and directories currently installed.)
Unpacking sqldeveloper (from sqldeveloper_4. ...
Setting up sqldeveloper ( ...

That was it, we have now installed the latest early release of SQLDeveloper no thanks to Oracle.