Configure Oracle GoldenGate

Configure Oracle GoldenGate to act as a hub where you can manage your connections to source and target databases, create extracts of source data, and replicate the data to the target database.

Connect Oracle GoldenGate as the Source Administration Server

Connect the Oracle GoldenGate Administration Server to the source database.

1. Use a browser to open the public IP assigned to your Oracle GoldenGate instance and sign in as oggadmin.
2. Click the Port number for the target Administration Server.
3. Click Configuration in the left navigation panel.
4. From the Database tab, click the plus ( +) icon to add a new credential.
5. Provide the following information:
   • Credential Domain: Specify a credential domain such as oggadmin. Defaults to OracleGoldenGate.
   • Credential Alias: Specify an alias, for example, ggadmin@adwus2_low.
   • User ID: Specify a user ID in the form ggadmin@<tnsnames_reference>, for example, ggadmin@adwus2_low.
   • Password: Specify a password for the ggadmin user.
   • Verify Password: Reenter the password for the ggadmin user.
6. Click Submit.
7. Test the connection to the database by clicking the Log in Database icon and signing in using the credentials you just specified.

Create Extract

You must define an extract process to specify how data is captured from the source database.

The extract is responsible for capturing the committed data modeling language (DML) transactions and the data definition language (DDL) from Oracle redo logs. Extract writes these data changes into trails or extract files.

1. From the home page of the source Administration Server, click the Plus (+) icon next to Extracts.
2. Select Integrated Extract and click Next.
3. Specify required and optional values for the extract. For example:
   • Process Name (required): adwsrc2
   • Description: Extract for ADWSRC2
   • Intent: Unidirectional
   • Credential Domain: oggadmin
   • Credential Alias (required): c##ggadmin_adwus2
   • Begin (required): Now
   • Trail Name (required): ad
   • Trail Size (MB): 500
   • Trail Sequence: 0
   • Trail Offset: 0
   • Profile Name: Local Wallet (Default)
   • Register to PDBs (required): PDB1
4. Click Next.
5. Edit the parameter file in the text area to list the table details that you are interested in capturing. For example:

   table pdb1.adwsrc.rep_data;

6. Click Create and Run.
7. When the extract process completes, you are returned to the Overview page of the Administration Server. The Action menu for the extract provides options to stop the extract and to view extract process details.

Connect Oracle GoldenGate as the Target Administration Server

Connect the Oracle GoldenGate Administration Server to the target database and provide necessary replicat information.

1. Use a browser to open the public IP assigned to your Oracle GoldenGate instance and sign in as oggadmin.
2. Click the Port number for the source Administration Server.
3. Click Configuration in the left navigation panel.
4. From the Database tab, click the plus ( +) icon to add a new credential.
5. Provide the following information:
   • Credential Domain: Specify a credential domain such as oggadmin. Defaults to OracleGoldenGate.
   • Credential Alias: Specify an alias, for example, ggadmin
   • User ID: Specify a user ID in the form ggadmin@<tnsnames_reference>, for example, ggadmin@adwus2_low.
   • Password: Specify a password for the ggadmin user.
   • Verify Password: Reenter the password for the ggadmin user.
6. Click Submit.
7. Test the connection to the database by clicking the Log in Database icon and signing in using the credentials you just specified.
8. Specify a checkpoint table, for example ggadmin.checkpoint_rec_data and click Submit.

   Checkpoint tables contain the data necessary for tracking the progress of the replicat as it applies transactions to the target system.

9. Add a schema by clicking the plus (+) icon next to Transaction Information, providing the schema name, enabling Scheduling Columns, and clicking Submit.

   The schema you specify enables supplemental logging on the source schema.

10. Add Heartbeat monitoring by clicking the plus (+) icon next to Heartbeat, accepting the suggested defaults, and clicking Submit.

    The Automatic Heartbeat table is a way to monitor latency within the Oracle GoldenGate framework. Heartbeat tables provide you a way to gauge the end-to-end throughput within the configuration and identify any potential bottlenecks in the network.

Create Replicat

You must define a replicat process to specify how extracted data is placed in the target database.

The replicat process runs on the target system, reads the trail on that system, and then reconstructs the DML or DDL operations and applies them to the target database.

1. From the home page of the target Administration Server, click the Plus (+) icon next to Replicats.
2. Select Nonintegrated Extract and click Next.
3. Specify required and optional values for the extract. For example:
   • Process Name (required): adwus2
   • Description: Replicat for ADWUS2
   • Intent: Unidirectional
   • Credential Domain: oggadmin
   • Credential Alias (required): ggadmin
   • Begin (required): Position in Log
   • Transaction Log Sequence Number (required): 0
   • Transaction Log RBA Offset (required): 0
   • Source (required): Trail
   • Trail Name (required): ad
   • Trail Subdirectory: <none>
   • Checkpoint Table: No Checkpoint Table
   • Profile Name: Local Wallet (Default)
4. Click Next.
5. Edit the parameter file in the text area to list the table details that you are interested in capturing. For example:

   MAP PDB1.REC_DATA, TARGET ADWUS2.REC_DATA;

6. Click Create and Run.
7. From the Overview page of the Administration Server, click the Action menu for the replicat and select Start.