Setting up GoldenGate Replication with DIPC

Edward Whalen

03/07/2019

Setting up GoldenGate replication with DIPC is done from both the cloud console and from the GoldenGate home.  In this example I will be using an Oracle database source and an Oracle database target.  It is a slightly different process depending on whether you are using a PDB or non-PDB database.  Those differences will be pointed out at the appropriate section.

There are several prerequisites that must be met prior to configuring GoldenGate replication with DIPC.  They are listed here:

  • Database and Listener must be available.
  • GoldenGate user must be created and available within the database
    • For a container database Extract a common user c##ggadmin must be used.
    • For a container database replicat a local user in each database ggadmin must be used.
    • For a non-container database ggadmin is used.
  • The DIPC agent must be running. This is described in a different paper.

Once these pre-requisites are done the following steps are necessary to create a replication task between source and target.

  1. Create a connection within DIPC to the source database (and container if applicable).
  2. Create a connection within DIPC to the target database (PDB).
  3. Create the replication task within DIPC.
  4. Start the replication task.

Let’s look at an example of these steps.

  1. Create a connection within DIPC to the source database (and container if applicable).

Creating a connection is done within the DIPC console in the Catalog tab.  Select Connection from the Add menu which is in the upper right of the DIPC console.  Once the Add Connection dialog is opened there are several fields that must be populated.

Name               This is the name of the connection that you are connecting to.

Identifier          Automatically populated.

Agent               The name of the DIPC agent that will be running and controlling the connection.  This is selected from the dropdown list.

Type                 This is where you choose whether you are creating a connection to an Oracle database or some other database.

Subtype            If you choose Oracle as the type, a Subtype option appears to allow you to choose an Oracle database or an Oracle CDB.  If you choose CDB you must create another connection to the PDB that you want to extract from.  If this is for a target, choose Oracle.

Hostname         The server where the database resides.

Port                  The listener port number

Username         This should be the GoldenGate user account.

Password          The GoldenGate user account password.

Service Name    The database service name or SID.

Schema Name   The GoldenGate schema.

CDB Name        If you are adding an Oracle PDB you must add the CDB.  If you are adding a CDB this is not used.  If you are adding a non-container database this is not used.

Test the connection and save it when successful.

  1. Create a connection within DIPC to the target database (PDB)

Creating a connection is done within the DIPC console in the Catalog tab.  Select Connection from the Add menu which is in the upper right of the DIPC console.  Once the Add Connection dialog is opened there are several fields that must be populated.

Name               This is the name of the connection that you are connecting to.

Identifier          Automatically populated.

Agent               The name of the DIPC agent that will be running and controlling the connection.  This is selected from the dropdown list.

Type                 This is where you choose whether you are creating a connection to an Oracle database or some other database.

Subtype            For the target choose Oracle.

Hostname         The server where the database resides.

Port                  The listener port number

Username         This should be the GoldenGate user account.

Password          The GoldenGate user account password.

Service Name    The database service name of the target database or PDB.

Schema Name   The GoldenGate schema.

CDB Name        If you are adding an Oracle PDB you must add the CDB.  If you are adding a CDB this is not used.  If you are adding a non-container database this is not used.

Test the connection and save it when successful.

  1. Create the Replication Task within DIPC
By |2019-05-01T11:40:05+00:00March 7th, 2019|GoldenGate, Uncategorized|Comments Off on Setting up GoldenGate Replication with DIPC