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;

To establish a connection with an Oracle Autonomous Database instance, you need to download the client credentials files. There are two ways to download the client credentials files: the Oracle Cloud Infrastructure Console or Database Actions Launchpad.

The following steps use the Database Actions Launchpad to download the client credentials files.

1. Log in to your Autonomous Database account.

2. From the Database Instance page, click Database Actions. This launches the Database Actions Launchpad. The Launchpad attempts to log you into the database as ADMIN. If that is not successful, you will be prompted for your database ADMIN username and password.

3. On the Database Actions Launchpad, under Administration, click Download Client Credentials (Wallets).

4. Enter a password to secure your Client Credentials zip file and click Download.

   Note:

   The password you provide when you download the wallet protects the downloaded Client Credentials wallet.
5. Save the credentials zip file to your local system. The credentials zip file contains the following files:

   • cwallet.sso

   • ewallet.p12

   • keystore.jks

   • ojdbc.properties

   • sqlnet.ora

   • tnsnames.ora

   • truststore.jks

   • ewallet.pem

   • README.txt

   Refer and update (if required) the sqlnet.ora and tnsnames.ora files while configuring Oracle GoldenGate to work with the Oracle Autonomous Database instance.