Oracle SQL Developer Debian Package
Oracle SQL Developer is a Java-based tool that provides a graphical interface to a database. While it’s main focus is Oracle (of course), it can be hooked up, via JDBC, to many other databases, such as MySQL, PostgreSQL, and SQL Server. It’s similar to Toad, but is provided by Oracle at no cost.
Oracle provides SQL Developer in either an RPM, or a generic binary install. I like the ability to manage packages, but I’ve never had much luck at getting RPM to run on Ubuntu. I downloaded the RPM file, and, using alien, I converted the package to a .deb package (Debian package format) and installed it. I worked like a charm!
I haven’t tested it with gcj, but using Sun’s Java 6 update 7 from the Ubuntu repositories, it ran just fine. After you install the package, do a directory list on /usr/lib/jvm. You’re looking for the Sun JDK – if it’s installed, you’ll have a symlink java-6-sun that points to java-6-sun-1.6.0.07. Once you’ve determined the location of the JDK, run “sqldeveloper” from the command line – the program will prompt you for the path to your JDK. Enter it (probably “/usr/lib/jvm/java-6-sun”) and you’re good to go. (You have to install the package as root – but, for the rest of these steps, use your normal user, not root, as this puts settings in a .sqldeveloper directory off your home directory.) The package installs an icon in the “Programming” or “Development” group. Once you’ve told it where the JDK is, you can use this to launch it.
Oracle Debian batean instalazioa « irakasle ibiltaria said,
December 12, 2008 at 2:16 am
[...] batean instalatzeko: RPM moduan dagoenez, .DEB batetara pasa behar dugu alien agindua erabiliz. hemen azaltzen du nola. Gune berean .deb bat jaisteko aukera ere ematan du. Toad Aplikazio interesgarri [...]
Ameed Jamous said,
December 23, 2008 at 3:51 pm
Dear Daniel,
Can SQL Developer Debian package connect Oracle 10g express edition to MySQL Cataloge and import tables and schema.
Ameed Jamous said,
December 23, 2008 at 8:11 pm
I have running Oracle DB Express edition and am unable to make a valid connection with SQL Developer to database , can you please help?
Daniel said,
December 24, 2008 at 8:54 am
I’m not sure about the migration between MySQL and Oracle – I haven’t tried that. As far as the connection, do you have a TNSNAMES.ORA file set up with the connection ID? I’ll check with a DBA I know and see the exact syntax for an Oracle XE connection – I’m guessing this is running on the same computer?
Daniel said,
December 24, 2008 at 10:48 am
Here’s a sample TNSNAMES.ORA entry for Oracle XE running on the local machine…
ORADB = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) ) (CONNECT_DATA = (SERVCE_NAME = XE) (FAILOVER_MODE = (TYPE = SELECT) (METHOD = BASIC) (RETRIES=100) (DELAY=1)) ) )mb said,
January 15, 2009 at 4:44 am
http://fucinatecnica.blogspot.com/2009/01/install-oracle-sql-developer-on-ubuntu.html
to resolve your problem on Ubuntu Installation (doesn’t appear window gui)
piotr said,
March 24, 2010 at 5:03 am
you have a new fan
this is what was missing in “debian” I can finally stop working in VM (XP) with toad! Thanks!