I am currently empoyed to develop/maintain commercial software that is deployed on Oracle Database Enterprise Edition. However, to streamline my day-to-day activities, I’m using Oracle Database Express Edition (XE) in development.
Being somewhat lighter than its peer editions, XE is better suited to a desktop environment and I’ve managed to get it running in a memory constrained VMware Virtual Machine running Ubuntu GNU/Linux 8.04 (Hardy Heron) with 768mb RAM. It is not, however, what one would call a light-weight database and does require a few tweaks to get it to compensate for an environment where resources are scarce.
I’ve started a wiki page that details the various problems that I have encountered, and the solutions that I’ve found. As I encounter issues I’ll post updates in the form of comments.
ORA-12519: TNS:no appropriate service handler found
ORA-03136: inbound connection timed out
TNS-12535 TNS:operation timed out