Goldengate and Database upgrade

User_6G2Z8

When upgrading Goldengate in EC2 instance (housed remotely from DB) and Database in AWS RDS both from 12cr1 to 19c what are the steps to be followed for a minimal downtime? To upgrade Database first or GG first?

Gururaj0-Oracle

1. Make sue all existing your Extract and Replicat processes completes.
2. Remove all DDL triggers.
3. Upgrade you Database first from 12c to 19c
4. Install new version of GG
5. It will create a new extract, and or replicat for the new 19c database.

Ref: https://docs.oracle.com/en/middleware/goldengate/core/19.1/upgrading/upgrade-microservices-architecture.html

Regards

Gururaj