Prerequisites for Installing Oracle GoldenGate for MySQL

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

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

Installing OpenSSL on Linux

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:

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. 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.33-linux-glibc2.28-x86-64bit/lib/private/
```