Video 3/3 :: Oracle Application Express and ORDS installation in Oracle XE running Oracle Linux
Oracle Rocks !!!
OS : https://www.oracle.com/linux/
Database: https://www.oracle.com/database/technologies/appdev/xe.html
Development: https://apex.oracle.com/en/
REST Middleware: https://www.oracle.com/database/technologies/appdev/rest.html
Video 1/3
Oracle Linux 8.3 Installation in Virtual Box. Foundation for Oracle XE Database + APEX
Video 2/3
Oracle XE Express Edition Installation in Oracle Linux : Oracle APEX Application Express
Helper Blog: https://matthiashoys.wordpress.com/2019/12/12/installation-of-apex-19-2-on-oracle-18c-xe-express-edition/
Video Recording: https://getsharex.com/
Video Editing: https://www.openshot.org/
APEX installation on Linux – Step by Step
su – oracle
lsnrctl status
lsnrctl start
sqlplus /nolog
connect / as sysdba
select user from dual;
startup
select user from dual;
Copy the apex_20.2_en.zip && Unzip
cp apex_20.2_en.zip /opt/
cd /opt
unzip apex_20.2_en.zip
chown -R oracle.oinstall apex
su – oracle
cd /opt/apex
tnsping XE
sqlplus /nolog
conn / as sysdba
select user from dual;
select * from tabs;
show parameter sga_target;
show parameter pga;
select name from v$containers;
alter session set container=XEPDB1;
alter profile DEFAULT limit password_life_time UNLIMITED;
@apexins.sql SYSAUX SYSAUX TEMP /i/
sqlplus /nolog
conn / as sysdba
alter session set container=XEPDB1;
select username from dba_users order by username asc;
sqlplus /nolog
conn / as sysdba
alter session set container=XEPDB1;
@apxchpwd.sql
sqlplus /nolog
conn / as sysdba
alter session set container=XEPDB1;
alter user APEX_PUBLIC_USER account unlock;
alter user APEX_PUBLIC_USER identified by “Apex_2021”;
sqlplus /nolog
conn / as sysdba
alter session set container=XEPDB1;
@apex_rest_config.sql
Add to the ./.bash_profile
export ORACLE_BASE=/opt/oracle
echo $ORACLE_BASE
/opt/oracle
su – oracle
mkdir -p $ORACLE_BASE/ords
cd $ORACLE_BASE/ords
pwd
/opt/oracle/ords
cp ords-20.4.3.050.1904.zip /opt/oracle/ords
unzip ords-20.4.3.050.1904.zip
mkdir conf
mkdir images
java -version
java -jar ords.war install advanced
/opt/oracle/ords
(1) Basic
(localhost)
(1521)
(1) database service name
xepdb1
(1) verify/install Oracle REST Data Services schema
ORDS_PUBLIC_USER
Confirm password:
administrator username:SYS AS SYSDBA
password for SYS AS SYSDBA:
Confirm password:
default tablespace for ORDS_METADATA (SYSAUX)
temporary tablespace for ORDS_METADATA (TEMP)
default tablespace for ORDS_PUBLIC_USER (SYSAUX)
temporary tablespace for ORDS_PUBLIC_USER (TEMP)
(1) Oracle Application Express
PL/SQL Gateway database user name (APEX_PUBLIC_USER)
database password for APEX_PUBLIC_USER:
Confirm password:
(1) specify passwords for Application Express
database password for APEX_LISTENER
Confirm password:
database password for APEX_REST_PUBLIC_USER
Confirm password:
(1) SQL Developer Web (Enables all features)
Enter 1 if you wish to start in standalone mode or 2 to exit (1):2
java -jar ords.war validate
cp -R /home/oracle/apex202/apex/images/* /home/oracle/ords2043/images
cd /home/oracle/ords2043
java -jar ords.war standalone
APEX static resources location: /home/oracle/ords2043/images
(1): HTTP
HTTP port (8080): 8090
sudo firewall-cmd –permanent –add-port=8080/tcp
sudo firewall-cmd –reload
sudo firewall-cmd –list-ports
alter session set container=XEPDB1;
alter user APEX_200200 identified by oracle account unlock;
alter user APEX_REST_PUBLIC_USER identified by oracle account unlock;
alter user APEX_INSTANCE_ADMIN_USER identified by oracle account unlock;
alter user APEX_PUBLIC_USER identified by oracle account unlock;
alter user APEX_LISTENER identified by oracle account unlock;
vi /opt/oracle/ords/ords/defaults.xml
NOTE :: Replace GT and LT for the XML.
GTentry key=”jdbc.InitialLimit”LT5GT/entryLT
GTentry key=”jdbc.MaxLimit”LT20GT/entryLT
cd /opt/oracle/ords/
vi start_ords.sh
#!/bin/bash
java -Dorg.eclipse.jetty.server.Request.maxFormContentSize=20971520 -jar ords.war standalone
chmod 755 start_ords.sh
./start_ords.sh
That’s All Folks !!! Enjoy It.
by Dino Lopez
linux foundation
