Don't worry! It's only stuff...

# install on 32 bit
wget http://oss.oracle.com/el4/RPM-GPG-KEY-oracle  -O- | sudo apt-key add -
cat <<EOF> /etc/apt/sources.list.d/oracle.list
deb http://oss.oracle.com/debian unstable main non-free
EOF
 
apt-get update
apt-get install oracle-xe
 
# install on 64bit
wget http://oss.oracle.com/debian/dists/unstable/main/binary-i386/libaio_0.3.104-1_i386.deb -P /tmp
wget http://oss.oracle.com/debian/dists/unstable/non-free/binary-i386/oracle-xe_10.2.0.1-1.1_i386.deb -P /tmp
 
sudo apt-get install bc
sudo dpkg -i --force-architecture /tmp/libaio_0.3.104-1_i386.deb
sudo dpkg -i --force-architecture /tmp/oracle-xe_10.2.0.1-1.1_i386.deb
 
 
# configure
/etc/init.d/oracle-xe configure
 
 
# enable web acces from non localhost
export ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
export ORACLE_SID=XE
${ORACLE_HOME}/bin/sqlplus /nolog
conn sys as sysdba
EXEC DBMS_XDB.SETLISTENERLOCALACCESS(FALSE);
alter user system account unlock;
quit;
 
 
# post configure
--- config sql ---
-- original settings from oracle 10xe
-- sessions	 49
-- processes 40
-- do we need this?
-- alter system set sessions=100 scope=spfile;
-- alter system set processes=100 scope=spfile;
4_set_size.sql
 
# create user
3_drop_hr.sql
 
# import
export ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
export ORACLE_SID=XE 
${ORACLE_HOME}/bin/imp system/oracle file=export.dmp log=/tmp/imp.log full=y BUFFER=61440
 
 
 
# web access
http://localhost:8080/apex
 
 
# Links
http://www.oracle.com/technology/software/tech/globalization/htdocs/utilsoft.html - Character Set Scanner downloads
http://forums.oracle.com/forums/thread.jspa?messageID=1159075&#1159075
http://www.narfbase.net/114/oracle-xe-goes-debian - Oracle XE and PHP
http://www.oracle.com/technology/software/products/database/xe/files/install.102/b25144/toc.htm - Official Oracle Installation Guide
http://st-curriculum.oracle.com/tutorial/DBXETutorial/index.htm
http://www.oracle.com/technology/tech/linux/install/xe-on-kubuntu.html
http://littlebrain.org/2008/05/12/how-to-install-oracle-xe-in-ubuntu-64-bit/
http://www.panticz.de/node/44