Prerequisites for Capturing from an Autonomous AI Database

Oracle Autonomous AI Database has a tight integration with Oracle GoldenGate. There are a number of differences when setting up Extract for an Autonomous AI Database instance compared to a traditional Oracle Database.

Oracle Autonomous AI Database security has been enhanced to ensure that Extract is only able to capture changes from the specific tenant it connected to. Therefore, Downstream Integrated Extract is not supported.

Establishing Oracle GoldenGate Credentials

To capture from an Autonomous AI Database only the GGADMIN account is used. The GGADMIN account is created inside the database when the Autonomous AI Database is provisioned and already has all the necessary permissions for both Extract and Replicat processes. This account is locked. It must be unlocked before it can be used with Oracle GoldenGate. This account is the same account used for both Extracts and Replicats in the Autonomous AI Database.

Note:

If you do not have administrator access to the Oracle Autonomous AI Database, you should ask your service administrator to download and provide the credentials files to you.

Run the ALTER USER command to unlock the ggadmin user and set the password for it. See Creating Users with Autonomous Database with Client-Side Tools.

This ALTER USER command must be run by the admin account user for Autonomous AI Databases. 

ALTER USER ggadmin IDENTIFIED BY PASSWORD ACCOUNT UNLOCK;

Prerequisites for Configuring Oracle GoldenGate Extract to Capture from Autonomous AI Databases

Prior to configuring and starting the Extract process to capture from the Oracle Autonomous AI Database, make sure that the following requirements are met:

  • Oracle Autonomous AI Database environment is provisioned and running.

  • Autonomous AI Database-level supplemental logging should be enabled by the ADMIN or GGADMIN.

Configuring Autonomous AI Database Supplemental Logging for Extract

To add minimal supplemental logging to your Autonomous AI Database instance, log into the instance as GGADMIN or ADMIN account and execute the following commands:
ALTER PLUGGABLE DATABASE ADD SUPPLEMENTAL LOG DATA;
To DROP Autonomous AI Database-level supplemental logging incase you decide to stop capturing from that database instance:
ALTER PLUGGABLE DATABASE DROP SUPPLEMENTAL
        LOG DATA;
You can verify that the Autonomous AI Database-level supplemental logging is configured properly by issuing this SQL statement:
SELECT MINIMAL FROM dba_supplemental_logging;
The output for this statement is:
MINIMAL
-------
YES

The MINIMAL column will be YES if supplemental logging has been correctly set for this Autonomous AI Database instance.

Next Steps After Setting Up Extract Prerequisites for Autonomous AI Database

After preparing Oracle GoldenGate for Oracle Autonomous AI Databases, you can begin follow the instructions in the topic Configure Extract for Oracle Autonomous AI Database.