Oracle Linux 8.7 , Database 23c Free-developer , Apex 22.2 , Ords 23.1

1. oracle DB server build.

oracle database 23c free developer
cdb - FREE
pdb - FREEPDB1

oracle linux 8.7
su
dnf update
dnf install java-11
oracle database download
dnf -y install oracle-database-preinstall-23c
dnf -y install oracle-database-free-23c
/etc/init.d/oracle-free-23c configure

su
/etc/profile

export ORACLE_SID=FREE
export ORAENV_ASK=NO
. /opt/oracle/product/23c/dbhomeFree/bin/oraenv

/usr/lib/systemd/systemd-sysv-install enable oracle-free-23c
passwd oracle (oracle acount set password and switch )

pdb parameter check
windows ( DB21c XE C:\app\*****\product\21c\homes\OraDB21Home1\network\admin)

sqlplus / as sysdba

show pdbs

freepdb1 active

2. oracle apex build.

@apexins sysaux sysaux temp /i/

@load_trans japanese

@apxchpwd

alter user apex_public_user identified by lease account unlock;

alter profile default limit password_life_time unlimited;

@apex_rest_config
3. oracle restful ORDS build. 23.1 version

cd /opt/oracle/ords-23.1/bin
./ords --config /opt/oracle/ords-23.1/conf install
static images /opt/oracle/apex/images

export APEX_IMAGES=/opt/oracle/apex/images

#!/bin/bash
export PATH=/usr/sbin:/usr/local/bin:/usr/bin:/usr/local/sbin:$PATH
export ORDS_HOME=/opt/oracle/ords-23.1
export ORDS_CONFIG=/opt/oracle/ords-23.1/conf
export PATH=${ORDS_HOME}/bin:${PATH}
LOGFILE=/home/oracle/scripts/logs/ords-`date +"%Y""%m""%d"`.log
export _JAVA_OPTIONS="-Xms1126M -Xmx1126M"
nohup ${ORDS_HOME}/bin/ords --config ${ORDS_CONFIG} serve ＞＞$LOGFILE 2＞ &1 &
echo "View log file with : tail -f $LOGFILE"

#!/bin/bash
export PATH=/usr/sbin:/usr/local/bin:/usr/bin:/usr/local/sbin:$PATH

mkdir -p ~/scripts/logs
chmod u+x ~/scripts/*.sh

su
/etc/profile
export ORDS_HOME=/opt/oracle/ords-23.1
export ORDS_CONFIG=/opt/oracle/ords-23.1/conf
export _JAVA_OPTIONS="-Xms1126M -Xmx1126M"
export PATH=${ORDS_HOME}/bin:${PATH}
export PATH=$PATH:$JAVA_HOME/bin