Hello Team,
we are actually running GG version 18.1 on 12.1.0.2 DB. I am planning to upgrade DB to 19c soon. GG also should be upgraded as compatibility matrix.
Environment runs extract and replicat. It does a downstream capture : archivelogs are shipped from source to the target where goldengate is running.
Verify that there are no open and uncommitted transactions
send extdwh showtrans
send extdwh logend
Stop the Extract (and Pump)
stop extract *
Ensure Replicat has finished processing all current DML and DDL data in the Oracle GoldenGate trails before stopping the replicat
send reploggt status
stop replicat *
Stop the Manager process
stop mgr !
Take a backup of the current Oracle GoldenGate installation directory on target.
cp -R /ogg/ora12c /ogg/ora12cBK
install Oracle GoldenGate 19c (19.1.0) using Oracle Universal Installer (OUI) into an existing Oracle GoldenGate directory.
Note: Ensure the checkbox to start the Manager is not ticked.
./runInstaller
Execute the ulg.sql script located in the GoldenGate software root directory as SYSDBA. This script converts the existing supplemental log groups to the format as required by the new release.
Reposition both the existing Extract Pump as well as the Replicat processes to start reading from and processing the new trail file.
./ggsci
alter extract extdwh etrollover
alter extract pxdwn etrollover
info extdwh detail
alter pxdwn extseqno <output> extrba <output>
info pxdwn detail
alter reploggt extseqno <output> extrba <output>
start all golden gate processes.
Kindly advise if any steps are incorrect or have been missed.
Regards,
Roshan