Prerequisites for Installing Oracle GoldenGate for MySQL

Learn the prerequisites for installing Oracle GoldenGate for a MySQL database.

Note: The steps to install OpenSSL on Linux are not required with Oracle GoldenGate 23.26.2.0.4 and higher releases.

Install OpenSSL on Linux

Oracle GoldenGate 26ai for MySQL requires that OpenSSL 1.1 are present on the Oracle GoldenGate server prior to creating a deployment.

OpenSSL 1.1 is included with the core operating system packages of OEL 8 and RHEL8 but is not included with OEL 9 or RHEL 9. So, you need to manually install it for these operating systems/versions.

To install the required OpenSSL 1.1 libraries (libssl.so.1.1 and libcrypto.1.1), 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/.

Select Linux-Generic from the Operating System drop-down menu.
Click the Download link for the x86, 64-bit version of the package: Linux - Generic (glibc 2.28) (x86, 64-bit), Compressed TAR Archive.
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.33-linux-glibc2.28-x86-64bit
```
The OpenSSL 1.1 libraries needed for Oracle GoldenGate are located in the mysql-connector-odbc-8.0.33-linux-glibc2.28-x86-64bit/lib/private folder. Add this path 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.33-linux-glibc2.28-x86-64bit/lib/private/
```