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

Prerequisites for Installing Oracle GoldenGate for MySQL

Installing OpenSSL on Linux

OpenSSL 1.0 is included with the core operating system packages of OEL 7 and RHEL7 but is not included with OEL8/9 or RHEL 8/9, 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. Select version 8.0.17 from the Product Version drop-down menu, using the link, https://downloads.mysql.com/archives/c-odbc/.

  2. 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, as shown in the following example: 

    tar -xvzf mysql-connector-odbc-8.0.17-linux-glibc2.12-x86-64bit

  5. The OpenSSL 1.0 libraries needed for Oracle GoldenGate are located in the mysql-connector-odbc-8.0.17-linux-glibc2.12-x86-64bit/lib folder. This path needs to be added to the LD_LIBRARY_PATH system variable, prior to creating a MySQL deployment, as shown in the following example. 

    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. Select version 8.0.33 from the Product Version drop-down menu, using the link, https://downloads.mysql.com/archives/c-odbc/.

  2. Select Microsoft Windows from the Operating System drop-down menu.

  3. Click the Download link for the x86, 64-bit 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, as shown in the following example: 

    tar -xvf mysql-connector-odbc-noinstall-8.0.33-winx64.zip

  5. The OpenSSL 1.0 libraries needed for Oracle GoldenGate are located in the mysql-connector-odbc-noinstall-8.0.33-winx64\lib folder. This path needs to be added to the PATH system variable, prior to creating a MySQL deployment, as shown in the following example. 

    set PATH=%PATH%;C:\mysql\ mysql-connector-odbc-noinstall-8.0.33-winx64\lib