Patching Oracle GoldenGate Microservices Architechture Using OPatch

Perform the following prerequisites before installing the patch:

Download and install the most recent release of OPatch, and keep note of the installation directory where you installed the OPatch release.

Details from where to download OPatch is available at: How To Download And Install The Latest OPatch(6880880) Version (Doc ID 274526.1)
Download the Oracle GoldenGate patch and maintain a location for storing the contents of the patch ZIP file. This location or the absolute path is referred to as patch_top_dir in subsequent steps.
Navigate to the patch_top_dir directory and run the following command to extract the contents of the patch ZIP file to the location you created previously.

$ cd patch_top_dir

$ unzip patch_number_version_platform.zip
Navigate to the unzipped patch directory:

$ cd patch_top_dir/patch_number_dir
Set the ORACLE_HOME environment variable to the Oracle GoldenGate installation directory:

$ export ORACLE_HOME=GoldenGate_Installation_Path
Set the PATH environment variable to include the locations of the $ORACLE_HOME and OPatch directories.
```
$ export PATH=$PATH:$ORACLE_HOME:/OPatch
```
Verify the Oracle inventory, which OPatch accesses to install the patches. To verify the inventory, run the following command:
```
$ opatch lsinventory
```
If the command displays any errors, contact Oracle Support to resolve the issue.
Run the OPatch prerequisites check and verify that it passes.
```
$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
```
If any errors are displayed, identify the error type. OPatch categorizes conflicts or errors in the following types:
- Conflicts with a patch already applied to the ORACLE_HOME: In this case, stop the patch installation and contact Oracle Support Services.
- Conflicts with a patch already applied to the ORACLE_HOME that is a subset of the patch you are trying to apply: In this case, continue with the patch installation because the new patch contains all the fixes from the existing patch in the ORACLE_HOME. The subset patch will automatically be rolled back prior to the installation of the new patch.
Before patching Oracle GoldenGate, if you have any deployments for the installation, ensure that you shut down all processes such as Extracts, Replicats, and Distribution paths, and stop all services for the deployments.

This can be done in the Administration Service’s and Service Manager’s WebUI, or in the Admin Client.

If using the Admin Client, perform the following steps to connect to each deployment and stop all processes.

If using the Admin Client, connect to each deployment and stop all processes.

Start the Admin Client and connect to the deployment.

$ /GoldenGate_Installation_Path/bin/adminclient
OGG (not connected) 1>CONNECT https://host:srv_mgrport 
DEPLOYMENT <deployment-name> AS <user> PASSWORD <password>

Stop the Extract and Replicat processes and the Distribution Paths.
```
STOP ER *
STOP DISTPATH ALL
```
Stop the services for the deployment and verify that they are all stopped:
```
STOP SERVICE *
STATUS SERVICE *
```

Exit the Admin Client and stop the Service Manager:

OGG (https://host:port deployment-name) exit

	    ##Command for Service Manager not registered as a service/daemon 
	    $ export OGG_VAR_HOME=OGG_SRVMGR_DIRECTORY/var
	    $ export OGG_ETC_HOME=OGG_SRVMGR_DIRECTORY/etc  
	    $ OGG_SRVMGR_DIRECTORY/bin/stopSM.sh
	
##Command for Service Manager registered as a service/daemon
$ sudo systemctl stop OracleGoldenGate

Disconnect all user sessions to the deployment as well as close all running Oracle GoldenGate programs, including Admin Client.

Perform the following steps to install the patch:
Install the patch by running the following command:
```
$ opatch apply
```
When the OPatch command starts, it validates the patch and ensures that there are no conflicts with the software already installed in ORACLE_HOME of the Oracle GoldenGate release.
After the patch installation completes, run the following command to verify that the Oracle inventory contains the installed patch:
```
$ opatch lsinventory
```

After the patch installation completes, start the Service Manager, the services, and Oracle GoldenGate processes.

Start the Service Manager:

##Command for Service Manager not registered as a service/daemon 
$ export OGG_VAR_HOME=OGG_SRVMGR_DIRECTORY/var
$ export OGG_ETC_HOME=OGG_SRVMGR_DIRECTORY/etc  
$ OGG_SRVMGR_DIRECTORY/bin/startSM.sh
	
##Command for Service Manager registered as a service/daemon
$ sudo systemctl start OracleGoldenGate

Start the Admin Client and connect to the deployment.

$ /GoldenGate_Installation_Path/bin/adminclient
OGG (not connected) 1>CONNECT https://host:srvmgr_port DEPLOYMENT 
deployment-name AS user PASSWORD password

Start services for the deployment and verify that they are all running:
```
START SERVICE *
STATUS SERVICE *
```
Start the Extract, Replicat and Distribution paths:
```
START ER *
START DISTPATH ALL
```

Parent topic: Installing Patches for Oracle GoldenGate Microservices Architecture