Install Oracle XE on Oracle Linux

I wanted to throw this post out for anyone else that is interested in getting Oracle up and running on a vm. This is a quick and dirty method that has been the least path of resistance IMO.

I first tried with Ubuntu 13.05 so I wanted to list everything I had to do in order to get this to work

  1. First install the tools needed to use PPA.  sudo apt-get install software-properties-common
  2. Next visit this site and follow their instructions for installing java http://www.webupd8.org/2012/01/install-oracle-java-jdk-7-in-ubuntu-via.html
  3. I used ftp through ssh in filezilla in order to download oracle and move it to the vm.  I wasn’t able to get the download to initiate using wget
  4. Install unzip
  5. After transferring your files head over to the post Manish Raj has posted at http://meandmyubuntulinux.blogspot.com/2012/05/installing-oracle-11g-r2-express.html
  6. If you receive the ORA-01034 and ORA-27101 errors, google them.  In my case editing my hosts file was enough to get things working.

To be honest, this was a few more motions that I would like to take when setting up a vm, so I started checking doing some research to see what other distributions were being used.  Low and behold, Oracle has a distribution called…Oracle Linux!

I downloaded the image files for their distribution, the install was extremely quick and then all I had to do was follow Alex Nodoboi’s post http://nedoboi.wordpress.com/2011/09/08/install-oracle-express-xe-11gr2-on-oracle-linux-6-1-x64-no-bitmap-index-conversion-on-the-fly/

This time, everything went great; it was quick, easy and win.  I still used filezilla to transfer the file, and I did get the ORA-01034 and ORA-27101 errors after the config, but editing the hosts file took care of them.  For a dedicated Oracle test box, I will stick with Oracle Linux.

  1. Obtain Oracle linux https://edelivery.oracle.com/linux .  Click the latest version (usually the package at the top and get to downloading what you gon’ need.  I downloaded Oracle Linux Release 6 Update 5 for x86_64 (64 bit).
  2. Create a new vm in your hypervisor of choice, and mount the iso you downloaded.
  3. Configure eth0, bring it up and for quicker deployment, run dhclient
  4. Using filezilla, upload the oracle express rpm (or however you want to get it over to the oracle linux vm).  I used filezilla sftp interactive and it worked fine.
  5. Edit your hosts file
  6. Unzip the rpm
  7. Install the rpm
  8. Configure
  9. Add iptables rule iptables -A INPUT -i eth0 -p tcp --dport 8080 -j ACCEPT
  10. Connect via a browser :8080/apex/apex_admin  login using admin and the password you set during configure
iptable reference

iptable reference

Oracle Apex Admin Login

Oracle Apex Admin Login

There are tips for hardening the OS at http://www.oracle.com/technetwork/articles/servers-storage-admin/tips-harden-oracle-linux-1695888.html

Installing on Windows was pretty much like every single other windows install.  Next, next, next, next, stuff, finish.  It was brainless and took no time at all.  I guess licensing costs for the OS do have their advantages, but for most of my clients that wan’t to use Oracle, they go with a nix based solution.

Leave a Reply

Your email address will not be published. Required fields are marked *