After many months and many attempts, I have managed to install a database on a non-windows platform. I think I deserve a little credit. ;)
In January, I began installing Ubuntu Intrepid Ibex on all of my home computers. What this meant for me is that I was often without one because I screwed something up. I even got so far as to install Oracle XE on Ubuntu which took 2 blog posts.
Just before COLLABORATE 09, I installed Jaunty Jackalope on my laptop. Then I got the crazy idea to install Oracle on Ubuntu. I ended up having to wipe the hard drive and start fresh. I have no doubt that it (Oracle) can be installed on Ubuntu, it just takes someone much more experienced than I.
Armed with a fresh install, I was going the virtual route. Inspired, I believe, by this comment (Aman Sharma).
2. Download the latest version of Oracle Enterprise Linux (v5)
I think that's the point I realized my first installation of Jaunty was hosed, and by hosed I mean unrecoverable by me. I couldn't see the 2nd partition, the one with all the room.
3. Create OEL virtual machine
4. Follow this guide to get it ready to install the Oracle database (seriously? Why does OEL not come ready for the database server?)
4a. There's no mention of opening up the firewall in that article. It's probably obvious to most...
5. Connect to Oracle from the host machine
6. ApEx? Which version am I running? 3.0? That won't do. Download ApEx 3.2
7. Install ApEx
8. Configure Embedded PL/SQL Gateway for port 80
8a. Ports below 1024 are reserved for privileged processes...Configure Embedded PL/SQL Gateway for port 8080
9. Connect from host machine.
9a. Login to ApEx.