- Download oracle-xe_10.2.0.1-1.0_i386.deb
su - root
dpkg -i oracle-xe_10.2.0.1-1.0_i386.deb
It ran for maybe thirty seconds - so short, I was certain there had been an error!
/etc/init.d/oracle-xe configure(it told me to do that)
- pointed Firefox at http://127.0.0.1:8080/apex (it requested that, too)
- Started using the database (plus its included Application Express).
The only glitches I've gotten so far were when using Python's cx_Oracle against XE, and I've puzzled them out. (I don't know whether other people will get these glitches; they could have resulted from some residue of the full-fledged 10.2 Oracle that was on the machine before.)
import cx_Oraclegave ImportError: libclntsh.so.10.1: cannot open shared object file: No such file or directory until I set LD_LIBRARY_PATH=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/
conn = cx_Oracle.Connection('scott/tiger@xe')gave RuntimeError: Unable to acquire Oracle environment handle until I set ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
[EDIT Oct. 9, 2007: Configuring cx_Oracle with Oracle XE has turned out to be harder than expected. See my new blog post.]
[EDIT Mar. 6, 2008: Great instructions for installing straight from Oracle's repository with apt-get here]