Install oracle apex on pluggable database and config with ords and apache tomcat

In this step-by-step tutorial, you will learn how to install the latest Oracle APEX version 22.2 on your own local Windows PC. This local Oracle APEX development environment setup will be created using Oracle Database 21c XE, the latest Oracle Rest Data Services (ORDS 22x), Java (JDK 17x), and Apache Tomcat.

Download Oracle XE 21c

https://www.oracle.com/ie/database/te...

Download Oracle APEX

https://www.oracle.com/tools/download...

Download ORDS

https://download.oracle.com/otn_softw...

Download JAVA

https://www.oracle.com/java/technolog...

Download Tomcat

https://tomcat.apache.org/download-90...

Install Oracle APEX

-------------------------------

sqlplus /nolog

conn sys as sysdba

show pdbs;

alter session set container = XEPDB1;  // Always execute this command when you open a new sqlplus session

column default_tablespace format A15

column temporary_tablespace format A15

@apexins.sql SYSAUX SYSAUX TEMP /i/

@apxchpwd.sql

alter user APEX_PUBLIC_USER account unlock;

alter user APEX_PUBLIC_USER identified by Manager_2023;  // Used this password in this video for all accounts 

@apex_rest_config.sql

Install ORDS

--------------------

sqlplus

sys as sysdba

alter user sys identified by Manager_2023 account unlock container=all;

alter session set container = xepdb1;

alter user apex_listener identified by Manager_2023 account unlock;

alter user apex_public_user identified by Manager_2023 account unlock;

alter user apex_rest_public_user identified by Manager_2023 account unlock; 

----------------------------------------------------------------------------

Ords.bat 

----------------------------------------------------------------------------

set ORDS_HOME=c:\app\ords

set ORDS_CONFIG=c:\app\config\ords

set ORDS_LOGS=%ORDS_CONFIG%\logs

set DB_HOSTNAME=localhost

set DB_PORT=1521

set DB_SERVICE=XEPDB1

set SYSDBA_USER=SYS

c:\app\ords\bin\ords.exe ^

  --config %ORDS_CONFIG% install ^

  --log-folder %ORDS_LOGS% ^

  --admin-user %SYSDBA_USER% ^

  --db-hostname %DB_HOSTNAME% ^

  --db-port %DB_PORT% ^

  --db-servicename %DB_SERVICE% ^

  --feature-db-api true ^

  --feature-rest-enabled-sql true ^

  --feature-sdw true ^

  --gateway-mode proxied ^

  --gateway-user APEX_PUBLIC_USER ^

  --proxy-user

------------------------------------------------------------------------------

setx PATH "%PATH%;c:\app\ords\bin"

set PATH="%PATH%;c:\app\ords\bin"

Install Apache Tomcat

--------------------------------------

set CATALINA_HOME="c:\Program Files\Apache Software Foundation\Tomcat 9.0"

mkdir %CATALINA_HOME%\webapps\i

-Dconfig.url=c:\app\config\ords

Run Oracle APEX

-----------------------------

http://localhost:8888/ords/apex_admin

--------------------------------------

alter session set container = ORCLPDB;

------------------------------------

alter database open;

-----------------------------------------

show pdbs;

localhost