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 12.1.2.1.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
# set ORACLE_HOME to an existing Oracle database installation:
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0.4
# 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 12.1.2.1.1 19797716 OGGCORE_12.1.2.1.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
- Install the latest patchset with OPatch
cd <download_dir>/21785294
$ORACLE_BASE/product/gg/OPatch/opatch apply -oh $ORACLE_BASE/product/gg
Invoking OPatch 11.2.0.1.7
Oracle Interim Patch Installer version 11.2.0.1.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 : 11.2.0.1.7
OUI version : 11.2.0.3.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, 12.1.2.1.0...
Patch 21785294 successfully applied
Log file location: /oracle/app/product/gg121/cfgtoollogs/opatch/opatch2015-11-11_08-32-55AM.log
OPatch succeeded.
- Check it is updated
# Start Goldengate:
cd $ORACLE_BASE/product/gg
./ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 12.1.2.1.10 21604177 OGGCORE_12.1.2.1.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 12.1.2.1.10 installed.
Interesting enough is that Oracle Goldengate 12.1 still uses the OPatch version 11.2.0.1.7, taken probably from Oracle 11.2.0.3, as we can see from the line “OUI version : 11.2.0.3.0”.