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
- First install the tools needed to use PPA. sudo apt-get install software-properties-common
- 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
- 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
- Install unzip
- 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
- 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.
- 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).
- Create a new vm in your hypervisor of choice, and mount the iso you downloaded.
- Configure eth0, bring it up and for quicker deployment, run dhclient
- 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.
- Edit your hosts file
- Unzip the rpm
- Install the rpm
- Add iptables rule
iptables -A INPUT -i eth0 -p tcp --dport 8080 -j ACCEPT
- Connect via a browser :8080/apex/apex_admin login using admin and the password you set during configure
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.