News
Perth, Australia
+ (61) 417713124
prosolutions@gavinsoorma.com

Oracle GoldenGate 18c Upgrade

  • Posted by Gavin Soorma
  • On January 8, 2019
  • 5 Comments
  • 18c, GoldenGate, goldengate 18c, Installation, upgrade

This note outlines the procedure followed to upgrade GoldenGate 12.3 to the latest 18c version (18.1.0.0.0).

Note:

  • If we are upgrading from Oracle GoldenGate 11.2.1.0.0 or earlier, we also need to upgrade the Replicat checkpoint table via the GGSCI command UPGRADE CHECKPOINTTABLE [owner.table]
  • If we are using trigger-based DDL replication support, then additional steps need to be carried out which are described in more detail in the GoldenGate Upgrade documentation outlined in the URL below:

https://docs.oracle.com/en/middleware/goldengate/core/18.1/upgrade/upgrading-release-oracle-database.html#GUID-9B490BE5-F0AE-44D1-B63C-F5299B9DFD16

In this example, the source database version is higher than 11.2.0.4 and we are using Integrated Extract where DDL capture support is integrated into the database logmining server.
 
 

  • Verify that there are no open and uncommitted transactions

 

GGSCI (rac01.localdomain) 2> send ext1 showtrans
Sending SHOWTRANS request to EXTRACT EXT1 ...
No transactions found.

GGSCI (rac01.localdomain) 3> send ext1 logend
Sending LOGEND request to EXTRACT EXT1 ...
YES

 

  • Stop the Extract (and Pump)

 

GGSCI (rac01.localdomain) 5> stop extract * 

Sending STOP request to EXTRACT EXT1 ...
Request processed.

Sending STOP request to EXTRACT PUMP1 ...
Request processed.

 

  • Ensure Replicat has finished processing all current DML and DDL data in the Oracle GoldenGate trails before stopping the replicat

Issue the command SEND REPLICAT with the STATUS option until it returns a status of “At EOF” to indicate that it finished processing all of the data in the trail file.
 

GGSCI (rac01.localdomain) 4> send rep1 status 
Sending STATUS request to REPLICAT REP1 ...
  Current status: At EOF
  Sequence #: 2
  RBA: 1,538
  0 records in current transaction.

GGSCI (rac01.localdomain) 6> stop replicat * 

Sending STOP request to REPLICAT REP1 ...
Request processed.

 

  • Stop the Manager process

 

GGSCI (rac01.localdomain) 7> stop mgr !

Sending STOP request to MANAGER ...
Request processed.
Manager stopped.

 

  • Take a backup of the current Oracle GoldenGate installation directory on the source and target systems as well as any working directories that have been installed for a cluster configuration on a shared file system like dirprm,dircrd,dirchk,BR,dirwlt,dirrpt etc.

We do not need to backup up the dirdat folder which contain the trail files.

It is recommended to upgrade both the source as well as target Oracle GoldenGate environments at the same time.

If we are not upgrading Replicat on the target systems at the same time as the source, add the following parameter to the Extract parameter file(s) to specify the version of Oracle GoldenGate that is running on the target.

This parameter causes Extract to write a version of the trail that is compatible with the older version of Replicat.

{EXTTRAIL | RMTTRAIL} file_name FORMAT RELEASE major.minor

For example:

EXTTRAIL ./dirdat/lt FORMAT RELEASE 12.3

  • On both source and target Goldengate environments install Oracle GoldenGate 18c (18.1.0) using Oracle Universal Installer (OUI) into an existing Oracle GoldenGate directory.

Note: Ensure the checkbox to start the Manager is not ticked.
 

[oracle@rac01 sf_software]$ cd 181000_fbo_ggs_Linux_x64_shiphome
[oracle@rac01 181000_fbo_ggs_Linux_x64_shiphome]$ cd fbo_ggs_Linux_x64_shiphome/
[oracle@rac01 fbo_ggs_Linux_x64_shiphome]$ cd Disk1
oracle@rac01 Disk1]$ ./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.

 

[oracle@rac01 goldengate]$ sqlplus sys as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Tue Jan 8 11:26:34 2019

Copyright (c) 1982, 2016, Oracle.  All rights reserved.

Enter password: 

Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> @ulg.sql
Oracle GoldenGate supplemental log groups upgrade script.
Please do not execute any DDL while this script is running. Press ENTER to continue.


PL/SQL procedure successfully completed.

 

  • After the installation/upgrade is completed, alter the primary Extract process as well as the associated data pump Extract processes to write to a new trail sequence number via the ETROLLOVER command.

Reposition both the existing Extract Pump as well as the Replicat processes to start reading from and processing the new trail file.

[oracle@rac01 goldengate]$ ./ggsci

Oracle GoldenGate Command Interpreter for Oracle
Version 18.1.0.0.0 OGGCORE_18.1.0.0.0_PLATFORMS_180928.0432_FBO
Linux, x64, 64bit (optimized), Oracle 12c on Sep 29 2018 04:22:21
Operating system character set identified as UTF-8.

Copyright (C) 1995, 2018, Oracle and/or its affiliates. All rights reserved.



GGSCI (rac01.localdomain) 1> info all 

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     STOPPED                                           
EXTRACT     STOPPED     EXT1        00:00:00      01:13:55    
EXTRACT     STOPPED     PUMP1       00:00:00      01:13:55

GGSCI (rac01.localdomain) 2> alter extract ext1 etrollover 

2019-01-08 00:44:13  INFO    OGG-01520  Rollover performed.  For each affected output trail of Version 10 or higher format, after starting the source extract, issue ALTER EXTSEQNO for that trail's reader (either pump EXTRACT or REPLICAT) to move the reader's scan to the new trail file;  it will not happen automatically.
EXTRACT altered.


GGSCI (rac01.localdomain) 3> alter extract pump1 etrollover 

2019-01-08 00:44:51  INFO    OGG-01520  Rollover performed.  For each affected output trail of Version 10 or higher format, after starting the source extract, issue ALTER EXTSEQNO for that trail's reader (either pump EXTRACT or REPLICAT) to move the reader's scan to the new trail file;  it will not happen automatically.
EXTRACT altered.


GGSCI (rac01.localdomain) 4> info ext1 detail 

EXTRACT    EXT1      Initialized   2019-01-07 14:36   Status STOPPED
Checkpoint Lag       00:00:00 (updated 00:00:53 ago)
Log Read Checkpoint  Oracle Integrated Redo Logs
                     2019-01-07 23:29:38
                     SCN 0.3272690 (3272690)

  Target Extract Trails:

  Trail Name                                       Seqno        RBA     Max MB Trail Type

  ./dirdat/ogg1/lt                                     3          0        500 EXTTRAIL  


GGSCI (rac01.localdomain) 5> alter pump1 extseqno 3 extrba 0
EXTRACT altered.


GGSCI (rac01.localdomain) 6> info pump1 detail 

EXTRACT    PUMP1     Initialized   2019-01-08 00:45   Status STOPPED
Checkpoint Lag       00:00:00 (updated 00:00:08 ago)
Log Read Checkpoint  File /acfs_oh/app/goldengate/dirdat/ogg1/lt000000003
                     First Record  RBA 0

  Target Extract Trails:

  Trail Name                                       Seqno        RBA     Max MB Trail Type

  ./dirdat/ogg2/rt                                     3          0        500 RMTTRAIL  

  
GGSCI (rac01.localdomain) 7> alter rep1 extseqno 3 extrba 0

2019-01-08 00:46:08  INFO    OGG-06594  Replicat REP1 has been altered. Even the start up position might be updated, duplicate suppression remains active in next startup. To override duplicate suppression, start REP1 with NOFILTERDUPTRANSACTIONS option.

REPLICAT (Integrated) altered.

  • Start all the GoldenGate processes in the new GoldenGate 18c environment
GGSCI (rac01.localdomain) 8> start mgr
Manager started.


GGSCI (rac01.localdomain) 9> info all 

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                           
EXTRACT     STARTING    EXT1        00:00:00      00:02:06    
EXTRACT     STARTING    PUMP1       00:00:00      00:00:50    
REPLICAT    STARTING    REP1        00:00:00      00:00:11    


GGSCI (rac01.localdomain) 10>

GGSCI (rac01.localdomain) 10> !
info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                           
EXTRACT     RUNNING     EXT1        00:00:00      00:00:06    
EXTRACT     RUNNING     PUMP1       00:00:00      00:00:07    
REPLICAT    RUNNING     REP1        00:00:00      00:00:03    

 4

5 Comments

avtaritet
  • Jan 9 2019
On Goldengate you are the best man which is publishing very usefull documents
farid100093600600
  • Jan 9 2019
Thanks Gavin Wonderfully explained!
Ahamed Sulthan
  • Jan 9 2019
Thanks Gavin. Well explained!
Rajasekhar Amudala
  • Jan 10 2019
Thank you Gavin !!! Really appreciate your efforts and sharing knowledge to all !!! Thank you, Rajasekhar Amudala
Mohammed Ajaz
  • Jan 12 2019
Great Gavin Bhai, well explained.

Leave Reply

Your email address will not be published. Required fields are marked *