Post-Patch Installation Tasks for Non-Oracle Databases

This topic lists any post-patch installation tasks that may be required, depending on the database platform.

Post-Patching Tasks for Oracle GoldenGate for SQL Server

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 Oracle GoldenGate.

You do not need to follow these steps if patching from Oracle GoldenGate 23.6 or after, to later Oracle GoldenGate 23ai patch versions.

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

2. 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 the odbcinst.ini file. It should be set to the following:

   
   Driver=Microsoft ODBC Driver for SQL Server