{"id":708,"date":"2010-01-09T16:40:48","date_gmt":"2010-01-09T20:40:48","guid":{"rendered":"http:\/\/timony.com\/mickzblog\/?p=708"},"modified":"2010-01-09T16:40:48","modified_gmt":"2010-01-09T20:40:48","slug":"install-oracle-sql-developer-on-ubuntu-karmic","status":"publish","type":"post","link":"http:\/\/timony.com\/mickzblog\/2010\/01\/09\/install-oracle-sql-developer-on-ubuntu-karmic\/","title":{"rendered":"Install Oracle SQL Developer on Ubuntu Karmic & Lucid"},"content":{"rendered":"

If you want to install Oracle’s SQL Developer<\/a> on Ubuntu (or another DEB based system such as Debian) you can do one of the following:<\/p>\n

    \n
  1. Download the RPM package and install using rpm (not advisable).<\/li>\n
  2. Download the RPM package and convert to a DEB package using alien<\/li>\n
  3. Download the ZIP file titled “Oracle SQL Developer for other platforms” and manually install<\/li>\n
  4. Use the make-sqldeveloper-package to convert the ZIP file into a DEB package<\/li>\n<\/ol>\n

    I used the make-sqldeveloper-package, which is available for Debian and Ubuntu and it’s derivatives. However, the man page and the instructions are little unclear on how to use it. You need to download the zip file available at Oracle’s<\/a> (and not the RPM file nor any of the other packages) and then use the make-sqldeveloper-package to convert it to a DEB which you can then install using the dpkg command.<\/p>\n

    This is preferable to using rpm or alien as you can more easily manage the package using Debian’s and Ubuntu package management tools, plus it will integrate SQL Developer into Gnome’s Menu System . Plus, when Oracle updates their version you can use make-sqldeveloper-package to create an updated DEB package and easily update the version you have installed. The procedure outlined below works on Ubuntu Karmic and should also work on any Debian version that has the make-sqldeveloper-package.<\/p>\n

    As the man page states:<\/p>\n

    This utility will require you to download the “Oracle\u00a0 SQL\u00a0 Developer\u00a0 for\u00a0 other\u00a0 platforms”\u00a0 archive\u00a0 from\u00a0 <http:\/\/otn.oracle.com\/software\/prod\u2010ucts\/sql\/<\/a>> to create the Debian package from.<\/p><\/blockquote>\n

    1. Download the ZIP file from Oracle’s site<\/h4>\n

    You will need to accept Oracle’s license agreement and download the ZIP file, titled “Oracle SQL Developer for other platforms”, from:<\/p>\n

    http:\/\/www.oracle.com\/technology\/software\/products\/sql\/index.html<\/a><\/p>\n

    2. Install the make-sqldeveloper-package package<\/h4>\n
    sudo apt-get install sqldeveloper-package<\/pre>\n
    You will need Ubuntu’s multiverse<\/a> software repository. See the instructions<\/a> on how to do so.<\/p>\n
    2.a. Install the tofrodos package<\/h4>\n
    sudo apt-get install tofrodos<\/pre>\n
    Create symbolic links to the tofrodos commands to allow the sqldeveloper-package to work:<\/p>\n
    sudo ln -s \/usr\/bin\/fromdos \/usr\/bin\/dos2unix<\/pre>\n
    sudo ln -s \/usr\/bin\/todos \/usr\/bin\/unix2dos<\/pre>\n
    Thanks to Miles<\/a> for the tofrodos tip.<\/p>\n
    3. Convert the ZIP file to .DEB package<\/h4>\n
    The format of the command is:<\/p>\n
    make-sqldeveloper-package -b BUILD_LOCATION LOCATION_OF_ZIP_FILE<\/pre>\n
    In my example, I’m going to use \/tmp\/ORA as the build location and the ZIP file has been download to my Desktop (~Desktop).<\/p>\n
    make-sqldeveloper-package -b \/tmp\/ORA\/ ~\/Desktop\/sqldeveloper-2.1.0.63.73-no-jre.zip<\/pre>\n
    The command will create the build directory and remove it when the command finishes. If the command completes successfully you’ll see the following output after a minute or two:<\/p>\n
    make-sqldeveloper-package: Building sqldeveloper package in \"\/tmp\".<\/pre>\n
    The DEB file will be created in the current directory. In my example I had changed directories to \/tmp and that’s where the DEB file will be:<\/p>\n
    \/tmp\/sqldeveloper_2.1.0.63.73+0.2.3-1_all.deb<\/pre>\n
    See the man page for more information about the tool:<\/p>\n
    man make-sqldeveloper-package<\/pre>\n
    4. Install the package<\/h4>\n
    sudo dpkg -i sqldeveloper_2.1.0.63.73+0.2.3-1_all.deb<\/pre>\n
    5. Run SQL Developer<\/h4>\n
    After installing there should he an entry in Gnome’s menu to start the SQL Developer. It’s located under:<\/p>\n
    Applications->Programming->SQL Developer<\/strong><\/p>\n
    Note<\/em>: You will need a JVM installed for the tool to run.<\/p>\n
    Obligatory Screen Shot:<\/p>\n
    \"\"<\/a>
    Oracle SQL Developer<\/figcaption><\/figure>\n
    Updated September 27th 2010<\/em>. Added instructions from Miles<\/a> on installing dos2unix alternative for Ubuntu Lucid. The dos2unix command is not available in Ubuntu Lucid.<\/p>\n","protected":false},"excerpt":{"rendered":"
    If you want to install Oracle’s SQL Developer on Ubuntu (or another DEB based system such as Debian) you can do one of the following: Download the RPM package and install using rpm (not advisable). Download the RPM package and convert to a DEB package using alien Download the ZIP file titled “Oracle SQL Developer … Continue reading Install Oracle SQL Developer on Ubuntu Karmic & Lucid<\/span> →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"footnotes":""},"categories":[51,52,22,62,41],"tags":[190,390,457,502,561,562],"class_list":["post-708","post","type-post","status-publish","format-standard","hentry","category-database-tech","category-debian-linux","category-linux","category-oracle","category-ubuntu-linux-2","tag-debian","tag-linux","tag-oracle","tag-programming","tag-sql","tag-sql-developer"],"_links":{"self":[{"href":"http:\/\/timony.com\/mickzblog\/wp-json\/wp\/v2\/posts\/708","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/timony.com\/mickzblog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/timony.com\/mickzblog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/timony.com\/mickzblog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/timony.com\/mickzblog\/wp-json\/wp\/v2\/comments?post=708"}],"version-history":[{"count":0,"href":"http:\/\/timony.com\/mickzblog\/wp-json\/wp\/v2\/posts\/708\/revisions"}],"wp:attachment":[{"href":"http:\/\/timony.com\/mickzblog\/wp-json\/wp\/v2\/media?parent=708"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/timony.com\/mickzblog\/wp-json\/wp\/v2\/categories?post=708"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/timony.com\/mickzblog\/wp-json\/wp\/v2\/tags?post=708"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}