Setting up an Oracle RDS instance on AWS

Set up and configure an Oracle Relational Database Service (RDS) instance on Amazon Web Services (AWS). The Oracle RDS instance is the backend database for the OpenPages application that is deployed on IBM® Software Hub within in an AWS Red Hat® OpenShift® Service on AWS (ROSA) cluster.

Before you begin

Ensure you have the following prerequisites:
  • An active AWS account with necessary permissions to create RDS instances.
  • Access to the AWS Management Console or AWS CLI.
  • Identified the AWS region where the OpenPages on IBM Software Hub is (or will be) deployed, for optimal performance and reduced latency.

Procedure

Complete the following steps to set up your Oracle RDS instance and configure it:
  1. Log in to AWS Management Console with your AWS account credentials on https://console.aws.amazon.com/.
  2. Search for RDS in the Find Services search bar, then click RDS to open the Amazon RDS Dashboard. Create a new Oracle RDS instance from the dashboard.
  3. Edit the database instance details and settings for your RDS instance:
    1. Under Settings, create a unique identifier for your database instance. This name must be unique across all RDS instances in your AWS account within the selected region.
    2. For Master username, type admin as this is the primary login name for your database instance.
    3. For Storage configuration, set the allocated storage to 100 GB and enable storage auto-scaling with a maximum threshold of 1000 GB.
  4. Set up a connection to a compute resource for your RDS instance:
    1. Under Connectivity, select Connect to an EC2 compute resource. Your database instance is linked to a bastion EC2 host, which is often required for secure database administration and connectivity.
    2. Ensure that Public access is disabled since database instances will not have a public IP address and only resources inside the VPC, such as EC2 bastion node or ROSA cluster, can access it.
  5. Update other details and settings about Database authentication, Monitoring, and the type of database insights you want to view.
  6. Edit the database, encryption, backup, and maintenance details under Additional configuration.
  7. After creating your RDS instance, you must configure an EC2 instance on AWS as a bastion host to securely setup the OpenPages schema and to test the RDS connectivity.

What to do next

Complete the tasks in Setting up an external AWS RDS Oracle database for OpenPages.