Configure Oracle GoldenGate for an Autonomous Database

Here are the steps to complete the configuration tasks:

Note:

Instructions are based on the assumption that the source environment is already configured. Learn the steps required to configure replication into the Autonomous Database environment.

  1. For Oracle GoldenGate on-premises, make sure that Oracle GoldenGate is installed.

    You can also use Oracle GoldenGate Microservices Architecture 21c for Marketplace for Oracle Autonomous Database Serverless 21c. Oracle GoldenGate Microservices Architecture 21c and higher support Autonomous Database capture using Marketplace for Oracle Autonomous Database Serverless.

  2. Create a deployment for your Oracle GoldenGate environment. This is the deployment where the Replicat that applies data into the Autonomous Database will be created.

  3. The Autonomous Database instance has a pre-created user for Oracle GoldenGate on-premise called ggadmin. The ggadmin user has been granted the required privileges for Replicat. This is the user where any objects used for Oracle GoldenGate processing will be stored, like the checkpoint table and heartbeat objects. By default, this user is locked. To unlock the ggadmin user, connect to your Oracle Autonomous Database instance as the ADMIN user using any SQL client tool. See About Connecting to Autonomous Database Instance.

  4. Run the ALTER USER command to unlock the ggadmin user and set the password for it. This will be used in the command line for any DBLOGIN operations on the Autonomous Database. It will be used in Replicat to allow Oracle GoldenGate to connect to the Autonomous Database and apply data.
    ALTER USER ggadmin IDENTIFIED BY p0$$word ACCOUNT UNLOCK;