With Oracle Goldengate 12 there is now a big change on the way to install: there is an installer!
Up to Oracle Goldengate 11 every new patch was a new complete version. With Oracle Goldengate 12 you need to install a base version and then the latest patch.
Here is a quick sum up of the instructions (done on AIX, but is similar on Linux):
- From Oracle website download the Goldengate 22.214.171.124.0 for your operating system
- From Oracle support note 1645495.1 download the latest patchset for Goldengate. Check the availability for your OS.
- Unzip both downloaded files
- Call the <download_dir>/ggs_AIX_ppc_shiphome/Disk1/runInstaller
- Follow the instructions by choosing the target DB version and install directory (I recommend $ORACLE_BASE/product/gg)
- Check it works
- Install the latest patchset with OPatch
- Check it is updated
# set ORACLE_HOME to an existing Oracle database installation: export ORACLE_HOME=$ORACLE_BASE/product/126.96.36.199 # set LD_LIBRARY_PATH to use libraries from $ORACLE_HOME: export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_BASE/product/gg # Start Goldengate: cd $ORACLE_BASE/product/gg ./ggsci Oracle GoldenGate Command Interpreter for Oracle Version 188.8.131.52.1 19797716 OGGCORE_184.108.40.206.1_PLATFORMS_141026.2215 AIX 6, ppc, 64bit (optimized), Oracle 11g on Oct 27 2014 00:19:39 Operating system character set identified as ISO-8859-1. Copyright (C) 1995, 2014, Oracle and/or its affiliates. All rights reserved. GGSCI (anjovm1) 1> info all Program Status Group Lag at Chkpt Time Since Chkpt MANAGER STOPPED GGSCI (anjovm1) 2> exit
cd <download_dir>/21785294 $ORACLE_BASE/product/gg/OPatch/opatch apply -oh $ORACLE_BASE/product/gg Invoking OPatch 220.127.116.11.7 Oracle Interim Patch Installer version 18.104.22.168.7 Copyright (c) 2011, Oracle Corporation. All rights reserved. Oracle Home : /oracle/app/product/gg121 Central Inventory : /oracle/oraInventory from : /etc/oraInst.loc OPatch version : 22.214.171.124.7 OUI version : 126.96.36.199.0 Log file location : /oracle/app/product/gg121/cfgtoollogs/opatch/opatch2015-11-11_08-32-55AM.log Applying interim patch '21785294' to OH '/oracle/app/product/gg121' Verifying environment and performing prerequisite checks... Do you want to proceed? [y|n] y User Responded with: Y All checks passed. Please shutdown Oracle instances running out of this ORACLE_HOME on the local system. (Oracle Home = '/oracle/app/product/gg121') Is the local system ready for patching? [y|n] y User Responded with: Y Backing up files... Patching component oracle.oggcore.ora11g, 188.8.131.52.0... Patch 21785294 successfully applied Log file location: /oracle/app/product/gg121/cfgtoollogs/opatch/opatch2015-11-11_08-32-55AM.log OPatch succeeded.
# Start Goldengate: cd $ORACLE_BASE/product/gg ./ggsci Oracle GoldenGate Command Interpreter for Oracle Version 184.108.40.206.10 21604177 OGGCORE_220.127.116.11.0OGGBP_PLATFORMS_150902.1337 AIX 6, ppc, 64bit (optimized), Oracle 11g on Sep 2 2015 16:29:21 Operating system character set identified as ISO-8859-1. Copyright (C) 1995, 2015, Oracle and/or its affiliates. All rights reserved. GGSCI (anjovm1) 1>
We have now Oracle Goldengate 18.104.22.168.10 installed.
Interesting enough is that Oracle Goldengate 12.1 still uses the OPatch version 22.214.171.124.7, taken probably from Oracle 126.96.36.199, as we can see from the line “OUI version : 188.8.131.52.0”.