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
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
Best Practices for HA Off-Box and Hub Configs
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