Use the Streams Pool Advisor for versions under 19c
For versions 19c or higher use the new utl_rpadv
Not sure about if this can be used for versions earlier.....will check it out soon this is a much longer line as a test this is a test this is a test this is a test
Enable DDL Replication Old Method
Multi-Tenant Environment GoldenGate
Identify any in-flight transactions prior to starting extract and export for GoldenGate
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
Feb 5th 2020