Oracle Cloud Infrastructure Documentation

Add a Replicat for Amazon DocumentDB

Learn to add a Replicat process for a Amazon DocumentDB target.

Add a Replicat (23ai)

Before you add and run a Replicat, ensure that you first review details specific to this target type.
To add a Replicat for Amazon DocumentDB:
  1. In the OCI GoldenGate deployment console, on the Administration Service Home page, click Add Replicat (plus icon).
  2. In the Add Replicat panel, on the Replicat Information page, complete the fields as needed, and then click Next:
    • Select a Replicat Type:
      • Classic Replicat
      • Coordinated Replicat
    • Enter a Process Name, no more than 5 characters long.
    • Enter a Description, to help distinguish this process from others.
  3. On the Replicat Options page, complete the fields as needed, and then click Next:
    • Replicat Trail:
      • Enter a Name.
      • Enter a Subdirectory, if you expect the Trail file to be in a location other than the default.
      • Select an Encryption profile. If an encryption profile wasn't created, the Local Wallet is selected by default.
      • For Begin, select the starting point for data processing:
        • Position in Log (default)
        • Now
        • Custom Time
    • Trail Position:
      • Enter the Sequence Number.
      • Enter the RBA Offset.
      • For Target, select AWS DocumentDB from the dropdown.
        Note

        Depending on your target selection, you may have additional options to such as Streaming, Stage and Merge, and Staging locations.
    • Target Credentials:
      • Select a Domain.
      • Select an Alias within the specified Domain.
      • Select a Checkpoint Table. Leave the default selection or select the Checkpoint table you created for the target deployment.
      • Select the Max Threads Number (Coordinated Replicats only).
  4. On the Managed Options page, complete the optional fields as needed, and then click Next:
    • Select a Profile Name, if one is available.
    • Enable Critical to deployment health.
    • Enable and configure Auto Start settings.
  5. On the Parameter File page, you can add parameters to further configure your Replicat. For example:
    table source.table1;

    If using Coordinated Replicat, add TARGETDB LIBFILE libggjava.so SET property=/u02/Deployment/etc/conf/ogg/your_replicat_name.properties to the parameters file.

    Note

    GoldenGate uses Greenwich Mean Time (GMT) by default. Use SETENV to override the default setting for this Replicat process. This change doesn't apply to deployments. For example: 

    setenv (TZ="US/Eastern")
setenv (TZ="GMT+5")
  6. On the Properties File page, set values for each property marked #TODO, as needed.
    For information on this target's properties, see Amazon DocumentDB in the Oracle GoldenGate for Distributed Applications and Analytics guide.
  7. Click Create and Run. If you click Create, then you can manually start the Replicat later from the Administration Service Home page.

Known issues

MongoDB, DocumentDB, and Oracle JSON Collection TLS Security Protocol

If the MongoDB Replicat, DocumentDB Replicat, or Oracle JSON Collection connection fails with the following error in the Report file:
Error: Caused by: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target

Workaround: Add the following property to your Properties file, update <connection_ocid> with your connection OCID and keep the rest as is. 

jvm.bootoptions=-Djavax.net.ssl.trustStore=/u02/connections/<connection_ocid>/truststore.pkcs12 -Djavax.net.ssl.trustStorePassword=Welcome123