Hi Bobby
This is the process:
1. Database running 11.2.0.4 with GoldenGate 12.1.2 for 11g
2. Database is upgraded from 11.2.0.4 to 19.0
3. GoldenGate 12.1.2 must be upgraded because it does not support 19c
Databases and also because the GoldenGate 12.1.2 installed supports 11g
database only
So in step 3 what should I do, according to 2092450.1 I can simply copy
goldengate process related files from old goldengate to the new goldengate
for 19c RDBMS like .prm and .cpe. But if I use 2657958.1 I have to recreate
all extracts and replicats. I wonder which approach is the recommended way?
I have tested copy goldengate process related files from 12.1.2 OGG to 19c
OGG and seems that it works (I didn't get any errors).
Thanks
On Fri, Sep 25, 2020 at 7:53 PM Bobby Curtis <curtisbl@xxxxxxxxx> wrote:
From looking at these MOS notes, they are referencing how to handle
GoldenGate processes when upgrading the Oracle database after an in place
upgrade. These notes don’t address how to upgrade GoldenGate itself. Are
you asking if the steps are correct or which one to use? If the later, I
would say it depends on what approach you want use after you perform an in
place database upgrade.
Thanks
Bobby
*From: *"oracle-l-bounce@xxxxxxxxxxxxx" <oracle-l-bounce@xxxxxxxxxxxxx>
on behalf of Ls Cheng <exriscer@xxxxxxxxx>
*Reply-To: *"exriscer@xxxxxxxxx" <exriscer@xxxxxxxxx>
*Date: *Friday, September 25, 2020 at 1:49 AM
*To: *Oracle Mailinglist <oracle-l@xxxxxxxxxxxxx>
*Subject: *Handling GoldenGate upgrade when upgrading Database
Hi
I have a database running in 11.2.0.4 and 12.1.2 GoldenGate, I am planning
to upgrade the database to 19c therefore I need to upgrade Goldengate to
19c version for 19c database as well.
There are a couple of MOS notes, *Goldengate upgrade across Oracle RDBMS
upgrade from 11g to 12c. (Doc ID 2092450.1)* and *How To Handle OGG
During Database Upgrade (Doc ID 2657958.1)* which states how to do with
GoldenGate when the database is being upgraded however the two notes use
totally different approaches. Note 2092450.1 is much easier and I have
tested and it works. Anyone know if it is supported? Note 2657958.1 is
trickier because basically it is recreating the extracts.
Strange thing is that none of the notes talks about what to do with the
Replicats.
Thanks
