Prerequisites to Configure Oracle GoldenGate Extract for PostgreSQL
To use Oracle GoldenGate
21.3 for PostgreSQL on OEL8, you must explicitly install OpenSSL 1.0 version on the OEL8
instance. This is necessary because the libpq
library (packaged with
Oracle GoldenGate 21c (21.3) for PostgreSQL), has a dependency on OpenSSL 1.0 version
libraries, and these libraries are not available on OEL8 by default.
To capture from a PostgreSQL database, Oracle GoldenGate requires the
test_decoding
database plug-in be installed for the database. This
plug-in might not have been installed by default when the database was installed.
Ensure that the postgresqlversion#-contrib
package is installed on the
database server, as shown in the example:
sudo yum install postgresql14-contrib