Amazon RDS Oracle

Amazon RDS for Oracle is a fully managed commercial database that makes it easy to set up, operate, and scale Oracle deployments in the cloud. Amazon RDS frees you up to focus on innovation and application development by managing time-consuming database administration tasks including provisioning, backups, software patching, monitoring, and hardware scaling.

Refer to Oracle on Amazon RDS for the supported Oracle database versions.

Prerequisites

Setting up Redo Logs for Replication

For Pipeline with mode as Redo Log, set up Redo logs for replication as follows:

Step 1. Enable ARCHIVE log mode

Logminer reads the archived Redo log files. Hence it is necessary to enable archiving for Redo logs-based replication.

  1. To know the current log mode, run the command:

    SELECT LOG_MODE FROM "V$DATABASE";

  2. If the value returned is NOARCHIVELOG, enable ARCHIVE mode using the following command:

    exec rdsadmin.rdsadmin_util.set_configuration('archivelog retention hours',72);

Step 2. Enable supplemental logging

Supplemental logging is required to make sure that the server logs all columns of every change event to the Redo logs.

  1. Enable supplemental logging by running the following command:

    exec rdsadmin.rdsadmin_util.alter_supplemental_logging('ADD','ALL');

  2. Verify if supplemental logging is enabled:

    SELECT SUPPLEMENTAL_LOG_DATA_MIN FROM "V$DATABASE"

    This should return YES or IMPLICIT.

Whitelisting Hevo’s IP Addresses

You need to whitelist the Hevo IP address for your region to enable Hevo to connect to your Amazon RDS Oracle database. You can do this by creating a VPC security group and adding inbound and outbound access rules for the Hevo IP addresses. A VPC group controls access to the database instances and virtual server instances inside a VPC. To do this:

Step 1. Create a VPC security group

  1. Access the Amazon RDS console..

  2. In the left navigation pane, select Databases (or Instances if you are using an older version).

  3. In the Databases section on the right, select the read replica or master database instance that you want to connect.

    Select Oracle instance

  4. In the Connectivity & Security tab, click the hyperlink under Security, VPC security groups.

    Select VPC group

  5. In the Security Groups page, click Create security group.

    You can also click on an existing group, which you have used for other database instances, and modify it (or use the Security group selected by Default).

    Create security group

  6. In the Create security group page, specify the following:

    • Security group name: An appropriate name for the security group.

    • Description: A brief description of the security group.

    • VPC:

Step 2. Add inbound rules

In the Inbound Rules section:

Add rule

  1. Click Add Rule and specify the following.

    • Port range: The port of your Amazon RDS Oracle instance. For example, 1521.

    • Source: Select Custom from the drop-down and enter Hevo’s IP addresses for your region.

  2. Click Save rule.

  3. Add more rules for all the Hevo IPs you want to whitelist.

Step 3. Add outbound rules

In the Outbound Rules section:

  1. Click Add Rule and specify the following

    • Port range: The port of your Amazon RDS Oracle instance. For example, 1521.

    • Source: Select Custom from the drop-down and enter Hevo’s IP addresses for your region.

  2. Click Save rule.

  3. Add more rules for all the Hevo IPs you want to whitelist.

    Add more rules

Granting Privileges to User

Log in to your Oracle database and run the following SQL command to grant permissions to the database user to connect to your database:

GRANT SELECT ANY TABLE TO "<database.user>";

Limitations

None.

Last updated on 10 Dec 2020