Prerequisites for Installing Oracle GoldenGate Microservices Architecture for SQL Server
Oracle GoldenGate for SQL Server must be installed on a supported operating system as per the Certification Matrix, and can be installed on the database server itself or on an application hub server, based on your preference.
Open a terminal session and using Microsoft’s RedHat Enterprise Server installation instructions for adding the ODBC Drivers for Linux, perform the following steps with default values. Respond with 'y' when prompted.
sudo su #RedHat Enterprise Server 8
curl https://packages.microsoft.com/config/rhel/8/prod.repo >
/etc/yum.repos.d/mssql-release.repo
exit
sudo yum remove unixODBC-utf16 unixODBC-utf16-devel #to avoid conflicts
sudo ACCEPT_EULA=Y yum install msodbcsql17
sudo ACCEPT_EULA=Y yum install mssql-tools
echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bash_profile
echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrc
source ~/.bashrc
Additionally, observe the following program and settings for Oracle GoldenGate for SQL Server:
-
Install either the Microsoft ODBC Driver 17 or Microsoft ODBC Driver 18 for the operating system where Oracle GoldenGate is to be installed:
For Oracle GoldenGate on Windows, install the driver available at the following link:
For Oracle GoldenGate on Linux, install the driver available at this link, and follow the instructions for RHEL and Oracle Linux packages:
Note:
Support for Microsoft ODBC Driver 18 was added with Oracle GoldenGate release version 21.8.0.0.3. Versions prior to release 21.8.0.0.3 do not support the Microsoft ODBC Driver 18 for SQL Server. -
To install capture on a remote Linux or Windows server, set the remote server's time and time zone to that of the database server, or use LSN based positioning for the Extract.