Skip to content
Home » Oracle Database » GoldenGate » How to Check GoldenGate Version

How to Check GoldenGate Version

GoldenGate Versions

Currently, there're several GoldenGate versions in Oracle:

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.

Leave a Reply

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