Oracle 10g Standard Edition on Ubuntu

I've been using Oracle XE on Ubuntu 6.06 (installed from http://oss.oracle.com/debian). It works fine. However, I was trying to create a database from scripts provided to me that assumed Oracle Managed Files were supported.

That is, the scripts attempted to create a tablespace without explicitly naming the datafile.

This failed on XE. I figured I could install Oracle 10g Standard Edition. However, the installer wouldn't even run. It fails after performing a distribution check.

You can workaround this issue with the following command to run the installer:

./runInstaller -ignoreSysPrereqs

The only other issue I encountered is documented here:
http://forums.oracle.com/forums/thread.jspa?threadID=413032&tstart=0

Make sure that you either remove Oracle XE or override $ORACLE_HOME to point to your new Oracle home before executing those commands.

This also seems to be a good reference http://www.dizwell.com/prod/node/52