Configure APEX20.2 on 12c/19c Pluggable Database – using ORDS, deployed on Apache Tomcat - WINDOWS.

                       

 

 

 

 

WINDOWS Environment

 

1.    Create a pluggable database.

 

Database version	12.2
Container db	Apxcdb
Pluggable db	apxpdb

 

 
2.    Install & Configure Apex 20.2 inside Pluggable Database
 
è Download the latest version of Apex20.2 media
è Download latest version of Java
è Download latest version of ORDS
è Download latest version of Apache Tomcat < for windows download the windows service installer media for Tomcat >
 
 
 
Ø  Copy the apex media to an alternate location & unzip the media
We will unzip the apex_20.2.zip downloaded media to location
C:\apex20.2\apex
 
<< apex_epg_config.sql, is no longer part of Apex20 media, it is used for embedded plsql >>
 
Ø  Connect to Pluggable Database and install Apex20
Navigate to the C:\apex20.2\apex folder where you have unzipped the Apex media.

 

Cd C:\apex20.2\apex
o   First we need to connect to container db
set ORACLE_SID=Apxcdb
sqlplus / as sysdba

 

o   Now connect to pluggable db
Alter session set container=apxpdb;
           
 
We will execute the below scripts in the sequence mentioned

 
You can create a separate tablespace for Apex schema or you can put it under SYSAUX schema.
            Create tablespace apex_tbs datafile ‘/home/oracle/db/oradata/apxdb01.dbf’
      Size 500m autoextend on next 500m maxsize 5g;
 

 
Change/Set  the password

 
Run the third script

 

ALTER SESSION SET CONTAINER = apxpdb;
ALTER USER APEX_LISTENER IDENTIFIED BY Oracle#123 ACCOUNT UNLOCK;
ALTER USER APEX_PUBLIC_USER IDENTIFIED BY Oracle#123 ACCOUNT UNLOCK;
ALTER USER APEX_REST_PUBLIC_USER IDENTIFIED BY Oracle#123 ACCOUNT UNLOCK;
ALTER USER APEX_instance_admin_USER IDENTIFIED BY Oracle#123 ACCOUNT UNLOCK;
 
 -- The next one will fail if you've never installed ORDS before. Ignore errors.
ALTER USER ORDS_PUBLIC_USER IDENTIFIED BY Oracle#123 ACCOUNT UNLOCK;
 
ALTER PROFILE default   LIMIT PASSWORD_REUSE_TIME UNLIMITED    PASSWORD_REUSE_MAX UNLIMITED;
ALTER PROFILE default LIMIT   FAILED_LOGIN_ATTEMPTS UNLIMITED PASSWORD_LOCK_TIME 1000;

 
 
3.    Install JAVA
Download the latest version of java and copy it to /home/oracle/java folder and unzip

 

 

 

 

 

 
 
 
 
 

 

4.    Configure ORDS < Oracle REST data services >
 
·         Copy the downloaded ORDS folder to locatoin C:\ords & unzip it here.
·         Copy the images folder from APEX directory to ords folder
Copy C:\apex20.2\apex\images C:\ords
·         Create a folder named config under C:\ords
C:\ords\config
n  We will use this directory to store ords configuration details

 
 

##################################################

Optional

java -jar ords.war configdir C:\ords_install\config-ords

##################################################

 

·         Execute the ords.war file using java

 

 

 

Once this setup completes – you can access the apex application through ORDS standalone service
 

 
                               

 

 http://localhost.com:8080/ords/apex_admin
                                default port for ords is 8080
 
               Stop the standalone service, we will deploy the ORDS service on TOMCAT.
 
  
 
5.    Configure Apache TOMCAT and deploy ORDS on top of it.

 

Downlod the Apache tomcat server media and copy to /home/oracle/soft/apache
In case of windows download the windows service installer media.
 
è Stop the ORDS standalone service running in previous step.
 
Download Tomcat media and unzip to a folder < eg. Apache
 

 

 

Install Apache Tomact

 

 

 

 

Change the port or go with defaults.
 
 

 

 

 

 

 
 

 

·      Copy the images folder from the APEX folder to webapps folder here and rename it to i
copy C:\apex\images C:\tomcat\webapps\i
·      Copy the ords.war file from ords home to apache folder
copy  c:\ords\ords.war C:\tomcat\webapps\ords.war

 
 

 

Restart Apache service once & set the startup mode to automatic.

 
  

 

Use below URL http://localhost.com:8090/ords/apex_admin  
 
 
Login with admin user created in earlier step to login and create your workspaces.
Once you have your own workspace you can use the below URL
http://localhost:8090/ords
 
 
If you are using default port 8080 , you can access the URL wihtout port
http://localhost/ords
http://localhost.com/ords/apex_admin
 
 

Thank you J