Installing Oracle APEX 21

#### Installing APEX 21.1

Oracle APEX Dev team announced the [APEX 21.1](https://www.oracle.com/tools/downloads/apex-v191-downloads.html) on May 12 2021. Let's get it installed and running.

- [Step 1 Download](#download)
- [Step 2 Extract](#extract-zip-file)
- [Step 3 Create PDB for APEX 21](#create-pdb-for-apex-21)
- [Step 4 Installation](#installation)
- [Step 5 Loading Images](#loading-images)

#### Download

Download [APEX 21.1](https://www.oracle.com/tools/downloads/apex-v191-downloads.html) from oracle as per language preference.


#### Extract Zip file

Extract the downloaded Zip file in desired location where you want keep the APEX files.


## Create PDB for APEX 21

If you are using multitenant architecture, then create a PDB to install Oracle APEX 21.

I generally use Database configuration assiatant to create PDB.

## Installation

Now we are ready for our fevorite command using @apexins.sql.

We can take reference from our previous blog post [How to Install APEX in Oracle 19 C](https://blogs.ontoorsolutions.com/post/how-to-install-apex-in-oracle-19-c)

```sql
@apexins.sql SYSAUX SYSAUX TEMP /i/
```

This will install the APEX in the existing selected PDB. 


## Loading Images

In APEX 21, Oracle has desupported the EPG. Now we have get the ORDS installed and reference the images to "/i/". About this i had a tweet thread with [Dimitri](https://dgielis.blogspot.com/)

- [EPG is desupported](https://docs.oracle.com/en/database/oracle/application-express/21.1/htmig/apex-installation-requirements.html#GUID-848EF7A3-07D0-427E-A080-694144570136)

- [web listener requirements](https://docs.oracle.com/en/database/oracle/application-express/21.1/htmig/apex-installation-requirements.html#GUID-848EF7A3-07D0-427E-A080-694144570136)


[Download ORDS](https://www.oracle.com/database/technologies/appdev/rest-data-services-downloads.html)

Download the ORDS from above link and extract in desired location. As we are done with the extraction process, we can start creating users for ORDS installation.


Run apex_rest_config.sql to create rest users.
 
```sql
@apex_rest_config.sql
```

Install the ORDS using below command using Jar file.

Potential error
- [Could not reserve enough space for object heap](https://java2blog.com/could-not-reserve-enough-space-for-object-heap/)

Use JAVA_OPTIONS=-Xmx512M  in your Environment varible settings. 

```cmd
C:\App\ORDS\ORDS_21\ords>java -jar ords.war
Picked up _JAVA_OPTIONS: -Xmx512M
Enter the name of the database server [localhost]:
Enter the database listen port [1521]:
Enter 1 to specify the database service name, or 2 to specify the database SID [1]:
Enter the database service name:APEX_21_1 (PDB service name)
Enter the database password for ORDS_PUBLIC_USER:
Confirm password:
Requires to login with administrator pri