GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

(OGG) Do we have to stop all DB transaction on source DB while patching?

I'm using Oracle GoldenGate 19c for Oracle database 19c (source) and GoldenGate 21c for SQL Server (target). It's unidirectional environment.

I'm going to patch Oracle GoldenGate software from 19.1.0.0.230117 to 19.20.0.0.230718. According to this docs, https://docs.oracle.com/goldengate/c1230/gg-winux/GWUUP/installing-patches-release.htm#GWUUP-GUID-73F3697C-972C-41BD-B928-F14BB5BE6213, for Oracle GoldenGate for Heterogeneous Databases, there is a step stated to 'Stop user activity on objects in the Oracle GoldenGate configuration.'. Is that following step also required for Oracle GoldenGate for Oracle Database too? Do I have to stop the transaction on source DBs or just stop all the GoldenGate process is okay?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center