GoldenGate Versions
Currently, there're several GoldenGate versions in Oracle:
- Oracle GoldenGate 21.3
- Oracle GoldenGate 21.1
- Oracle GoldenGate 19.1
- Oracle GoldenGate 18.1
- Oracle GoldenGate 12.3.0.1
- Oracle GoldenGate 12.2.0.1
- Oracle GoldenGate 12.1.2
- Oracle GoldenGate 11.2.1
- Oracle GoldenGate 11.1.1.1
- Oracle GoldenGate 11.1.1
- Oracle GoldenGate 10.4
You may download the latest GoldenGate in Oracle.
Check GoldenGate Version
Before downloading the right patches for Oracle GoldenGate, we have to know the current release no.
There're 2 ways to check the release number of Oracle GoldenGate.
Specify OH (Oracle Home) Parameter
Here we use additional parameter -OH (OH stands for Oracle Home) to specify the Oracle Home we want to check.
[oracle@ora12c ~]$ export OGG_HOME=/ogghome
[oracle@ora12c ~]$ opatch lsinventory -oh $OGG_HOME
Oracle Interim Patch Installer version 12.2.0.1.6
Copyright (c) 2024, Oracle Corporation. All rights reserved.
Oracle Home : /ogghome
Central Inventory : /u01/app/oraInventory
from : /ogghome/oraInst.loc
OPatch version : 12.2.0.1.6
OUI version : 12.2.0.1.4
Log file location : /ogghome/cfgtoollogs/opatch/opatch2024-08-28_19-53-37PM_1.log
Lsinventory Output file location : /ogghome/cfgtoollogs/opatch/lsinv/lsinventory2024-08-28_19-53-37PM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: ora12c
ARU platform id: 226
ARU platform description:: Linux x86-64
Installed Top-level Products (1):
Oracle GoldenGate Core 12.3.0.1.2
There are 1 products installed in this Oracle Home.
There are no Interim patches installed in this Oracle Home.
--------------------------------------------------------------------------------
OPatch succeeded.
Switch to OGG Home
To get the version information correctly and prevent error "OPatch failed with error code 19", we have to set ORACLE_HOME to GoldenGate's Home.
[oracle@ora12c ~]$ export ORACLE_HOME=$OGG_HOME
[oracle@ora12c ~]$ export PATH=$PATH:$ORACLE_HOME/OPatch
[oracle@ora12c ~]$ which opatch
/u01/app/oracle/product/12.2.0/dbhome_1/OPatch/opatch
[oracle@ora12c ~]$ opatch lsinventory
Oracle Interim Patch Installer version 12.2.0.1.6
Copyright (c) 2024, Oracle Corporation. All rights reserved.
Oracle Home : /ogghome
Central Inventory : /u01/app/oraInventory
from : /ogghome/oraInst.loc
OPatch version : 12.2.0.1.6
OUI version : 12.2.0.1.4
Log file location : /ogghome/cfgtoollogs/opatch/opatch2024-08-28_20-23-15PM_1.log
Lsinventory Output file location : /ogghome/cfgtoollogs/opatch/lsinv/lsinventory2024-08-28_20-23-15PM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: ora12c
ARU platform id: 226
ARU platform description:: Linux x86-64
Installed Top-level Products (1):
Oracle GoldenGate Core 12.3.0.1.2
There are 1 products installed in this Oracle Home.
There are no Interim patches installed in this Oracle Home.
--------------------------------------------------------------------------------
OPatch succeeded.
It's Oracle GoldenGate Core 12.3.0.1.2. By the way, the OUI version is 12.2.0.1.4.