Configure Oracle GoldenGate for an Oracle Autonomous AI Database

Learn the steps to configure Oracle GoldenGate Replicat for an Oracle Autonomous AI Database.

Here are the steps to complete the configuration tasks:

Note:

Instructions are based on the assumption that the source environment is already configured.

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

  2. (Microservices only) Create a deployment for your Oracle GoldenGate environment. This is the deployment where the Replicat that applies data into the Oracle Autonomous AI Database will be created. See How to Create Deployments for steps to add a deployment.

  3. The Autonomous Database has a pre-existing user created for Oracle GoldenGate on-premise called ggadmin. The ggadmin user has been granted the required privileges for Replicat to work. 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 the Oracle Autonomous AI Database instance as the ADMIN user using any SQL client tool. See Create Users on Autonomous AI Database with Database Actions.

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