Add a Replicat for OCI Streaming

Learn to add and configure a Replicat process for an OCI Streaming or OCI Streaming with Apache Kafka target.

Before you begin

Ensure that you have:

An Auth Token

Create the Auth Token on your user details page.
1. In the Oracle Cloud console global navigation bar, select Profile, and then select your username.
2. On your User details page, under Resources, select Auth Tokens.
3. Select Generate Token.
4. In the Generate Token dialog, enter a description, and then select Generate Token.
5. Copy and paste your token to a text editor.
A stream created in OCI Streaming.
Reviewed Configuration Considerations and Best Practices for OCI Streaming

Add a Replicat (26ai)

Ensure that you review prerequisites specific to this target type.

In the OCI GoldenGate deployment console navigation menu, select Replicat.
On the Replicat page, select Add Replicat.
In the Add Replicat panel, on the Replicat Information page, complete the fields as needed, and then select 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.
On the Replicat Options page, complete the fields as needed, and then select 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.
  - Select your Target 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).
On the Managed Options page, complete the optional fields as needed, and then select Next:
- Select a Profile Name, if one is available.
- Enable Critical to deployment health.
- Enable and configure Auto Start settings.
On the Parameter File page, you can add parameters to further configure your Replicat. For example:
```
table source.table1;
```
Note:

GoldenGate uses Greenwich Mean Time (GMT) by default. Use SETENV to override the default setting for the Replicat. This change doesn’t apply to deployments. For example:
```
setenv (TZ="US/Eastern")
setenv (TZ="GMT+5")
```
On the Properties File page, for gg.handler.kafkahandler.topicMappingTemplate=, enter the stream name.

For information on this target's properties, see OCI Streaming in the Oracle GoldenGate for Distributed Applications and Analytics guide.
Select Create and Run. If you select Create, then you can manually start the Replicat later from the Replicats page.

Add a Replicat (21c)

In the OCI GoldenGate deployment console, on the Administration Service Overview page, select Add Replicat (plus icon).
On the Add Replicat page, select a Replicat type, and then select Next.

The types of Replicats are:
- Classic Replicat
- Coordinated Replicat
On the Replicat Options page, complete the following fields, and then select Next:
1. For Process Name, enter a name for the Replicat process.
2. (Optional) For Description, enter a short description to distinguish this process from others.
3. For Trail Name, enter two-character trail name.
4. For Target, select OCI Streaming from the dropdown.
5. For Available aliases for OCI, select the OCI Streaming connection.
On the Parameter File page, add and configure Replicat parameters as needed, and then select Next.
Note:

GoldenGate uses Greenwich Mean Time (GMT) by default. Use SETENV to override the default setting. For example:
```
setenv (TZ="US/Eastern")
setenv (TZ="GMT+5")
```
On the Properties File page, for gg.handler.kafkahandler.topicMappingTemplate=, enter the stream name.
Select Add and Run.

You return to the Administration Service Overview page where you can monitor the status of the Replicat process. Select the process name to view its details and access reports.

Add a Replicat for OCI Streaming

Before you begin

Add a Replicat (26ai)

Add a Replicat (21c)

Related content