Install Oracle XE

# new version:
https://raw.githubusercontent.com/panticz/installit/master/install.oracle-xe.sh
 
# fix
W: GPG error: https://oss.oracle.com unstable Release: The following signatures were invalid: KEYEXPIRED 1378511808 KEYEXPIRED 1378511808 KEYEXPIRED 1378511808
 
 
 
# add oracle repository
wget http://oss.oracle.com/el4/RPM-GPG-KEY-oracle -O- | apt-key add -
cat <<EOF> /etc/apt/sources.list.d/oracle.list
deb http://oss.oracle.com/debian unstable main non-free
EOF
 
# update repository
apt-get update
 
# install oracle
apt-get install -y oracle-xe
 
# configure
/etc/init.d/oracle-xe configure
 
# enable web acces from non localhost
# export ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe
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
 
 
# test
# install on 64bit (test)
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
 
# oracle directory path
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
 
# 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.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
https://forums.oracle.com/forums/thread.jspa?threadID=2301639 - HowTo: Install Oracle XE 11 on Debian