I successfully installed Oracle 10g Express Edition on Ubuntu yesterday. I have listed the steps I followed to install this. It’s pretty simple. The download took around 25 mins and installation took less than 5 minutes on my dual core laptop.
Steps to install:
- sudo apt-get install gcc make binutils lesstif2 libc6 libc6-dev rpm libmotif3 libaio libstdc++5
- sudo gedit /etc/apt/sources.list and add this line at the end. deb http://oss.oracle.com/debian unstable main non-free
- sudo apt-get update
- If you get the error “W: GPG error: http://oss.oracle.com unstable Release: The following signatures couldn’t be verified because the public key is not available: NO_PUBKEY 2E2BCDBCB38A8516″ then do steps 5 to 7
- wget http://oss.oracle.com/el4/RPM-GPG-KEY-oracle press enter
- sudo apt-key add RPM-GPG-KEY-oracle press enter
- sudo apt-get update
- sudo apt-get install oracle-xe
- After the installation is done, issue this command /etc/init.d/oracle-xe configure. Keep pressing ENTER to take the default. Select yes for booting when Ubuntu boots (if you want) else select no. It’ll take sometime for the system to configure the database. Wait till it’s done.
You are done. You’ll see a menu Oracle Database 10g Express Edition under Applications (Kubuntu screenshot – Similar for Ubuntu. I did it in Ubuntu, but I didn’t take the screenshot). I’m now happy that I need not boot into Windows to use Oracle. I don’t use Windows except for video conferencing. Video conferencing is still shaky in Linux.
Sites you can refer if you encounter any problem: Oracle.com and Ubuntu Wiki. I didn’t follow any of the steps mentioned in those sites except the ones I have listed above. There is no need to create dba group etc as given in the wiki.
I then downloaded SQL Developer and unzipped it. It created a directory called sqldeveloper. I then issued the following command from that directory:
sh sqldeveloper
It said it couldn’t find JDK 1.5 and asked me to enter the path. I have installed Blackdown Java already, but it didn’t take that. I then downloaded JDK 5 Update 6 and installed it with the following steps:
- sudo apt-get install fakeroot java-package (If you haven’t installed them already)
- fakeroot make-jpkg jdk-1_5_0_06-linux-i586.bin
- sudo dpkg -i jdk-1_5_0_06-linux-i586.bin
I then gave the path of the jdk folder. It took the path and errored out while trying to start the SQL Developer. I have listed the error below:
Unable to find configuration file: jdk.conf
Type the full pathname of a J2SE installation (or Ctrl-C to quit), the path will be stored in ~/.sqldeveloper_jdk
/usr/lib/j2se/1.4
Working directory is /home/arun/sqldeveloper/jdev/bin
Exception in thread “main” java.lang.NullPointerException
at java.util.Hashtable.get(Hashtable.java:333)
at java.util.logging.LogManager.getLogger(LogManager.java:437)
at java.util.logging.Logger.getLogger (Logger.java:228)
at oracle.ide.performance.PerformanceLogger.(PerformanceLogger.java:64)
at oracle.ide.performance.PerformanceLogger.get(PerformanceLogger.java:94)
at oracle.ideimpl.Main.main (Main.java:21)
I’m not sure how to fix this error. I don’t know if it’s caused by Blackdown Java installation (multiple java path). I even tried exporting the path, but it didn’t work. I’m stuck on that. I have to do some more googling and find out.
Update: You need to add your username to the dba group. I forgot to mention it in the steps above. Go to System – Adminstration – Users and Groups. Go to Groups tab and select dba from the left pane. Click on properties (or edit) and add your user name to that group. You need this if you want to manually start and shutdown the database. If you have selected start database while starting Ubuntu, then you may not need this step.
Thanks for your answer.
sqldeveloper is required java 1.5.
For those who got ubuntu with java from sun microsystems…
in my case, the full path was /usr/lib/jvm/java-6-sun-1.6.0.16/
Taghi,
I think the problem is due to dependency error. I haven’t tried installing this in Ubuntu 9.04. Even http://www.oracle.com/technology/tech/linux/install/xe-on-kubuntu.html and https://help.ubuntu.com/community/Oracle10g were not updated. Did you check those sites?
Hi Arun,
Thanks for your replying. Yes , I try to starting. There is an instruction which is called “Oracle® Database Express Edition Getting Started Guide
10g Release 2 (10.2) “.
First step of the instruction is point out Go To Database Home Page. At this point I got a HTML error page which is telling “The requested URL /apex was not found on this server.” So, I don’t know how it should be resolved.
Thanks
If you see Oracle 10g express edition in the menu, then I think it got installed. Did you try starting it?
Hi buddy,
My OS is Ubunto.
I have confused, I download Oracle 10g( oracle-xe-10.2.0.1-1.0.i386.rpm and oracle-xe-universal_10.2.0.1-1.0_i386.deb) then I tried to run the first step of givien instruction for installation(# sudo apt-get install gcc make binutils lesstif2 libc6 libc6-dev rpm libmotif3 libaio libstdc++5), it does not worked. then I click on the ( oracle-xe-universal_10.2.0.1-1.0_i386.deb) file it executed and I point-out on Applications I have >Oracle Database 10g Express Edition
I’m not sure if I’m right or not, so anyone has a same problem or point to help me?
Thanks,
Taghi
Thank you for the solution Guille. I haven’t tried using SQL Developer in Ubuntu recently. I have to do that soon.
I’ve found an easier solution.
which java
/usr/lib/java/bin/java
The pathname is -> /usr/lib/java
Type the full pathname of a J2SE installation (or Ctrl-C to quit), the path will be stored in ~/.sqldeveloper_jdk
/usr/lib/java
After error message, add to the file “sqldeveloper.conf” (you can find it with command “sudo find / -name sqldeveloper.conf”)
SetSkipJ2SDKCheck true
Thanks a lot.
Everything worked like you said.
Sure. Thanks.
no problem. hopefully the comment will be useful to people who come across your post via google (as I did).
Thanks for the info Cristobal. I didn’t install Oracle after I upgraded to Ubuntu Gutsy.
Thanks for this writeup.
> Type the full pathname of a J2SE installation (or Ctrl-C to quit)
This is a problem with your /etc/alternatives symlinks. Try looking in that directory to see what, if any, symlinks you have for java, java_vm, etc.
Once you’ve gotten that squared away, you may see it error out with something like ‘java Assertion `c->xlib.lock’ failed’. If so, try the fix recommended here, adjusting the path to libmawt.so as necessary
I’ll give it a try. Thanks.
Download the “Linux (self-extracting file)
Copy it to /usr/java/
sudo chmod a+x jre-1_5_0_08-linux-i586.bin
sudo ./jre-1_5_0_08-linux-i586.bin
sh sqldeveloper
Oracle SQL Developer 1.0
Copyright (c) 2005 Oracle Corporation. All Rights Reserved.
Type the full pathname of a J2SE installation (or Ctrl-C to quit), the path will be stored in ~/.sqldeveloper_jdk
/usr/java/jdk1.5.0_08/
This works!
wildlionpaws
Pingback: Un dia duro
Pingback: Alpha-Geek.com
Pingback: Jeremy Smith's blog