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

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

Go to the Apex folder Location

D:\ApexSetup\apex\apex-latest\apex

D:

sqlplus /nolog

conn sys as sysdba

show pdbs;

alter session set container = ORCLPDB;  // 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 s;  // Used this password in this video for all accounts 

@apex_rest_config.sql

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

Now Install jdk 17 or later version

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

Now go to the C Drive and Make a folder name app>then two folder ords and config>in config make

a folder ords>then make a folder logs

Then Copy the Ords zip file to the c drive ords file and then extract it.

Install ORDS

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

Now go to the sqlplus

sys as sysdba

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

alter session set container = orclpdb;

alter user apex_listener identified by s account unlock;

alter user apex_public_user identified by s account unlock;

alter user apex_rest_public_user identified by s account unlock; 

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

Now Create  a ords.bat file and put the below information in the bat file

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

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=ORCLPDB 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

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

Now in the ords location C:\app\ords

Write ords.bat

Enter the Database password for sys as SYSDAB :s

Enter the Database password for ORDS_PUBLIC_USER:s

Confirm password:s

Now run this command 

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

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

Now Install Apache Tomcat

Give the port 8888 and user name admin and password admin

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

Now go to the cmd command prompt then write

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

mkdir %CATALINA_HOME%\webapps\i

Now go to the Apex folder where image file located and copy the images and then go to 

c:\Program Files\Apache Software Foundation\Tomcat 9.0\webapps\i this location and keep their

Now go to the ords folder in C drive and copy ords.war file then go to the 

c:\Program Files\Apache Software Foundation\Tomcat 9.0\webapps this location and paste here

now go to the c:\Program Files\Apache Software Foundation\Tomcat 9.0\webapps\bin

in the bin there is a file tomcat9w and double click on it and 

then click on java first java options keep it.

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

Run Oracle APEX

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

http://localhost:8888/ords/apex_admin

--------------------------------------If Pluggable Database is off----then

alter session set container = ORCLPDB;

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

alter database open;

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

show pdbs;

localhost