Overview
In this document we will perform Upgrade of oracle
GoldenGate 12c from 12.1.2.1.0 to 12.1.2.1.10
GoldenGate 12c from 12.1.2.1.0 to 12.1.2.1.10
Environment Details
|
Hostname
|
Node1
and Node2 |
|
Operating
system |
Linux
|
|
Environment
|
Production
|
|
Oracle
Home |
/u01/app/oracle/product/11.2.0/db
|
|
GoldenGate
software staging location |
/u01/app/oracle/software/OGG12c
|
|
GoldenGate
Shared Home |
/oraggs/app/ggs12c/ggs
|
Software requirement:
Download the Oracle GoldenGate 12.1.2.1.10
(p21785294_1212110_Linux-x86-64.zip)
patch from My Oracle support by entering the following URL into your web
browser: http://support.oracle.com
Steps to Upgrade Oracle GoldenGate Software
(p21785294_1212110_Linux-x86-64.zip)
patch from My Oracle support by entering the following URL into your web
browser: http://support.oracle.com
Steps to Upgrade Oracle GoldenGate Software
- Create staging area for GoldenGate
software.
$ cd /u01/app/oracle/software/
$ mkdir OGG12c
Copy
downloaded Oracle GoldenGate 12c Base software to Node 1
downloaded Oracle GoldenGate 12c Base software to Node 1
- Unzip the Goldengate patch from
directory OGG12c
$ cd /u01/app/oracle/software/OGG12c
$ unzip
p21785294_1212110_Linux-x86-64.zip
p21785294_1212110_Linux-x86-64.zip
- Navigate to Oracle GoldenGate 12c home and validate
OraInventory
$ cd /oraggs/app/gg12c
$ cd OPatch
$ ./opatch lsinventory
Invoking OPatch 11.2.0.1.7
Oracle Interim Patch Installer version
11.2.0.1.7
11.2.0.1.7
Copyright (c) 2011, Oracle
Corporation. All rights reserved.
Corporation. All rights reserved.
Oracle Home : /oraggs/app/gg12c
Central Inventory :
/oraggs/app/oraInventory
/oraggs/app/oraInventory
from : /etc/oraInst.loc
OPatch version : 11.2.0.1.7
OUI version : 11.2.0.3.0
Log file location :
/oraggs/app/gg12c/cfgtoollogs/opatch/opatch2016-01-13_13-21-12PM.log
/oraggs/app/gg12c/cfgtoollogs/opatch/opatch2016-01-13_13-21-12PM.log
Lsinventory Output file location :
/oraggs/app/gg12c/cfgtoollogs/opatch/lsinv/lsinventory2016-01-13_13-21-12PM.txt
/oraggs/app/gg12c/cfgtoollogs/opatch/lsinv/lsinventory2016-01-13_13-21-12PM.txt
——————————————————————————–
Installed Top-level Products (1):
Oracle GoldenGate Core
12.1.2.1.0
12.1.2.1.0
There are 1 products installed in this
Oracle Home.
Oracle Home.
There are no
Interim patches installed in this Oracle Home.
Interim patches installed in this Oracle Home.
OPatch succeeded.
- Verify the Opatch version
$ cd /oraggs/app/gg12c/OPatch
[oracle@Node1 OPatch]$ ./opatch
version
Invoking OPatch 11.2.0.1.7
OPatch Version: 11.2.0.1.7
OPatch succeeded.
- Set Oracle Home variable to Oracle
GoldenGate 12c software location
$ export ORACLE_HOME=/oraggs/app/gg12c
- Ensure Oracle GoldenGate Processes are offline.
./ggsci
GGSCI> info all
- Stop Oracle GoldenGate Processes as follows:
./ggsci
GGSCI> stop er *
GGSCI> stop mgr!
GGSCI> stop mgr!
- Navigate to GoldenGate patch location
and apply the patch
$ cd
/oraggs/app/oracle/software/OGG12c/21785294
$ /oraggs/app/gg12c/OPatch/opatch apply
- Verify the patch is applied to
GoldenGate 12c Home
$ cd /oraggs/app/gg12c/OPatch
$ ./opatch lsinventory
Invoking OPatch 11.2.0.1.7
Oracle Interim Patch Installer version
11.2.0.1.7
11.2.0.1.7
Copyright (c) 2011, Oracle
Corporation. All rights reserved.
Corporation. All rights reserved.
Oracle Home : /oraggs/app/ggs12c/ggs
Central Inventory :
/oraggs/app/oraInventory
/oraggs/app/oraInventory
from : /etc/oraInst.loc
OPatch version : 11.2.0.1.7
OUI version : 11.2.0.3.0
Log file location :
/oraggs/app/ggs12c/ggs/cfgtoollogs/opatch/opatch2016-01-13_14-37-10PM.log
/oraggs/app/ggs12c/ggs/cfgtoollogs/opatch/opatch2016-01-13_14-37-10PM.log
Lsinventory Output file location :
/oraggs/app/ggs12c/ggs/cfgtoollogs/opatch/lsinv/lsinventory2016-01-13_14-37-10PM.txt
/oraggs/app/ggs12c/ggs/cfgtoollogs/opatch/lsinv/lsinventory2016-01-13_14-37-10PM.txt
——————————————————————————–
Installed Top-level Products (1):
Oracle GoldenGate Core
12.1.2.1.0
12.1.2.1.0
There are 1 products installed in this
Oracle Home.
Oracle Home.
Interim patches (1) :
Patch
21785294 : applied on Mon Nov
23 21:30:51 PST 2015
21785294 : applied on Mon Nov
23 21:30:51 PST 2015
Unique Patch ID: 19375140
Created on 3 Sep 2015, 10:27:21 hrs PST8PDT
Bugs fixed:
21181052, 19241234, 20660883, 21473564, 20898978, 21180187, 19132627
20643144, 21131159, 18875912, 20543714, 21079205, 20996660, 20367405
20803745, 20657667, 19889991, 20659379, 20045536, 19987316, 20554464
19142865, 19681198, 19813884, 20347665, 20148126, 20917331, 19048634
21182116, 19920244, 19798268, 19602692, 19535319, 19441114, 21110369
19374174, 20664851, 21045025, 20681946, 19903590, 19724915, 21165823
19327073, 20531064, 21226965, 19818362, 20021370, 20724906, 21124385
21328574, 19264441, 18996447, 21345919, 21329486, 21090428, 19414121
19545128, 21121987, 20648352, 19721652, 20418503, 21209445, 21246170
20853556, 20756705, 21103736, 17866697, 16084751, 20778054, 21111031
20853777, 19244349, 20092876, 20782113, 20343181, 20532340, 20951173
20660006, 19067094, 19560158, 20577891, 18958026, 17423191, 20641896
19624524, 19516537, 20563015, 20078949, 21026962, 19681035, 20213167
19782389, 20679687, 19781984, 19594967, 20878216, 20989581
——————————————————————————–
OPatch succeeded.
- Verify the new Oracle GoldenGate 12c
version is 12.1.2.1.10
$ cd /oraggs/app/gg12c
$ ./ggsci –v
$ cd /oraggs/app/ggs12c/ggs
$ ./ggsci –v
Oracle GoldenGate Command Interpreter
for Oracle
for Oracle
Version 12.1.2.1.10 21604177
OGGCORE_12.1.2.1.0OGGBP_PLATFORMS_150902.1337_FBO
OGGCORE_12.1.2.1.0OGGBP_PLATFORMS_150902.1337_FBO
Linux, x64, 64bit (optimized), Oracle
11g on Sep 2 2015 20:46:03
11g on Sep 2 2015 20:46:03
Copyright (C) 1995, 2015, Oracle and/or
its affiliates. All rights reserved
its affiliates. All rights reserved
Conclusion:
In this article we have learnt how to Upgrade Oracle
GoldenGate 12c from 12.1.2.1.0 to 12.1.2.1.10
In this article we have learnt how to Upgrade Oracle
GoldenGate 12c from 12.1.2.1.0 to 12.1.2.1.10
Leave a Reply