Here in this guide you can have done a step by step installations activity for APEX 20.2 with ORDS 20.4.1, full installation on Windows server with database version 12.2.0.1.
I have downloaded the binaries from below links
https://www.oracle.com/tools/downloads/apex-downloads.html
https://www.oracle.com/database/technologies/appdev/rest-data-services-downloads.html
![](https://oracleprolab.com/wp-content/uploads/2021/01/image-1.png)
![](https://oracleprolab.com/wp-content/uploads/2021/01/image-2.png)
Pre-requisite
Make sure java jdk is installed already and java -version command output is working, if download and install JDK
![](https://oracleprolab.com/wp-content/uploads/2021/01/image-16.png)
![](https://oracleprolab.com/wp-content/uploads/2021/01/image-17.png)
![](https://oracleprolab.com/wp-content/uploads/2021/01/image-18.png)
![](https://oracleprolab.com/wp-content/uploads/2021/01/image-19.png)
![](https://oracleprolab.com/wp-content/uploads/2021/01/image-20.png)
Once binaries are downloaded we are going to unzip it. I am configuring on the database server.
I have created a folder on D:\oracle, and here we will unzip the apex binary zipfile
![](https://oracleprolab.com/wp-content/uploads/2021/01/image-3.png)
Open command prompt, point to directory d:\oracle\apex and login to Oracle database using sqlplus Login with SYS user.
![](https://oracleprolab.com/wp-content/uploads/2021/01/image-4.png)
I have created a separate table space for APEX installation will be default tablespace for APEX, or we can use sysaux also
CREATE TABLESPACE apex DATAFILE 'D:\app\oradata\db01\apex01.dbf' SIZE 100M AUTOEXTEND ON NEXT 1M;
APEX INSTALLATION
Execute the “apexins.sql” script, specifying the tablespace names and image URL.
SQL> @apexins.sql APEX APEX TEMP /i/
![](https://oracleprolab.com/wp-content/uploads/2021/01/image-6.png)
this takes some time, wait for the installation to get complete
![](https://oracleprolab.com/wp-content/uploads/2021/01/image-7.png)
Now change the admin password by running the “apxchpwd.sql” scripts as the SYS user.
![](https://oracleprolab.com/wp-content/uploads/2021/01/image-8.png)
Now create APEX_LISTENER
and APEX_REST_PUBLIC_USER
users by running the apex_rest_config.sql on same prompt logged in as SYS user
![](https://oracleprolab.com/wp-content/uploads/2021/01/image-9.png)
Check the status of users created on database, you can notice that the account is locked for these. Execute below command with password to unlock the users.
ALTER USER APEX_LISTENER ACCOUNT UNLOCK IDENTIFIED BY P#ssw0rd2021;
ALTER USER APEX_PUBLIC_USER ACCOUNT UNLOCK IDENTIFIED BY P#ssw0rd2021;
ALTER USER APEX_REST_PUBLIC_USER ACCOUNT UNLOCK IDENTIFIED BY P#ssw0rd2021;
ALTER USER APEX_INSTANCE_ADMIN_USER ACCOUNT UNLOCK IDENTIFIED BY P#ssw0rd2021;
ALTER USER APEX_200200 ACCOUNT UNLOCK IDENTIFIED BY P#ssw0rd2021;
ALTER USER ORDSYS ACCOUNT UNLOCK IDENTIFIED BY P#ssw0rd2021;
select username ||’ ‘|| account_status from dba_users where username like (‘APEX%’) or username like (‘ORDS%’);
![](https://oracleprolab.com/wp-content/uploads/2021/01/image-10.png)
Check the port setting for XML DB Protocol Server. Default it will be ‘0’ for 20.2 the value has to be ‘0’
select dbms_XDB.gethttpport from dual;
![](https://oracleprolab.com/wp-content/uploads/2021/01/image-11.png)
EXEC DBMS_XDB.sethttpport(0);
To avoid error on Oracle 12c Apex ORA-24247 network access denied by access control list (ACL) execute the below batch plsql
BEGIN
DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE(
host => ‘*’,
ace => xs$ace_type(privilege_list => xs$name_list(‘connect’),
principal_name => ‘APEX_200200’,
principal_type => xs_acl.ptype_db));
END;
/
COMMIT;
BEGIN
DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE(
host => ‘localhost’,
ace => xs$ace_type(privilege_list => xs$name_list(‘connect’),
principal_name => ‘APEX_200200’,
principal_type => xs_acl.ptype_db));
END;
/
COMMIT;
Oracle REST Data Services Installation (ORDS)
Here we are using ORDS to front APEX application.
Unzip the ords binary to D:\oracle and rename to ords
![](https://oracleprolab.com/wp-content/uploads/2021/01/image-15.png)
Create a directory config under ords
![](https://oracleprolab.com/wp-content/uploads/2021/01/image-14.png)
From the APEX folder copy the image folder to ords folder
![](https://oracleprolab.com/wp-content/uploads/2021/01/image-13.png)
Open command prompt, point to directory d:\oracle\ords
execute below command to start with ORDS installation
java -jar ords.war
![](https://oracleprolab.com/wp-content/uploads/2021/01/image-21.png)
Choose location for Store Configuration data-> D:\oracle\ords\config
Note : for administrator account we use database SYS users and it’s password. for other credentials we have given password P#ssw0rd2021
![](https://oracleprolab.com/wp-content/uploads/2021/01/image-22.png)
![](https://oracleprolab.com/wp-content/uploads/2021/01/image-23.png)
![](https://oracleprolab.com/wp-content/uploads/2021/01/image-25.png)
![](https://oracleprolab.com/wp-content/uploads/2021/01/image-26.png)
Now access the URL and check
http://127.0.0.1:8080/ords / http://localhost:8080/ords or ip address
http://192.168.0.102:8080/ords
![](https://oracleprolab.com/wp-content/uploads/2021/01/image-28.png)
![](https://oracleprolab.com/wp-content/uploads/2021/01/image-29.png)
APEX ADMINISTRATION
To start Apex after server restart, Open command prompt and execute below command
cd d:\oracle\ords
java -jar ords.war
Hi,
I’m beginning to Oracle-apex, I found this article very helpful, But I want to Install Oracle-APEX on Oracle 19c instead of 12cR2.
Would you like help me, Please!
OR write a blog for Oracle-apex Installation on 19c.
thanks
email address will not be published