Consider the Oracle Golden Gate 19c was already installed, and of course, the patches should be taken care of as soon as they are available to address the security vulnerability issues.
The first step is to download and unzip the patch in the staging location
(oracle):PRODT@ORA-X2:/u04/backup/install> ls -ltr total 58760 -rw-r--r-- 1 oracle oinstall 1413 Mar 1 2021 OGG-19.1.0.0-README.txt -rw-r--r-- 1 oracle oinstall 554021 Mar 2 10:08 Oracle_GoldenGate_19.1.0.0.220212_release_notes.pdf drwxr-xr-x 4 oracle oinstall 28 Mar 2 20:00 33883146 -r--r----- 1 oracle oinstall 4158 Mar 3 04:59 README_ora19c.txt -rw-r----- 1 oracle oinstall 59598297 Jun 2 13:39 p33883146_19100220212_Linux-x86-64.zip (oracle):PRODT@ORA-X2:/u04/backup/install>
Access the patch location and apply the patch as below
(oracle):ogg@ORA-X2:/u01/app/oracle/product/OGG_19.1.0/ogghome_1> cd /u04/backup/install/ (oracle):ogg@ORA-X2:/u04/backup/install> cd 33883146/ (oracle):ogg@ORA-X2:/u04/backup/install/33883146> pwd /u04/backup/install/33883146 (oracle):ogg@ORA-X2:/u04/backup/install/33883146> /u01/app/oracle/product/OGG_19.1.0/ogghome_1/OPatch/opatch apply Oracle Interim Patch Installer version 12.2.0.1.18 Copyright (c) 2021, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/oracle/product/OGG_19.1.0/ogghome_1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/OGG_19.1.0/ogghome_1/oraInst.loc OPatch version : 12.2.0.1.18 OUI version : 12.2.0.4.0 Log file location : /u01/app/oracle/product/OGG_19.1.0/ogghome_1/cfgtoollogs/opatch/opatch2022-05-02_14-19-50PM_1.log Verifying environment and performing prerequisite checks... OPatch continues with these patches: 33883146 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 = '/u01/app/oracle/product/OGG_19.1.0/ogghome_1') Is the local system ready for patching? [y|n] y User Responded with: Y Backing up files... Applying interim patch '33883146' to OH '/u01/app/oracle/product/OGG_19.1.0/ogghome_1' Patching component oracle.oggcore.ora19c, 19.1.0.0.0... Patch 33883146 successfully applied. Log file location: /u01/app/oracle/product/OGG_19.1.0/ogghome_1/cfgtoollogs/opatch/opatch2022-05-02_14-19-50PM_1.log OPatch succeeded.
Verify the patches information using opatch.
(oracle):ogg@ORA-X2:/u04/backup/install/33883146> /u01/app/oracle/product/OGG_19.1.0/ogghome_1/OPatch/opatch lspatches 33883146; OPatch succeeded. (oracle):ogg@ORA-X2:/u04/backup/install/33883146>
Finally, verify the Golden Gate Version using GGSCI.
(oracle):PRODT@ORA-X2:/u01/app/oracle/product/OGG_19.1.0/ogghome_1> pwd /u01/app/oracle/product/OGG_19.1.0/ogghome_1 (oracle):PRODT@ORA-X2:/u01/app/oracle/product/OGG_19.1.0/ogghome_1> ./ggsci -v Oracle GoldenGate Command Interpreter for Oracle Version 19.1.0.0.220212 OGGCORE_19.1.0.0.0OGGBP_PLATFORMS_210218.2155_FBO Linux, x64, 64bit (optimized), Oracle 19c on Mar 1 2021 02:29:51 Copyright (C) 1995, 2021, Oracle and/or its affiliates. All rights reserved. (oracle):PRODT@ORA-X2:/u01/app/oracle/product/OGG_19.1.0/ogghome_1>
