sudo nano /sbin/chkconfig 

#!/bin/bash
# Oracle 11gR2 XE installer chkconfig hack for Ubuntu
file=/etc/init.d/oracle-xe
if [[ ! `tail -n1 $file | grep INIT` ]]; then
echo >> $file
echo '### BEGIN INIT INFO' >> $file
echo '# Provides: OracleXE' >> $file
echo '# Required-Start: $remote_fs $syslog' >> $file
echo '# Required-Stop: $remote_fs $syslog' >> $file
echo '# Default-Start: 2 3 4 5' >> $file
echo '# Default-Stop: 0 1 6' >> $file
echo '# Short-Description: Oracle 11g Express Edition' >> $file
echo '### END INIT INFO' >> $file
fi
update-rc.d oracle-xe defaults 80 01 

sudo chmod 755 /sbin/chkconfig 

sudo nano /etc/sysctl.d/60-oracle.conf 

# Oracle 11g XE kernel parameters  
fs.file-max=6815744  
net.ipv4.ip_local_port_range=9000 65000  
kernel.sem=250 32000 100 128 
kernel.shmmax=536870912 

sudo service procps start 

sudo sysctl -q fs.file-max 

sudo nano /etc/rc2.d/S01shm_load 

#!/bin/sh
case "$1" in
start) mkdir /var/lock/subsys 2>/dev/null
       touch /var/lock/subsys/listener
       rm /dev/shm 2>/dev/null
       mkdir /dev/shm 2>/dev/null
       mount -t tmpfs shmfs -o size=2048m /dev/shm ;;
*) echo error
   exit 1 ;;
esac 

sudo chmod 755 /etc/rc2.d/S01shm_load 

reboot 

cd /tmp
wget https://github.com/duanzhichao/ubuntu2004-oracle11g/releases/download/deb/oracle-xe_11.2.0-2_amd64.deb
sudo dpkg --install oracle-xe_11.2.0-2_amd64.deb 

Specify the HTTP port that will be used for Oracle Application Express [8080]:
 
# 定义HTTP网站管理的端口，默认直接回车
 
Specify a port that will be used for the database listener [1521]:
 
# 定义数据库监听的端口，默认直接回车
 
Specify a password to be used for database accounts.  Note that the same
password will be used for SYS and SYSTEM.  Oracle recommends the use of 
different passwords for each database account.  This can be done after 
initial configuration:
Confirm the password:
 
# 要求你设置系统账号SYS的SYSTEM的密码
 
Do you want Oracle Database 11g Express Edition to be started on boot (y/n) [y]:y
 
# 询问是否设置数据库开机启动启动，默认是开机启动，直接回车
# 成功的话终端输出以下内容
Starting Oracle Net Listener...Done
Configuring database...Done
Starting Oracle Database 11g Express Edition instance...Done
Installation completed successfully. 

sudo nano /etc/profile 

# Oracle Settings
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.2.0/xe; export ORACLE_HOME
ORACLE_SID=XE; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM
PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$PATH; export PATH
TNS_ADMIN=$ORACLE_HOME/network/admin
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH
if [ $USER = "oracle" ]; then
  if [ $SHELL = "/bin/ksh" ]; then
    ulimit -p 16384
    ulimit -n 65536
  else
    ulimit -u 16384 -n 65536
  fi
fi 

sudo source /etc/profile 

sudo systemctl start oracle-xe
sudo systemctl status oracle-xe # 下面是正常运行的结果 ● oracle-xe.service - LSB: Oracle 11g Express Edition Loaded: loaded (/etc/init.d/oracle-xe; generated) Active: active (exited) since Sun 2024-04-28 16:02:02 CST; 27min ago Docs: man:systemd-sysv-generator(8) Process: 803 ExecStart=/etc/init.d/oracle-xe start (code=exited, status=0/SUCCESS) CPU: 61ms

cd /u01/app/oracle/product/11.2.0/xe/ wget https://github.com/duanzhichao/ubuntu2004-oracle11g/releases/download/apex41/apex_4.1.zip # or wget https://github.com/duanzhichao/ubuntu2004-oracle11g/releases/download/apex42/apex_4.2.2.zip 

解压apex

mv ./apex ./apex_old
unzip apex_xxx.zip
mv apex_xxx ./apex 

安装apex

cd apex
sqlplus / as sysdba
connect / as sysdba
SQL> @apexins SYSAUX SYSAUX TEMP /i/ 

设置静态资源

sqlplus / as sysdba
connect / as sysdba
SQL> @apex_epg_config /u01/app/oracle/product/11.2.0/xe/ 

汉化apex

NLS_LANG=American_America.AL32UTF8
export NLS_LANG
echo $NLS_LANG
cd builder/zh-cn
sqlplus / as sysdba
connect / as sysdba
SQL>  @load_zh-cn.sql 

更新密码

SQL> @apxchpwd 
SQL> alter user apex_public_user account unlock; SQL> alter user apex_public_user identified by 123; # 如果4.1, APEX_040100; 如果4.2, APEX_040200 SQL> alter session set current_schema = APEX_040200;