Step by step Oracle Apex 20.2 installation on Windows and Unix/Linux systems.

The steps of Oracle Apex 20.2 installation is almost same as Step by step Oracle Apex 20.1 installation on Windows and Unix/Linux systems. except step: Run Image Script. In Oracle Apex 20.2 installation, we don't need to install image script.


Here are the step by step instructions to install Oracle Apex 20.2 on Windows and Unix/Linux systems. 


Step 1 Download Apex

To download Oracle Application Express release 20.2, go to following link:

https://www.oracle.com/tools/downloads/apex-v191-downloads.html


Step 2. Unzip in desired location 

After downloading, unzip in your desired directory where you want to install. For example, in windows, your directory path could be like F:\oracle\apex20_1\apex.

On Unix/Linux your directory path could be like /home/oracle/apex20_2


Step 3. Open Terminal or CMD 

Open the command prompt (CMD) on Windows or Terminal on Unix/Linux and changed the directory to the apex20_2 directory as follows:


On Windows:

cd F:\oracle\apex20_2


On Unix/Linux:

cd /home/oracle/apex20_2


Step 4. Connect database 

Connect database using SQL*PLUS with SYS user credentials after going apex20_2 directory.


Step 5. Select PDB Database 

Select one PDB database where you want to install Apex 20.2. Suppose PDB database name is pdbapex20. 

alter session set container=pdbapex20;

So now, pdbapex20 is selected to install Apex 20.2.  


Step 6. Run apex installation Script 

At first, we need to run apexins.sql passing the following four arguments in the order shown:


@apexins.sql tablespace_apex tablespace_files tablespace_temp images

where tablespace_apex is SYSAUX, tablespace_files is tablespace_temp is tablespace_temp and images folder is images

run this command:

@apexins.sql SYSAUX SYSAUX TEMP /images/


Step 7. Set Admin Password 

Now run the change password script for the ADMIN user as following and the password must follow the complexity rules, for example, I provided the password as Apex#2020.

 @apxchpwd.sql

Step 8. Unlock the APEX_PUBLIC_USER  

Unlock the APEX_PUBLIC_USER account and specify the password. Don’t forget to connect to Oracle using SQL*PLUS if disconnected and make sure you are connected with PDB. 

ALTER USER APEX_PUBLIC_USER ACCOUNT UNLOCK;

To change the password for the APEX_PUBLIC_USER account:

ALTER USER APEX_PUBLIC_USER IDENTIFIED BY Pusr#123;


Step 9. Run Configure Apex RESTful Service Script 

 @apex_rest_config.sql

This will ask you to give APEX_LISTENER and APEX_PUBLIC_USER password to set which will be used later for the ORDS setup. 


Step 10. Set the HTTP port 

 if using HTTP server, execute the following command:

EXEC DBMS_XDB.SETHTTPPORT(8181);

Now the installation of Oracle Apex 20.2 has been completed, and you test the installation by entering the following URL in the browser: http://localhost:8181/apex/apex_admin


Your playground is ready. 


Play and Enjoy. 

………………………………………………………….