In this blog we are going to explore the Apex 20.1 Installation on Oracle 12 Pluggable Database | Windows 10 Machine using ORDS (Web listener).

Oracle REST Data Services (ORDS) – Java EE based RESTful service.


Installation Requirement : Database Requirement/SGA PGA Memory/Web Listener/etc. Please refer Oracle Doc Link

In this blog we are going to install ā’pěks using Oracle 12c Database Pluggable along with ORDS as web listener.

Apex Installation Steps:

Download Apex 20.1 & Unzip: Oracle Download Link

Select your installation type. Full Development or Runtime. Based on the installation type: Start the installation. In this blog we are going to setup full development environment. Installation Guide Oracle Link

Step 1. Open command prompt “Run as administrator” . Change directory where all apex scripts are present in the unzipped location of apex (~\apex_20.1_en\apex). Login database where you want to install. Login using sys as sysdba

Execute this script after providing table space names and image path :

@apexins.sql <tablespace_apex> <tablespace_files> <tablespace_temp> images

Step 2. Execute this script, which enables you to create your Instance Administrator account. You have to provide administrator name, email & strong password with punctuation.

@apxchpwd.sql

Step 3. Setting up APEX_PUBLIC_USER

ALTER USER APEX_PUBLIC_USER ACCOUNT UNLOCK;
ALTER USER APEX_PUBLIC_USER IDENTIFIED BY <PASSWORD>;

Step 4. Configure RESTfull Services. Here we need to provide password for users : APEX_LISTENER & APEX_REST_PUBLIC_USER

@apex_rest_config.sql

Here Apex Installation is done. Just check schema created by the apex installation. Next step is to setup web listener.   

  • select * from all_users where username like ‘%APEX%’ ;
  • select * from all_users where username like ‘%FLOWS%’ ;

Refer this video for Apex Installation :

ORDS Installation:

Oracle REST Data Services (ORDS) – Java EE based RESTful service which is used to replace Oracle HTTP server and mod_plsql. Download ORDS: Link

In this blog we are going to setup the ORDS using Tomcat. You have other options also like standalone & weblogic. Please refer Installation Guide: Link

Apache Tomcat Download: https://tomcat.apache.org/download-90.cgi

Pretty much straight forward installation. After installation is completed see below steps to validate. Check services : win + r -> services.msc -> Check Apache Tomcat 9 Service. It should be running. Open browser & hit: http://localhost:8080/ . You will see Apache page i.e. Apache Tomcat is up & running.

ORDS Installation Steps

Step 1. Check these schema properly able to access or not. Remember the passwords. In next steps we will provide passwords of these users as parameter.

  • APEX_PUBLIC_USER
  • APEX_LISTENER
  • APEX_REST_PUBLIC_USER
  • SYS AS SYSDBA

Step 2. Unzip ords download folder some where like C:\ords\ords-19.2.0.199.1647. Created conf folder to hold ords configuration : C:\ords\conf

Go and edit : C:\ords\ords-19.2.0.199.1647\params\ords_params.properties. You have to provide all details of your database & passwords of apex users. See below sample my param file.

db.hostname=localhost
db.port=1521
db.servicename=ORCLPDB
db.username=APEX_PUBLIC_USER
db.password=Welcome123
migrate.apex.rest=false
plsql.gateway.add=true
rest.services.apex.add=true
rest.services.ords.add=true
schema.tablespace.default=APEX
schema.tablespace.temp=TEMP
standalone.mode=false
user.apex.listener.password=Welcome#123
user.apex.restpublic.password=Welcome#123
user.public.password=Welcome#123
user.tablespace.default=APEX
user.tablespace.temp=TEMP
sys.user=SYS
sys.password=om
restEnabledSql.active=true
feature.sdw=true
database.api.enabled=true

Step 3. Change directory where ords.war is present & run below command

java -jar ords.war configdir C:\ords\conf

Step 4. Install Ords using : java -jar ords.war

After installation validate ords using: java -jar ords.war validate

Step 5. This step is depends on the installation type as here we have used Tomcat Apache. So we have do the final steps. Refer installation guide for other installation type.

  • Check the tomcat installation directory like : C:\Program Files\Apache Software Foundation\Tomcat 9.0\webapps
  • Copy images from apex download folder (~\Downloads\apex_20.1_en\apex\images) to tomcat (~\webapps\i)
  • Copy ords.war file from ords download folder (~\ords-19.2.0.199.1647\ords.war) to tomcat webapps (~\webapps).
  • Check Apex. http://localhost:8080/ords

Refer this video for ORDS installation:

Create Workspace & Start working on low-code development of application.

Oracle Apex | Create Workspace & Developer Users


Thanks!

Happy Learning! Your feedback would be appreciated!

2 thoughts on “Oracle Apex 20.1 Installation

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s