Configure Connections to Oracle AI Autonomous Database

Learn about user privileges required on the database side to connect to Oracle GoldenGate and configuration instructions to set up connections for Oracle AI Autonomous Database to Oracle GoldenGate.

Establish Oracle GoldenGate Credentials for Oracle AI Autonomous Database

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 AI 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;