Install Oracle XE | panticz.de

# 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 < /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 < /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

https://raw.githubusercontent.com/panticz/installit/master/install.oracle-xe.sh

[embed_url: https://raw.githubusercontent.com/panticz/installit/master/install.oracle-xe.sh]

Oracle 18xe

lxc launch images:oracle/7 oracle7

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