1. Microservices Architecture Documentation
  2. Install and Patch
  3. Installing Patches for Oracle GoldenGate Microservices Architecture
  4. Post-Patch Installation Tasks for Non-Oracle Databases for Microservices Architecture
  5. Patching Oracle GoldenGate for SQL Server - Extract Requirements

Patching Oracle GoldenGate for SQL Server - Extract Requirements

You must follow the existing patching procedures discussed in previous topics, Downloading Patches for Oracle GoldenGate and Patching Oracle GoldenGate Microservices Architecture Using OPatch. In addition, you must re-run ADD TRANDATA for each table that is already enabled for TRANDATA using these steps:

  1. Stop Extract.

  2. Follow normal patch procedures for binary replacement but do not start any Oracle GoldenGate processes. See Installing Patches for Oracle GoldenGate Microservices Architecture for details.

  3. Manually stop the SQL Server CDC Capture job for the database. If the job is processing a large transaction, it may take some time before it actually stops.

  4. Using Admin client, run ADD TRANDATA again for every table that you previously enabled it for, including the heartbeat tables and any Replicat checkpoint table used as a EXCLUDEFILTERTABLE object for active/active configurations.

    Note:

    Do not run the DELETE TRANDATA command.

  5. Manually restart the SQL Server CDC Capture job.

  6. Restart the Extract.