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.
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
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 :
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.
- SYS AS SYSDBA
Step 2. Unzip ords download folder some where like C:\ords\ords-188.8.131.52.1647. Created conf folder to hold ords configuration : C:\ords\conf
Go and edit : C:\ords\ords-184.108.40.206.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-220.127.116.11.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.
Happy Learning! Your feedback would be appreciated!Follow @shobhitsinghIN