Install Oracle XE

# add i386 architecture on 64bit
dpkg --add-architecture i386
apt-get update
 
apt-get install libc6-i386
 
# download
wget -q http://oss.oracle.com/debian/dists/unstable/main/binary-i386/libaio_0.3.104-1_i386.deb -P /tmp
wget -q 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
dpkg -i /tmp/libaio_0.3.104-1_i386.deb /tmp/oracle-xe_10.2.0.1-1.1_i386.deb
 
# create systemd service (on Ubuntu 20.04)
cat <<EOF> /etc/systemd/system/oracle-xe10.service
[Unit]
Description=oracle-xe
 
[Service]
Type=simple
RemainAfterExit=yes
ExecStart=/etc/init.d/oracle-xe start
ExecStop=/etc/init.d/oracle-xe stop
ExecReload=/etc/init.d/oracle-xe restart
 
[Install]
WantedBy=multi-user.target
EOF
 
systemctl daemon-reload
systemctl enable oracle-xe10
 
 
cat <<EOF> /etc/profile.d/oracle.sh
#!/bin/bash
 
export ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
#export ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe
export ORACLE_SID=XE
export PATH=\$PATH:\$ORACLE_HOME/bin
EOF
 
chmod a+x /etc/profile.d/oracle.sh
 
 
# 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
 
 
# oracle directory path
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server

#!/bin/bash

# install required applications
apt-get install -y wget apt-transport-https bc

# add oracle repository
wget http://oss.oracle.com/el4/RPM-GPG-KEY-oracle -O- | apt-key add -
echo "deb https://oss.oracle.com/debian unstable main non-free" > /etc/apt/sources.list.d/oracle.list
 
# update repository
apt-get update

# configure kernel parameter
sysctl -w kernel.shmmax=4294967295
sysctl -w kernel.shmall=2097152
 
# install oracle
apt-get install -y --force-yes oracle-xe

# configure profile
cat < /etc/profile.d/oracle.sh
#!/bin/bash

export ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
#export ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe
export ORACLE_SID=XE
export PATH=\$PATH:\$ORACLE_HOME/bin
EOF

chmod a+x /etc/profile.d/oracle.sh
>

lxc launch images:oracle/7 oracle7