Blog Jérôme Witt Oracle SQL Developer & SQL Data Modeler on Ubuntu
dbi services Blog
Welcome to the dbi services Blog! This blog focuses on database infrastructure and middleware topics. It covers technologies such as Oracle, Microsoft SQL Server, MySQL, Sybase, Linux, or Documentum (etc.). The dbi services blog represents the view of our consultants, not necessarily that of dbi services. Feel free to comment on the postings!
Oracle SQL Developer and Data Modeler are becoming more and more popular as they are both cost-free and available on many Operating Systems (Linux/Unix,Windows and Mac) with different installation types: "This zip does not include JRE" or "This zip file includes the JRE". On linux, the choice is limited because the only version available doesn't include Java Runtime Environment. And it's an RPM !! So what... In this post I will provide all information required to install and run these tools on an Ubuntu machine.
My solution was to download the tar.gz archive for Oracle SQL Developer and the Windows version for the Data Modeler.
It contains the binaries for Windows and Linux. Of course without JRE 
After changing the permission to execute the SH scripts, I faced (as the most of you) the following error for both tools:
jew@Biederthal:/opt/datamodeler/datamodeler/bin$ sh /opt/datamodeler/datamodeler.sh
Oracle SQL Developer Data Modeler
Copyright (c) 1997, 2011, Oracle and/or its affiliates. All rights reserved.
Type the full pathname of a J2SE installation (or Ctrl-C to quit), the path will be stored in ~/.datamodeler_jdk
^C
I have the path to my Sun Java executable in my PATH variable... and the version is above of the requirements (JDK 5.0 Update 12). The JAVA requirements are:
java -version
java version "1.6.0_26"
So what does it mean? Oracle believes that you install SQL Developer and/or Data Modeler on the same mount point as Java. Check the files /
SetJavaHome ../../jdk
Replace the entry by your real java installation path, below my installation as I require also SUN Java for Oracle Enterprise Manager Grid Control
SetJavaHome /usr/lib/jvm/java-6-sun/jre
If you want to install the SUN Java on your Ubuntu and also configure it for Firefox, follow my collegue's post.
http://www.dbi-services.com/index.php/blog/entry/configure-firefox-3612-with-ubuntu-for-grid-control-and-my-oracle-support-usage
If the system still complains about JRE, disable the JDK check by adding the following line:
SetSkipJ2SDKCheck true
Et voila 
I wish you a nice time with these tools!
Cheers,
Jérôme
Related Post
- Oracle Cluster 11g R2 listener down - que faire ? Dans un environnement Oracle cluster 11g R2, le listener ne peut pas démarrer avec une erreur sur la définition de nom "locahost" défini dans le fichi...
- Monitoring 11g databases with Grid Control 10.2.0.5 The Metalink note 949858.1 describes problems with 10.2.0.5 agents monitoring 11g databases - this might be the case if you have an "old" 10.2.0.5 Gri...
- How to connect to an Oracle database using the perl DBI module and DBD::Oracle “as sysdba”? Well, I have read many posts about this, but was unable to find a suitable solution up to now … Google was not my friend ...
- Reading Oracle documentation with an ipad - What Steve Jobs doesn't tell! The christmas period is over and it is now time to enjoy the several gifts brought by Santa Claus. Under my Chrismas tree I discovered an iPad this ye...
- Huge Pages and AMM is (not) possible with 11.2.0.2! ! Read the last comment posted below, this information has been fixed in between - Huge Pages is definitively not possible with AMM ! Huge Pages w...
About the author
- Florian Haas' blog
- Dirk Nachbar's blog on Oracle Fusion Middleware & Application Server
- Oracle Scratchpad - Jonathan Lewis' blog
- Martin Bach's blog
- Striving for optimal performance - Chris Antognini's blog
- The Tom Kyte Blog (Ask Tom)
- Blog of Adar-Consult
- Alex Gorbachev's blog
- Marcus Mönnig's Oracle & Mumbai Blog
