Part 2: Create the Oracle APEX Database in Amazon Relation Data Service (RDS)

This is the second part of my blog series about the installation and configuration an APEX database in the Amazon Cloud. Refer to following posts for the explanation of the whole solution:

Create the Virtual Private Cloud (Network) in AWS

At first, I will create my customer network in AWS.

In the AWS Console navigate to VPC and click on „Create VPC“. Specify the IPv4 IP Range (CIDR Block) and try „Create“:

Navigate to created VPC und enable the DNS Resolution:

Enable DNS Hostnames:

Verify the created VPC

Create Internet gateway

Now we will create the Internet gateway to connect the VPC to the Internet

Attach Internet Gateway to VPC

Create three public subnets in Frankfurt Region

At this time, we will create three subnets in our VPC

Subnet 1

Subnet 2

Subnet 3

Enable Auto-Assign Ip-Address

For all three Subnets enable the Auto Assign IP-Addresses

Create and Configure the Route Table

Now we will create the route table to handle to enable for all instances the internet access:

Add Routes

Check:

Now we will associate the created route table with three subnets:

Check:

Create the Oracle Database in the RDS (Relation Database Service) in AWS

Now we will create the oracle managed database in AWS.

Create the Security Group for the Database

At first, we will create the database subnet group. It will be referenced by creating the database.

In the EC2 Console navigate to Security Groups and create a Security Group:

Add Tag (unique name) for the security group:

Create Inbound Rules

Check:

Create DB Subnet Group

Now we will create the database subnet group. It will be used by creating the database.

RDS -> Create DB Subnet Group

Create Outbound Rules

Create an Option Group with APEX Software:

Per default, the APEX is not enabled by the creating of the database. We will now create the Option Group that includes APEX:

RDS -> Option Groups -> Create Option Group

Create

Then „Add Option“:

Add APEX and APEX_DEV:

Create the database:

Choose Database Vendor: Oracle

And Edition: Oracle Standard Edition Two:

Specify the Use Case:

Specify the database configuration:

Define the admin user (in my case: bne) and set and save the master password for the database. You will able to connect to the database with the admin-user and the master password.

Network Settings:

You can choose already created network (VPC) and the security group: