1. Oracle GoldenGate Classic Documentation
  2. Install and Patch
  3. Prerequisites for Installing Oracle GoldenGate for MySQL

Prerequisites for Installing Oracle GoldenGate for MySQL

Oracle GoldenGate 19c for MySQL and compatible databases, require the installation of OpenSSL 1.0 on the Oracle GoldenGate server prior to running GGSCI.

Installing OpenSSL on Linux

OpenSSL 1.0 is included with the core operating system packages of OEL 7 / RHEL7 / OEL6 / RHEL6 but is not included with OEL8 or RHEL 8, and therefore must be manually installed for these operating systems/versions.

To install the required OpenSSL 1.0 libraries (libssl.so.10 and libcrypto.so.10), download and install the MySQL Connector/ODBC, version 8.0.17, using the following instructions:

  1. Open this link in a web browser: https://downloads.mysql.com/archives/c-odbc/

  2. Select version 8.0.17 from the Product Version drop-down menu, then select Linux-Generic from the Operating System drop-down menu.

  3. Click the Download link for the x86, 64-bit version of the package: Linux - Generic (glibc 2.12) (x86, 64-bit), Compressed TAR Archive

  4. Save the file to a location of your choice, such as /opt/app/, and untar the file:
    tar -xvzf mysql-connector-odbc-8.0.17-linux-glibc2.12-x86-64bit
  5. Add the path of the OpenSSL 1.0 libraries that are needed for Oracle GoldenGate to the LD_LIBRARY_PATH system variable. The OpenSSL 1.0 libraries are located in the mysql-connector-odbc-8.0.17-linux-glibc2.12-x86-64bit/lib folder.
    export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/opt/app/mysql-connector-odbc-8.0.17-linux-glibc2.12-x86-64bit/lib/

Installing OpenSSL on Windows

OpenSSL 1.0 needs to be installed on the Windows server for Oracle GoldenGate for MySQL. To install the required OpenSSL 1.0 libraries (libcrypto-1_1-x64.dll and libssl-1_1-x64.dll), download and install the MySQL Connector/ODBC version 8.0.33, using the following instructions:

  1. Open this link in a web browser: https://downloads.mysql.com/archives/c-odbc/

  2. Select version 8.0.33 from the Product Version drop-down menu, then select Microsoft Windows from the Operating System drop-down menu.

  3. Click the Download link for the x86, 64-bit zip file version of the package Windows (x86, 64-bit), ZIP Archive.

  4. Save the file to a location of your choice, such as C:\mysql and extract the file:
    tar -xvf mysql-connector-odbc-noinstall-8.0.33-winx64.zip
  5. Add the path of the OpenSSL 1.0 libraries that are needed for Oracle GoldenGate to the PATH system variable. The OpenSSL 1.0 libraries are located in the mysql-connector-odbc-noinstall-8.0.33-winx64\lib folder.
    set PATH=%PATH%;C:\mysql\ mysql-connector-odbc-noinstall-8.0.33-winx64\lib