- Connecting to an Oracle Database on RDS
- Configuring the Oracle RDS Instance for Oracle GoldenGate Replication
- Setting up the Oracle GoldenGate Capture
1. Connecting to an Oracle Database on RDS
After an Oracle Database 12c instance (with no multi-tenant support)  is created on RDS, you can connect to it using either SQL*Plus or Oracle SQL Developer. You first need to update the AWS inbound rule to enable the connection. This is configured in the security group assigned to the instance. An example setup is shown by the screenshot which allows requests from to any machine and connects to the database. The following is an example SQL*Plus connection (master user is awsuser) :
Unlike on Oracle Cloud where the Oracle Database Cloud Service can pre-configured to enable GoldenGate replication. On AWS, you need to configure to enable GoldenGate replication in Oracle Database on RDS. This includes updating the ENABLE_GOLDENGATE_REPLICATION system parameter to be TRUE, creating a GoldenGate administrator, and granting the GoldenGate administrator privileges.
The followings is the setup of Oracle GoldenGate extract parameter file: