• Arun Kumar

Upgrade Oracle Golden Gate 12cR1 to 12cR2

In this article we will look at Oracle Golden Gate upgrade from 12.1 to 12.2 on a Linux server.


Remember

  • Allow golden gate processes to finish processing all current DML and DDL data in GG trail files

  • If upgrading DB along with GG, upgrade DB first


Upgrade Steps


1. Stop user activity on source objects which are involved in replication

2. Stop Extract

GGSCI> lag ext1
GGSCI> stop ext1

3. Make sure replicat applies all transactions on target

GGSCI> lag rep1

4. Stop pump and Replicat

GGSCI> stop dp1
GGSCI> stop rep1

5. Stop Manager on both source and target

GGSCI> stop mgr

6. Take backup of GG_HOME on both source and target

  • If you want to upgrade source and target DBs, this is the time

  • Once DBs are upgraded, still make sure there is no activity on source objects involved in replication

7. Perform Golden Gate upgrade

  • Download latest 12.2.0.2 Golden Gate and copy zip file to both source and target DBs

  • Unzip and start the runInstaller

  • Give same old GG_HOME location while installation – Do not worry, this option will auto upgrade old GG

  • Do not start manager

  • Perform installation on both source and target DBs in same old GG_HOME location

8. Run @ulg script for supplemental log upgrade from GG_HOME

cd $GG_HOME
Sqlplus / as sysdba
SQL> @ulg.sql  press enter when prompted

9. Rollover Extract, Pump and Replicat to next trail sequence number

On source DB:
=============
alter extract ext1 etrollover
alter extract dp1 etrollover
info ext1 detail
ALTER EXTRACT dp1, EXTSEQNO <above_seq_no>, EXTRBA 0
info dp1 detail
On target DB:
=============
alter replicat rep1, EXTSEQNO <above_seq_no>, EXTRBA 0

10. Start Manger, Extract, Pump and Replicat

  • This is an oracle known error. You get prvtlmpg.plb script with GG binaries. This resides under $GG_HOME.

  • Run this script on both source and target database

11. cd $GG_HOME Sqlplus / as sysdba SQL> @prvtlmpg.plb  press enter when prompted


12. Allow activity on source objects involved in replication

Recent Posts

See All

Install Oracle 12c Golden Gate on Oracle Linux

In this article we will look at the steps to install oracle 12c Golden Gate on Oracle Enterprise Linux 6.5. The steps involved are: Virtual Machine Setup Install Oracle 12c Database Install Oracle 12c

Single Table Replication – Same Schema

In this article we will be looking at single table replication using Oracle Golden Gate where the schema name is same on both source and target database. Create Sample Table Create Fox user on both pr

Single Table Replication – Different Schema

In this article we will be looking at single table replication using Oracle Golden Gate where the schema name is different on source and target but table structure remains same. Create Sample Table Cr

  • Facebook
  • Twitter
  • YouTube
  • Instagram

© 2020 by DBA Genesis