Today I worked on silent upgrade of Oracle GoldenGate from 12.1.2.0.0 to 12.1.2.1.2, so thought to blog it which might help some of you. These are the steps I performed
Current GoldenGate Home –> /oracle/app/product/ogg12.1.2
1. Gather the details of GoldenGate Processes before stopping them
GGSCI> INFO EXTRACT EXTL, SHOWCH INFO EXTRACT DPUMP, SHOWCH GGSCI> SEND EXTRACT EXTL, SHOWTRANS GGSCI> STOP EXTRACT DPUMP GGSCI> STOP EXTRACT EXTL GGSCI> SEND REPLICAT REPL STATUS GGSCI> STOP REPLICAT REPL GGSCI> STOP JAGENT GGSCI> STOP MANAGER
2. Backup the existing binaries and associated files needed for your environment.
3. Edit the response file and run the runInstaller in silent mode
In the response file
#------------------------------------------------------------------------------- # Specify the installation option. # Specify ORA12c for installing Oracle GoldenGate for Oracle Database 12c and # ORA11g for installing Oracle GoldenGate for Oracle Database 11g #------------------------------------------------------------------------------- INSTALL_OPTION=ORA11g #------------------------------------------------------------------------------- # Specify a location to install Oracle GoldenGate #------------------------------------------------------------------------------- SOFTWARE_LOCATION=/oracle2/app/product/ogg12.1.2 #------------------------------------------------------------------------------- # Specify true to start the manager after installation. #------------------------------------------------------------------------------- START_MANAGER=false #------------------------------------------------------------------------------- # Specify a free port within the valid range for the manager process. # Required only if START_MANAGER is true. #------------------------------------------------------------------------------- MANAGER_PORT= #------------------------------------------------------------------------------- # Specify the location of the Oracle Database. # Required only if START_MANAGER is true. #------------------------------------------------------------------------------- DATABASE_LOCATION= #------------------------------------------------------------------------------- # Specify the location which holds the install inventory files. # This is an optional parameter if installing on # Windows based Operating System. #------------------------------------------------------------------------------- INVENTORY_LOCATION=/oracle/oraInventory #------------------------------------------------------------------------------- # Unix group to be set for the inventory directory. # This parameter is not applicable if installing on # Windows based Operating System. #------------------------------------------------------------------------------- UNIX_GROUP_NAME=oinstall
Run the runInstaller in Silent mode
[oracle@oracle gg]$ export ORACLE_HOME=/oracle/app/product/ogg12.1.2 [oracle@oracle gg]$ export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH [oracle@oracle gg]$ export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH [oracle@oracle Disk1]$ ./runInstaller -silent -showProgress -waitforcompletion -responseFile /opt/oracle/ogg_upg.rsp Starting Oracle Universal Installer... Checking Temp space: must be greater than 120 MB. Actual 181836 MB Passed Checking swap space: must be greater than 150 MB. Actual 11999 MB Passed Preparing to launch Oracle Universal Installer from /tmp/OraInstall2015-04-21_12-23-03AM. Please wait ...You can find the log of this install session at: /oracle/oraInventory/logs/installActions2015-04-21_12-23-03AM.log Prepare in progress. .................................................. 10% Done. Prepare successful. Copy files in progress. .................................................. 44% Done. .................................................. 50% Done. .................................................. 60% Done. .................................................. 65% Done. .................................................. 72% Done. .................... Copy files successful. Link binaries in progress. .......... Link binaries successful. .................................................. 82% Done. Setup files in progress. .................................................. 100% Done. Setup files successful. The installation of Oracle GoldenGate Core was successful. Please check '/oracle/oraInventory/logs/silentInstall2015-04-21_12-23-03AM.log' for more details. Successfully Setup Software. [oracle@oracle1 Disk1]$
4. Confirm GoldenGate has been upgraded
[oracle@oracle Disk1]$ cd $ORACLE_HOME [oracle@oracle ogg12.1.2]$ [oracle@oracle ogg12.1.2]$ ./ggsci Oracle GoldenGate Command Interpreter for Oracle Version 12.1.2.1.0 OGGCORE_12.1.2.1.0_PLATFORMS_140727.2135.1_FBO Linux, x64, 64bit (optimized), Oracle 11g on Aug 7 2014 09:14:25 Operating system character set identified as UTF-8. Copyright (C) 1995, 2014, Oracle and/or its affiliates. All rights reserved.
5. Apply Patch 20265694: Oracle GoldenGate V12.1.2.1.2 for Oracle 11G
[oracle@oracle1 20265694]$ opatch apply
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/ogg12.1.2
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/ogg12.1.2/cfgtoollogs/opatch/opatch2015-04-21_00-24-15AM.log
Applying interim patch '20265694' to OH '/oracle/app/product/ogg12.1.2'
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/ogg12.1.2')
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 20265694 successfully applied
Log file location: /oracle/app/product/ogg12.1.2/cfgtoollogs/opatch/opatch2015-04-21_00-24-15AM.log
OPatch succeeded.
[oracle@oracle1 20265694]$
[oracle@oracle1 20265694]$ opatch lsinv
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.
........................
........................
Patch 20265694 : applied on Tue Apr 21 00:24:27 EDT 2015
Unique Patch ID: 18593256
Created on 3 Feb 2015, 15:03:21 hrs PST8PDT
Bugs fixed:
19818362, 19602692, 19241234, 17423191, 19781984, 19535319, 19724915
19721652, 19516537, 19441114, 19132627, 19889991, 19681035
6. Confirm the GoldenGate version is now 12.1.2.1.2
[oracle@oracle ogg12.1.2]$ ./ggsci Oracle GoldenGate Command Interpreter for Oracle Version 12.1.2.1.2 20133048 OGGCORE_12.1.2.1.0OGGBP_PLATFORMS_141228.0533_FBO Linux, x64, 64bit (optimized), Oracle 11g on Dec 28 2014 13:19:44 Operating system character set identified as UTF-8. Copyright (C) 1995, 2015, Oracle and/or its affiliates. All rights reserved.
7. Start the GoldenGate Processes
GGSCI (oracle.test.com) 1> dblogin userid ggate, Password "xxxxxxxx" Successfully logged into database. GGSCI> START MANAGER GGSCI> START JAGENT GGSCI> START EXTRACT EXTL GGSCI> START EXTRACT DPUMP GGSCI> START REPLICAT REPL
Learn. Share. Repeat. 
super