Category Archives: GoldenGate Hub

GoldenGate 11.2.0.3 to 19.1.0.0.4 via GoldenGate HUB

Setup includes

VM Hub setup can be used

Either VirtualBox and/or VMWare can be used

Setup the hub according to MRC standards with software installs as well as client installs

Links to scripts and other posts will be here soon……

Ensure the timezone is correct between the servers otherwise the testing will not complete

Ensure the supplemental logging is complete

The setup includes 12.3.0.1 GoldenGate (and patches) installed on the hub server to talk to the 11g (11.2.0.3.0) database

11g Client Download

it also includes 19c GG setup to talk to the 19c database

Extracts are setup in the 12c GG home to talk to 11g and share a common trail file location

Make sure the mrcenv file being used allows for setup of the environment for both 12c GG and 19c GG

mrchost_mrcenv can be used for both environments

Once completed with this setup make a snap like I did in order to make the config easy to propagate

GoldenGate Streams Pool Config

Configure the Streams pool

When using Extract in integrated capture mode, an area of Oracle memory called the Streams pool must be configured in the System Global Area (SGA) of the database. 7

ORACLE GOLDENGATE PERFORMANCE BEST PRACTICES

The size requirement of the Streams pool for Extractin integrated capture mode is based on the number of integrated Extracts and the integrated capture mode parameter,
MAX_SGA_SIZE, which controls the amount of shared memory used by the LogMiner server. The default value is 1GB which is adequate in almost all cases. This is not the same as the database initialization parameter, SGA_MAX_SIZE.

Set the STREAMS_POOL_SIZE
initialization parameter for the database to the following value:
(MAX_SGA_SIZE * # of integrated Extracts) + 25% head room

For example, using the default values for the
MAX_SGA_SIZE

with two integrated Extracts:
( 1GB * 2 ) * 1.25 = 2.50GB
STREAMS_POOL_SIZE = 2560M