Prerequisites for Installing Oracle GoldenGate for MySQL

The following additional programs and settings for different databases must be available to support Oracle GoldenGate.

Oracle GoldenGate 21c for MySQL is packaged with MySQL client libraries 8.0.26 and requires OpenSSL 1.0 be (libssl.so.10 and libcrypto.so.10) installed on the Oracle GoldenGate server.

• If Oracle GoldenGate is installed on a MySQL 8.0 (versions less than or equal to 8.0.26) database server, then add the MySQL installation’s home\bin directory to the PATH or LD_LIBRARY_PATH environment variable as shown:

  For Linux:

  export LD_LIBRARY_PATH=mysql_home/bin:$PATH

  For Windows:

  set PATH=mysql_home\bin;%PATH%

• If Oracle GoldenGate is installed on a MySQL (versions 5.6, 5.7, 8.0.26+) or MariaDB database server, or installed on a hub server, then install OpenSSL 1.0 (libssl.so.10 and libcrypto.so.10) and add its installation location to the PATH or LD_LIBRARY_PATH environment variable.

This is required for both Linux and Windows systems and the environment variable must include the directory containing the following files:

Note:

The OpenSSL library (libssl.so.10) is part of the core OS package on RHEL7 but its not part of the OS package on RHEL8. On RHEL8, you need to manually install OpenSSL libraries (libssl.so.10 and libcrypto.so.10).

• libssl.so.10 and libcrypto.so.10 files for Linux systems.

• libcrypto-1_1-x64.dll and libssl-1_1-x64.dll files for Windows systems".

On Linux , OpenSSL 1.0 (libssl.so.10 and libcrypto.so.10) is installed using the OpenSSL development package or by installing a MySQL version lower than or equal to 8.0.26, which includes the OpenSSL 1.0 libraries (libssl.so.10 and libcrypto.so.10), such as Connector/ODBC 8.0 version 8.0.26.

On Windows OpenSSL 1.0 libraries can be directly download from https://slproweb.com/products/Win32OpenSSL.html.