Patching Oracle GoldenGate for SQL Server
Follow the existing patching procedures discussed in previous topics, Downloading Patches for Oracle GoldenGate and Patching Oracle GoldenGate Microservices Architecture Using OPatch. In addition, depending on your configuration of Oracle GoldenGate for SQL Server, you may be required to perform either of these steps.
Re-Run ADD TRANDATA
If patching a deployment where an Extract exists, it is recommended to re-run Add
TRANDATA
for each table that is already enabled for
TRANDATA
in order to update any Oracle GoldenGate dependent
procedures or objects that may have changed for a given patch release. If changes to
Oracle GoldenGate objects are part of a patch but have not been updated against the
GoldenGate objects in the database, the Extract will fail to start and return an error
about incorrect object versioning.
-
Stop Extract.
-
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.
-
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.
-
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 aEXCLUDEFILTERTABLE
object for active/active configurations.Caution:
Do not run the
DELETE TRANDATA
command as this will cause a data out of sync condition and requires re-initialization. -
Manually restart the SQL Server CDC Capture job.
-
Start the Extract.
Update odbcinst.ini and odbc.ini
If patching Oracle GoldenGate 23.4 or 23.5, to version 23.6 or later, a
one-time change to both the odbcinst.ini
and odbc.ini
is required to force connections to utilize the updated driver supplied with
GoldenGate.
You do not need to follow these steps if patching from Oracle GoldenGate 23.6 or after, to later GoldenGate 23ai patch versions.
-
The
odbcinst.ini
file is located in the$OGG_HOME/msodbc
directory. Modify this file to reflect the information provided below and ensure the ODBC Driver value includes the full path of the Oracle GoldenGate installation. For example:[Microsoft ODBC Driver for SQL Server] Description=Microsoft ODBC Driver for SQL Server Driver=/OGG23ai_Install_Path/msodbc/lib64/libmsodbcsql.so
-
If you have previously created an
odbcinst.ini
file with DSN entries, update the ODBC Driver value to match that of the Description field in theodbcinst.ini
file. It should be set to the following:Driver=Microsoft ODBC Driver for SQL Server