Recently, I’ve been engaged in a conversation on the OTN community pages about upgrading Oracle GoldenGate 12c from 18.104.22.168.0 to the 22.214.171.124.0. During the discussion I mentioned that you can upgrade using the Oracle Universal Installer (OUI) that is now available with Oracle GoldenGate 12c. The upgrade process I’m going to show you here is an in-place upgrade of Oracle GoldenGate 12c for Oracle Database 12c.
Note: Before doing any upgrades of Oracle GoldenGate, make sure to stop all processes and backup your existing binaries and associated files needed for your environment.
The first thing that needs to be done is to download the 126.96.36.199.0 binaries from either edelivery.oracle.com or My Oracle Support (Image 1).
After downloading the new binaries to a location where they can be extracted; they need to be unzipped.
[code language=”css”] $ unzip ./OracleGoldenGate12121.zip -d ./ggate12121 [/code]
Once the binaries are unzipped, lets go into the ./ggate12121 directory to find the runInstaller. On my system the runInstaller is found at this location.
Before running the runInstaller, I need to make sure that all my Oracle GoldenGate processes are down. Since this is on my target (test) system, that means the manager, all replicats and collector processes should be stopped. A simple “ps -ef” command can help identify what is running.
[code language=”css”] $ ps -ef | grep dirpm oracle 2401 1 0 22:47 ? 00:00:00 ./mgr PARAMFILE /opt/app/oracle/product/12.1.2/oggcore_1/dirprm/MGR.prm REPORTFILE /opt/app/oracle/product/12.1.2/oggcore_1/dirrpt/MGR.rpt PROCESSID MGR USESUBDIRS oracle 2407 2401 1 22:47 ? 00:00:02 /opt/app/oracle/product/12.1.2/oggcore_1/replicat PARAMFILE /opt/app/oracle/product/12.1.2/oggcore_1/dirprm/REP.prm REPORTFILE /opt/app/oracle/product/12.1.2/oggcore_1/dirrpt/REP.rpt PROCESSID REP USESUBDIRS $ ps -ef | grep server oracle 2486 1848 0 22:51 pts/0 00:00:00 grep server [/code]
After identifying the processes, they need to be stopped from within GGSCI.
[code language=”css”] Oracle GoldenGate Command Interpreter for Oracle Version 188.8.131.52.0 17185003 OGGCORE_184.108.40.206.0_PLATFORMS_130924.1316_FBO Linux, x64, 64bit (optimized), Oracle 12c on Sep 25 2013 02:33:54 Operating system character set identified as UTF-8. Copyright (C) 1995, 2013, Oracle and/or its affiliates. All rights reserved. GGSCI (ggtest2.acme.com) 1> info all Program Status Group Lag at Chkpt Time Since Chkpt MANAGER RUNNING <br />REPLICAT RUNNING REP 45:06:32 00:04:35 GGSCI (ggtest2.acme.com) 2> stop er * Sending STOP request to REPLICAT REP … Request processed. GGSCI (ggtest2.acme.com) 3> stop mgr ! Sending STOP request to MANAGER … Request processed.<br />Manager stopped. GGSCI (ggtest2.acme.com) 9> info all Program Status Group Lag at Chkpt Time Since Chkpt MANAGER STOPPED <br />REPLICAT STOPPED REP 45:14:08 00:00:05 [/code]
To verify that everything has been stopped, the “ps -ef” command can be ran to verify. After verifying that everything is stopped, the runInstaller can be used to start the OUI for the upgrade (Image 2).
Notice that there are 5 steps to the OUI. Also notice that there is not an “upgrade” option. Not to worry, we can still perform the upgrade. Since this is an upgrade of Oracle GoldenGate 12c for Oracle Database 12c, make sure to select the option for Oracle Database 12c (default), then click the next button.
On the Installation screen, the location of the existing binaries need to be selected from the drop down box for Software Location. In the example, the location is /opt/app/oracle/product/12.1.2/oggcore_1. Also notice in image 3, that I do not want the manager process to start. After making sure everything is correct and as expected, click Next.
Note: The information on this screen is read from the oraInventory files. Make sure you know where the oraInventory located and set as needed.
The wizard now moves to the Summary screen (Image 4). On this screen, the typical information is seen. Click Install when ready.
Image 5 shows the progress of the install/upgrade.
After the install/upgrade is done (Image 6), we get a nice message saying that it was successful.
Once the upgrade is complete, then the Oracle GoldenGate processes (manger, replicats) can be restarted. Notice that the version of Oracle GoldenGate 12c that is running now is 220.127.116.11.0
[code language=”css”] [[email protected] Disk1]$ cd /opt/app/oracle/product/12.1.2/oggcore_1 [[email protected] oggcore_1]$ pwd /opt/app/oracle/product/12.1.2/oggcore_1 [[email protected] oggcore_1]$ . oraenv ORACLE_SID = [oracle] ? remote12c The Oracle base has been set to /opt/app/oracle [[email protected] oggcore_1]$ ./ggsci Oracle GoldenGate Command Interpreter for Oracle Version 18.104.22.168.0 OGGCORE_22.214.171.124.0_PLATFORMS_140727.2135.1_FBO Linux, x64, 64bit (optimized), Oracle 12c on Aug 7 2014 10:21:34 Operating system character set identified as UTF-8. Copyright (C) 1995, 2014, Oracle and/or its affiliates. All rights reserved.</p>
<p>GGSCI (ggtest2.acme.com) 1> info all Program Status Group Lag at Chkpt Time Since Chkpt MANAGER STOPPED <br />REPLICAT STOPPED REP 45:14:08 00:24:08 GGSCI (ggtest2.acme.com) 2> start mgr Manager started. GGSCI (ggtest2.acme.com) 3> start replicat rep Sending START request to MANAGER … REPLICAT REP starting GGSCI (ggtest2.acme.com) 4> info all Program Status Group Lag at Chkpt Time Since Chkpt MANAGER RUNNING REPLICAT RUNNING REP 45:39:08 00:00:01 [/code]
As you can tell the upgrade from Oracle GoldenGate 12c (126.96.36.199.0) to Oracle GoldenGate 12c (188.8.131.52.0) can be completed using the Oracle Universal Installer that now comes with Oracle GoldenGate 12c. I wish Oracle would give an option for an upgrade in the OUI, it would cut down on some confusion when it comes to upgrades with Oracle GoldenGate using the OUI.