1. Installing Oracle GoldenGate Classic Architecture
  2. Patching Oracle GoldenGate Classic Architecture for Oracle Database

4 Patching Oracle GoldenGate Classic Architecture for Oracle Database

Patches for Oracle GoldenGate for Oracle Database can be found on My Oracle Support when available, and are located under the Patches and Updates section of MOS.

Cumulative and one-off patches for Oracle GoldenGate can be applied on top of a base release or previously patched release, or they may be a one-off patch that should be applied to a specific Oracle GoldenGate version. The instructions in the subsequent topic apply to both types of patches.

Learn to prepare and install patches using OPatch for Classic Architecture.

Topic:

Downloading Patches for Oracle GoldenGate

Download the appropriate patches for the Oracle GoldenGate build for each system that will be part of the Oracle GoldenGate configuration.

  1. Using a browser, navigate to http://support.oracle.com.
  2. Log in with your Oracle ID and password.
  3. Select the Patches and Upgrades tab.
  4. On the Search tab, click Product or Family.
  5. In the Product field, type Oracle GoldenGate.
  6. From the Release drop-down list, select the release version that you want to download.
  7. Make certain that Platform is displayed as the default in the next field, and then select the platform from the drop-down list.
  8. Leave the last field blank.
  9. Click Search.
  10. In the Patch Advanced Search Results list, select the patch that best meets your search criteria, making certain that the Oracle GoldenGate patch that you select corresponds to the database that will be used.

    When you select the build, a dialog box pops up under the build description, and then you are advanced to the download page.

  11. Click the Patch file name link for each patch that you want to download. The File Download dialog box appears.
  12. Select either Open with or Save File:
    To... Select...

    Extract the patch immediately

    Open with, then select the desired file extraction utility and extract the files to a location on your file system.

    Save the patch for later extraction

    Select Save file, then save to a directory on your file system.

Note:

Before installing the software, see Oracle GoldenGate Release Notes for any new features, parameter changes, upgrade requirements, known issues, or bug fixes that affect your current configuration.

Parent topic: Patching Oracle GoldenGate Classic Architecture for Oracle Database

Patching Oracle GoldenGate Classic Architechture Using OPatch

Perform the following prerequisites before installing the patch:

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

    Details from where to download OPatch is available at: How To Download And Install The Latest OPatch(6880880) Version (Doc ID 274526.1)

  2. 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 the subsequent steps.

  3. 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

  4. Navigate to the unzipped patch directory:

    $ cd patch_top_dir/patch_number_dir

  5. Set the ORACLE_HOME environment variable to the Oracle GoldenGate installation directory:

    $ export ORACLE_HOME=GoldenGate_Installation_Path

  6. Set the PATH environment variable to include the locations of the $ORACLE_HOME and OPatch directories. 

    $ export PATH=$PATH:$ORACLE_HOME:/OPatch

  7. Run the following command to verify the Oracle inventory, which OPatch accesses to install the patches:

    $ opatch lsinventory

    If the command displays any errors, contact Oracle Support to resolve the issue.

  8. 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 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.

  9. Before patching Oracle GoldenGate, ensure that you shut down all processes such as Extracts and Replicats, and stop all other services such as the Oracle GoldenGate Monitor JAgent and Performance Metrics Service.

    1. Use the Oracle GoldenGate Software Command Interface (ggsci) in the GoldenGate Software Home to stop all processes. 

      $ ./ggsci
    2. Stop the Extract and Replicat processes and the Distribution Paths.
      GGSCI> STOP ER *

    3. If monitoring is enabled, stop the GoldenGate Monitor JAgent and Performance Metrics Service.

      GGSCI> STOP PMSRVR
GGSCI> STOP JAGENT
    4. Stop the Manager process.
      GGSCI> STOP MGR!

    5. Re-check to verify that all processes have stopped. 

      GGSCI> INFO ALL

    6. Exit the Oracle GoldenGate Software Command Interface.

      GGSCI> EXIT

    Perform the following steps to install the patch:

  10. 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.

  11. After the patch installation completes, run the following command to verify that the Oracle inventory contains the installed patch:

    $ opatch lsinventory

  12. Start the Manager, followed by the other services such as GoldenGate Monitor JAgent and Performance Metrics Service, and the Oracle GoldenGate processes.

    1. Use Oracle GoldenGate Software Command Interface (ggsci) in the GoldenGate Software Home to start all processes and services. 

      $ ./ggsci

    2. Start the Manager process.

      GGSCI> START MGR

    3. If monitoring was enabled, start the GoldenGate Monitor JAgent and Performance Metrics Service.

      GGSCI> START PMSRVR
GGSCI> START JAGENT

    4. Start the Extracts and the Replicats.

      GGSCI> START ER *

    5. Check the status and verify that all processes and services are running.

      GGSCI> INFO ALL

Parent topic: Patching Oracle GoldenGate Classic Architecture for Oracle Database

Uninstalling the Patch for Oracle and Non-Oracle Databases Using OPatch

To uninstall the patch, follow these steps:

  1. Install the latest OPatch version, set the required environment variables, and stop the Oracle GoldenGate processes and services. The patch installation steps are documented in the previous topic.

  2. Navigate to the patch_top_dir/patch_number directory:
    $ cd patch_top_dir/patch_number

  3. Uninstall the patch by running the following command:

    $ opatch rollback -id patch_number

  4. Start the services and processes from the Oracle GoldenGate home.

Parent topic: Patching Oracle GoldenGate Classic Architecture for Oracle Database