Creating a Parallel Replicat

A parallel Replicat requires a checkpoint table so both the Administration Service UI and Admin Client issue an error when the parallel Replicat does not include a checkpoint table.

Note:

Parallel replication does not support COMMIT_SERIALIZATION in Integrated Mode. To use this apply process, use Integrated Replicat.

Creating a Non-Integrated Parallel Replicat with the Administration Service

Open a browser and connect to the Service Manager that you created with the Configuration Assistant:
```
https://server_name:service_manger_port/
```
For Example, https://localhost:9000/. In an non secured environment, use http instead of https.

The Oracle GoldenGate Service Manager is displayed.
Enter the username and password you created and click Sign In.

In the Service Manager, you can see servers that are running.
In the Services section, click Administration Service, and then log in.
Click the Application Navigation icon to the left of the page title to expand the navigation panel.
Create the checkpoint table by clicking Configuration in the right navigation panel.
Ensure that you have a valid credential and log in to the database by clicking the ‘log in database’ icon under Action.
Click the + sign to add a checkpoint table.
Enter the schema.name of the checkpoint table that you would like to create, and then click Submit.
Validate that the table was created correctly by logging out of the Credential Alias using the log out database icon, and then log back in.

Once the log in is complete, your new checkpoint table is listed.
Click Overview to return to the main Administration Service page.
Click the + sign next to Replicats.
Select Parallel Replicat and then select either Integrated or Nonintegrated Replicat then click Next. In this document, Nonintegrated option is selected.
Enter the required information making sure that you complete the Credential Domain and Credential Alias fields before completing the Checkpoint Table field, and then select your newly created Checkpoint Table from the list.
Click Next, and then click Create and Run to complete the Replicat creation.

Creating a Non-Integrated Parallel Replicat with the Admin Client

Go the bin directory of your Oracle GoldenGate installation directory.
```
cd $OGG_HOME/bin
```
Start the Admin Client.
```
./adminclient
```
The Admin Client command prompt is displayed.
```
OGG (not connected) 12>
```
Connect to the Service Manager deployment source:
```
connect http://localhost:9500 deployment Target1 as oggadmin password welcome1
```
You must use http or https in the connection string; this example is a non-SSL connection.
Add the Parallel Replicat, which may take a few minutes to complete:
```
add replicat R1, parallel, exttrail bb checkpointtable ggadmin.ggcheckpoint
```
You could use just the two character trail name as part of the ADD REPLICAT or you can use the full path, such as /u01/oggdeployments/target1/var/lib/data/bb.

Verify that the Replicat is running:

info replicat R1

Messages similar to the following are displayed:

REPLICAT   R1        Initialized   2016-12-20 13:56   Status RUNNING
Parallel
Checkpoint Lag       00:00:00 (updated 00:00:22 ago)
Process ID           30007
Log Read 
Checkpoint  File ./ra000000000First Record  RBA 0