You can connect your on-premises Oracle GoldenGate Microservices architecture to the Oracle GoldenGate Microservices architecture on Oracle Cloud Marketplace using the following methods:

• Connecting through Public IP Address
• Connecting through IPSec VPN
• Connecting through FastConnect

The following section helps you to connect through public IP address. To use the IPSec VPN or the FastConnect approach, refer to the respective VPN Connect and FastConnect documentation.

Unlock the Pre-created Oracle GoldenGate User (ggadmin)

Perform the following steps to configure the Autonomous Database for Replication:

1. Unlock and change the password for the pre-created Oracle GoldenGate user (ggadmin) within the Autonomous Data Warehouse. Use any SQL client tool to unlock the account.

   For more details, see Configure the Autonomous Database for Replication in Using Oracle GoldenGate for Oracle Database.

   SQL> select * from dba_users order by username;
   SQL> alter user ggadmin identified by password account unlock;

2. Check whether the parameter enable_goldengate_replicaton is set to true. If not, then modify the parameter.

   SQL> select * from v$parameter where name = 'enable_goldengate_replication';
   SQL> alter system set enable_goldengate_replication = true scope=both;

Create Target Schema

Complete the following steps to create schema and target objects that can be used in replication. This schema and associated objects does not support DDL replication.

1. Create a new application user/schema. This user/schema stores the target objects for replication.

   Note:

   appadmin is an example user.

   SQL> create user appadmin identified by ********
   SQL> grant create session, resource, create view, create table to appadmin;
   SQL> alter user appadmin quota unlimited on data;
   

2. Connect to Oracle Autonomous Database as a user/schema and create your application tables.

Obtain the Autonomous Database Client Credentials

Perform the following steps to obtain the Oracle Autonomous Data Warehouse Cloud account details:

1. Log in to your Oracle Autonomous Data Warehouse Cloud account.
2. From the Instance page, click the menu option for the Autonomous Database instance and select Service Console.
3. Log in to the Service Console using the admin username, and its associated password.
4. In the Service Console, click the Administration tab.
5. Click Download Client Credentials.
6. Enter a password to secure your credentials zip file and click Download.
7. Save the credentials zip file to your local system.

Move Client Credentials to Oracle GoldenGate Compute Node

In order to establish a connection from Oracle GoldenGate to the Autonomous Data Warehouse, you need to move the client credentials to Oracle GoldenGate Compute Node. The following steps will illustrate how to move the credential zip file from your machine to Oracle GoldenGate Compute Node.

1. Connect to the Oracle GoldenGate Classic Compute Node using SSH and opc user credentials.

   ssh -i <private_key> opc@<public_ip_address>

2. Create a staging directory and grant the essential permissions and then exit the session.

   $ mkdir stage
   $ exit
   

3. Copy the credentials zip file to the Oracle GoldenGate Classic Compute Node.

   $ scp ./<credential_file>.zip opc@<public_id_address>:~/stage

4. Connect to the Oracle GoldenGate Classic Compute Node.

   ssh -i <private_key> opc@<public_ip_address>

5. Verify whether the credentials zip file is available in the stage location.

   $ cd ~/stage
   $ ls -ltr
   

Configure Oracle Goldengate Compute Node with Autonomous Client Credentials

After moving the ADWC Client Credentials to the Oracle GoldenGate Compute Node, you have to install the necessary files and ensure you have a connection to the Autonomous Data Warehouse. The following steps will help you configure the required SQL*Net components:

1. Log in to the Oracle GoldenGate Classic Compute Node using SSH and the opc user credentials.

   ssh -i <private_key> opc@<public_ip_address>

2. Unzip the client credentials file into a temporary directory.

   unzip ./<credential_file>.zip -d ./client_credentials

3. Copy the sqlnet.ora and tnsnames.ora files to the location of your TNS_ADMIN.

   $ cd ~/stage/client_credentials
   $ cp ./sqlnet.ora /u02/deployments/<deployment>/etc
   $ cp ./tnsnames.ora /u02/deployments/<deployment>/etc

   Note:

   If you want your networking directory structure to be consistent with other Oracle products, you must append/network/admin to the directory structure. For this you have to change the environment variable TNS_ADMIN. For more information on Local Naming Parameters, refer to Database Net Services Reference.
4. Edit the sqlnet.ora file and replace the directory parameter with the location of the information pointing to the location where the client credentials were unzipped.

   $ cd /u02/deployments/<deployment>/etc
   $ vi ./sqlnet.ora

   Change ?/network/admin to /home/opc/stage/client_credentials.

5. For testing purposes, set the TNS_ADMIN and ORACLE_HOME environment variables at the operating system level.

   Note:

   The Oracle GoldenGate Deployment(s) use the ORACLE_HOME and TNS_ADMIN environment variables that are set per deployment.

   $ export ORACLE_HOME=/u01/app/client/<oracle version>
   $ export TNS_ADMIN=/u02/deployments/<deployment>/etc
   

6. Test the connection to Autonomous Data Warehouse by connecting to one of the entries in the tnsnames.ora file.

   $ cd $ORACLE_HOME/bin
   $ ./sqlplus appadmin/**********@orcladw_low

Add Oracle GoldenGate Credential to connect to Autonomous Database

To add Oracle GoldenGate Credential details, to connect to Autonomous Database:

1. Log in to the Service Manager using the password for oggadmin.
2. From the Service Manager main page, select the hyperlink for the port number associated with the Administration Service.
3. Open the context menu in the top left corner of the Overview page.
4. From the context menu, select Configuration.
5. From the Database tab, click the plus ( + ) icon, to add a new credential.
6. Provide the following information and click Submit.

   Credential Domain: [Defaults to OracleGoldenGate]
   Credential Alias: [Name of the Alias]
   User ID: ggadmin@<adw_tnsnames_reference>
   Pasword: [Password for ggadmin]
   Verify Password: [Password for ggadmin]

7. Test the connection to the Autonomous Database by clicking the Log in Database icon after the credential has been added.