If you want to learn how to install Oracle APEX. Yes, you are in the right place. In this post, we will explain how to install APEX 20.1 on Oracle Database 18c. First, we assume that you already have installed Oracle Database 11.2 or higher and running it up. If you face any problem to install Oracle Database, please check the post on how to install it on Windows.

Introduction

Oracle APEX 20.1 is fully supported through Oracle Support Services on all Editions (EE, SE2, SE, and SE1) of the Oracle database, 11.2.0.4, or higher with a valid Oracle Database Technical Support agreement. APEX 20.1 can also be used with Oracle Database 18c Express Edition (XE) but is supported only through the OTN discussion forum, and not through Oracle Support Services.

Download and unzip Oracle Apex

You will need to download the APEX 20.1 installation files in zip format. Note that you need to login and agree with the license agreement before you can proceed with the download. After downloading, you will get a zip file and unzip it to the folder in where you want to install Oracle Apex 20.1, for example, I moved this file to D:\apex.

Install Oracle Apex

Step 1. Press Window+R to open the run window. Type cmd and press enter.

Step 2. Login Oracle database by following command one by one:

or you can write the above three line as like:

Step 3: At first you need to check datafile location and tablespace information by the following command

Step 4: To Install Oracle apex, you need to create a tablespace with datafile first. You should write the following command

Step 5: Now exit SQL developer by exit command

Step 6: You need to change the current directory to where you want to install Oracle Apex. We use D:\apex directory.

Step 7: You need to connect the Oracle Database like step 2.

Step 8: Now write the following command to install Oracle Apex. It will take about 25/30 minutes depends on your computer performance.

Step 9: Now you need to create an image directory. Enter the value for 1: d: (as our installation drive)

Step 10: After successful completion of step 9, connect the database again, and run below command.

Step 11: After successful completion of step 10, connect the database again, and run below command to unlock user one by one

Congratulation! you have installed Oracle Apex 20.1. Let’s start exploring Oracle. You follow Oracle Apex Guide for a serial tutorial to learn Oracle Apex.

Leave a Comment