Oracle Cloud Infrastructure GoldenGate enables you to send data from an on-premises or Marketplace Oracle GoldenGate to OCI GoldenGate using a Distribution Path. The following steps guide you through how to set up and run this replication model using the latest Oracle GoldenGate version for OCI Marketplace.

This quickstart is also available as a LiveLab: View the workshop.

You must have the following in order to proceed:

• An existing on-premises or Marketplace Oracle GoldenGate deployment
• An existing source and target Autonomous databases.
  Note
  
  Download and load the sample data, if needed.

1. Create an OCI GoldenGate deployment.
2. Create connections to your source and target databases.
3. Assign connections to the deployment.

1. Download the root certificate for the OCI GoldenGate deployment console.
   Note
   
   You can download the root certificate from any browser. The following steps describe how to download the root certificate from a Chrome browser.
   1. In your Chrome browser address bar, click the padlock icon, and then click Connection is secure.
   2. Click Certificate is valid. A Certificate window opens.
   3. In the Certificate window, click Certification Path, select DigiCert, and then click View Certificate.
   4. Ensure that Issued reads DigiCert Global Root G2, click Details, and then Copy to File.
   5. In the Certificate Export Wizard, click Next, select Base-64 encoded X.509 (.CER), and then click Next.
   6. Click Browse to save the file to your local drive.
   7. Click Next, and then click Finish.
2. Upload the certificate to the on-premises or Marketplace Oracle GoldenGate Service Manager:
   1. Open the on-premises or Marketplace Oracle GoldenGate Service Manager in a browser window.
   2. In the navigation menu (hamburger icon), click Certificate Management.
   3. On the Certificate Management page, click Add CA Certificates (plus icon).
   4. In the Add CA Certificate dialog, enter a Unique Name.
   5. For Certificate PEM, copy and paste the contents of the certificate file you downloaded from Chrome, and then click Add.
3. Add a user with which Oracle GoldenGate can use to connect to OCI GoldenGate.
   1. Launch the OCI GoldenGate deployment console from the deployment Details page.
   2. In the navigation menu and then click User Administration.
   3. Click Add New User (plus icon), complete the fields as follows, and then click Submit:
      • For Authenticated By, select Password from the dropdown.
      • For Role, select Operator from the dropdown.
      • For Username, enter a name.
      • For Password, enter the password associated with this user. Verify the password.
   4. Open the on-premises or Marketplace Oracle GoldenGate Adminstration Service, and then navigate to the Path Connections page.
   5. Click Add Path Connection (plus icon), complete the fields as follows, and then click Submit:
      • Credential Alias: Enter an alias.
      • User ID: Enter the name of the user created in the previous step.
      • Password and Verify Password: Enter the password associated with this user.

1. On the on-premises or Marketplace Oracle GoldenGate, add and run an Extract.
2. On the on-premises or Marketplace Oracle GoldenGate, add a Distribution Path with the following values, and then click Create and Run:
   1. On the Source Options page:
      • For Source Extract, select the Extract created in Task 2.
      • For Trail Name: Enter a two-character name for the trail when it's received by OCI GoldenGate.
   2. On the Target Options page:
      • For Target Host: Enter the OCI GoldenGate hostname in the following format, <domain>.deployment.goldengate.<region>.oci.oraclecloud.com:443.
      • For Port Number: Enter the port number of the target deployment.
      • For Trail Name: Enter a two-character name for the trail when it's received by Oracle GoldenGate.
      • For Alias, enter the Credential Alias created in Task 2.
3. In the OCI GoldenGate deployment console, add a Nonintegrated Replicat.

1. Monitor performance.
2. Manage Trail files.