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.
To download Oracle Application Express release 20.2, go to following link:
https://www.oracle.com/tools/downloads/apex-v191-downloads.html
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
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
Connect database using SQL*PLUS with SYS user credentials after going apex20_2 directory.
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.
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/
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
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;
@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.
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.
………………………………………………………….