1. Oracle GoldenGate Classic Documentation
  2. Install and Patch
  3. Patching for Classic Architecture
  4. Patching Oracle GoldenGate Classic Architecture for Non-Oracle Databases
  5. Patching Oracle GoldenGate for SQL Server - Extract Requirements

Patching Oracle GoldenGate for SQL Server - Extract Requirements

You must follow the existing patching procedures in Patching Oracle GoldenGate for Non-Oracle Databases. In addition, you must re-run ADD TRANDATA for each table that is already enabled for TRANDATA using these steps:

  1. Stop all Oracle GoldenGate processes.

  2. Follow normal patch procedures for binary replacement but do not start any Oracle GoldenGate processes.

  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. Ensure that the Extract is stopped.

  5. Using GGSCI, 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 FILTERTABLE object for active/active configurations.

    Note:

    Do not run the DELETE TRANDATA command.

  6. Manually restart the SQL Server CDC Capture job.

  7. Manually restart the Oracle GoldenGate processes such as Extract, Replicat, and Manager.