Oracle Goldengate - Apply Patch

Hi, good evening everyone. So today we are going to discuss one of the most important topic related to GoldenGate, how to apply patch in Oracle GoldenGate. So this is one of the most common thing which we have to do regularly. The reason being Oracle releases their patch to fix some bug which is not covered, not at all fixed in the base for release or they tend to roll out their patches. So based on the bug you identified in your environment, you have to apply the patch. So what are the steps you are going to follow to apply the patch? We are going to discuss here. So the need for applying the patch in my environment came due to this replicate checkpoint not happening. So I'll find here, time since checkpoint will continue to increase. Now I found that they have rolled out one patch. My GoldenGate version is, let me log in and show it to you. So GoldenGate version is 12.2.0.1.1. So herein we have known issues for the replicate checkpoint. So I found one patch I raised in SR with Oracle, they gave me one patch to resolve the issue. So I have to download that patch from support.oracle.com. So I'll sign in, I'll then go to patches and updates. And therein I type 22927739 is the patch number. I know the patch number and I know the environment for which I have to download. So I'll click on search. So when I search over here, I'll find my patch. So I'll download it. Before downloading, I would like to go ahead and read me. So my patching is, the reason for applying the patch is this reason, I can see. Wrong checkpoint information for integrated replicate. So this is the known reason and they have cleared the fix 22830589. So I'm going to apply the patch now. So now what steps do I need to follow to apply the patch? So first and foremost thing is, you should take the backup of this GoldenGate directory. So before doing that, you have to stop the process. Stop all the process including datapump, replicate and extract. I filled the replicate because it won't stop on its own. Now start the backup. So cp gg-src to gg-src-bkp, I'll do. And I'll press enter for this. Once this cp-r gg-src-src-bkp, press enter. So the backup will take some time and it requires space. Make sure you have adequate space to take backup. The backup is required to ensure that you don't miss out anything so that if there is any issues while doing the patching, you are saved. So before taking the backup, you have to ensure that your processes are stopped. Before starting the backup, two things. You should have a backup, you should have processes stopped. So the backup is taken now. Now, next step is, now once the backup is completed, your processes are stopped. So what you need to do, you need to change the oracle-home. So export oracle-home. You need to export your oracle-home to your GoldenGate directory. So you have to change your oracle-home for patching purpose and point your oracle-home to GoldenGate directory. So I'm doing that. Once you are done, inside the GoldenGate directory, you have a directory called as opatch. So you have to include this location inside your path variable. So do echo path and then export path equal to already present location and add your opatch location over there. Now I'll add opatch path. This is required to invoke opatch, which is inside opatch. If I do ls-lart inside opatch, so I have to invoke this opatch. For this purpose, I need to include this path, this directory in the path variable. Now once we are done, now the downloading of this software, which we were downloading. So once you have identified, you can download the patch now from this location. Click on download. And once it downloads, click on download. Once it download is completed. So I have already downloaded it on my machine and transferred it to Linux box. It is already present. So this is the patch which was downloaded. So what I need to do now, next, once you have exported the oracle home to GoldenGate directory, included the opatch inside the path variable. Next step, you can now unzip it. Unzip p209, unzip it. Unzip, so the binaries are getting unzipped now. So unzipping will take inside. Actually, what happens when you unzip a folder with the directory name of patch number is created. If I do now, so we will have 22927739 directory as well. So I'm inside this patch number directory. So now you can check whether your path is set successfully or not by doing which opatch. So it will say opatch is inside this directory. And then you can check opatch lsinventry to confirm what all patches are currently present in this home. So it says that in this golden gate, in this oracle home, we will have oracle-golden-gate-12.2.0.0.0. And there are no interim patches installed in this oracle. So now to patch it, you need to execute command opatch apply. So it will check the prerequisite. It has some prerequisites such as space. You should have that much space available. So do you want to proceed? Why? Is the local system ready for patching? Yes. So now patching is in progress. So patching is going to take some time. It will take few minutes, basically. So while patching, you have to keep in mind you're not logged in to ggsci prompt. All the processes should be stopped. You should have taken the backup of this. If backup is not there, then you can always, you have the option of rolling back the patch, which we are going to see later on. However, it is always a good practice to take the backup before starting the patch. So it still says backing of files. So for the reference purpose, I have also prepared the document over here. So it says, before starting the patch, find the oracle home gghome, also ensure backup of existing GoldenGate directories and stop the processes before patch could be applied. Then you have to export oracle home, verify, do opatch ls inventory, and then complete the patching. So let us see what is the status of patching. So it is still patching component oracle, ogg-core-ora-12c. So still the patch is in progress. So once the patching would be complete, you will get the message, opatch succeeded. That means opatch has been applied. Now I'll go to previous directory, and now I'll do ggsci. So now I'm into ggsci prompt, and now you can see the version has been changed. While we have applied the version, the version has been changed. So I'll take a new session and do su-oracle. So when I do info all, now I can start the processes. Start mgr extint, start dpint and start reprun as well. Now I can also confirm whether the patch has been applied successfully or not. I can do opatch ls inventory. So when I do opatch ls inventory now, you will find now, earlier it said that no interim patches are installed. Now you can see it says interim patches. Patch 2292739 has been installed on, applied on Friday, Jan 27th, 170928 ESC. And bugs which are fixed inside this patch are these. So now all my processes must be up and running. So when I do info all, I'll find all my processes are up and running. So if you see now, the replicate checkpoint will happen every 10 seconds. If I do stats rep1, it has applied four updates which were pending. So by applying the patch, the checkpoint information is getting updated properly without any issues. Now suppose you have to roll back the patch. You can also roll back the patch. So for rolling back the patch, you have to ensure that all your processes are stopped. Same thing you have to do. Now after two days, suppose you have to, you come across and you have to roll back the patch. So what do you need to do? You need to stop all the processes, ensure that all the processes are stopped. Then stop the manager as well. Stop mgr, so all the processes are stopped, verified. Once you are done, you have to follow the same process of setting up the, pointing your Oracle home to GoldenGate directory and setting up the path. So we'll verify these settings. So path currently contains opatch, that is correct. And I'll check Oracle home should be pointing to GoldenGate directory. Yeah, this is correct. Now I need to go to directory and I'll roll back the patch. How, opatch rollback-id and patch number 22927739. So it says rollback session. Is the local system ready for patching? I'll say yes. See it says, please shut down Oracle instances running out of this Oracle home. So you have to ensure all the GoldenGate processes are stopped before you apply the patch. So right now I'm rolling back the patch. So it should be done. Again, it should be done in a few minutes. In fact, seconds. Rolling back there should not take much time. So if you have to verify again, you'll need to type opatch lsinventry and now it should get no patch installed over there. So that means you have successfully rolled back the patch. So I can do opatch lsinventry. So it says there are no interim patches installed in this Oracle home. So your rollback of patches also done. So this is how we do apply the patch in Oracle GoldenGate and we do rollback the patch. So keep, continue to watch more videos. So you can always join or reach out to me at my WhatsApp number is plus 9117208729978 and my call number is plus 14168715708 and I'm in Canada. Thank you. Thanks for watching this. Bye.