- Patching the Operating System (OS)
- Patching the Database
- Patching Oracle GoldenGate
1. Patching the OS
When patching the OS requires restarting the machine or changing the file system mount options, you need to stop all of the Oracle GoldenGate processes during the patching process. Otherwise, you can just keep all of the Oracle GoldenGate processes running.
2. Patching the Database
When patching the databases, you need to stop all of the Oracle GoldenGate processes before applying the patches. You can restart the Oracle GoldenGate processes after the patching is completed, and after any post patch scripts have been successfully run. The reason is that database patches and upgrades can modify the database internal tables and views needed by the Oracle GoldenGate replication. [1]
In addition, Oracle GoldenGate integrated capture and integrated delivery components may require Oracle database patches. Please refer to the MOS note Latest GoldenGate/Database (OGG/RDBMS) Patch recommendations (Doc ID 2193391.1) .
3. Patching Oracle GoldenGate
After Oracle GoldenGate 12c, Oracle GoldenGate has two types of patches[2][3]:
- Patching with the OPatch
- Patching with the unzip of the patch where the patch is a full product build
During the patching you would:
- Make sure Oracle GoldenGate replication catches up with the database transactions
- Stop all of the Oracle GoldenGate processes
- Backup the entire Oracle GoldenGate home directory, including sub directories. You might need to exclude the dirdat folder due to the size of the trail files.
- Apply the Oracle GoldenGate patches
- Start the Oracle GoldenGate processes.
It's important to test the patching process in the dev/test environment before updating the production system.
Resources
- Do I Need To Disable The GoldenGate DDL Trigger Before An Oracle DB Upgrade or PSU patching? (Doc ID 971222.1)
- How to Apply Patches for GoldenGate (Doc ID 2188592.1)
- How to Apply Oracle GoldenGate Patches (Doc ID 970860.1)
- Oracle GoldenGate -- Oracle RDBMS Server Recommended Patches (Doc ID 1557031.1)