As this book is Oracle-centric, this section lists the certified platforms and Oracle databases that officially support GoldenGate 12c (12.1.2.1.0). The full comprehensive list of all the certified platforms and databases is available at the My Oracle Support website: https://support.oracle.com (formerly Metalink).
Follow the simple steps to obtain the official Oracle Certification Matrix:
Log on to your My Oracle Support account and from the dashboard, click on the Certifications tab.
In the Product search box, type Oracle GoldenGate, enter the Release and required Platform. Then click on the Search button.
The resulting screen displays the Certification Matrix, that can be collapsed or expanded based on the certification type, as shown in the following screenshot.
Although GoldenGate supports earlier versions of the Oracle database, the following table lists the platforms supported by GoldenGate for Oracle 11g and 12c:
|
DB |
Version |
Architecture |
OS |
Version |
|---|---|---|---|---|
|
Oracle |
11.2/12.1 |
64 |
Windows |
2008R2 |
|
Oracle |
11.2.0.4/12.1 |
64 |
Windows |
2012 |
|
Oracle |
11.2.0.4/12.1 |
64 |
Windows |
2012R2 |
|
Oracle |
11.2/12.1 |
64 |
Solaris x86 |
10 |
|
Oracle |
11.2/12.1 |
64 |
Solaris x86 |
11 |
|
Oracle |
11.2/12.1 |
64 |
Solaris SPARC |
10 |
|
Oracle |
11.2/12.1 |
64 |
Solaris SPARC |
11 |
|
Oracle |
11.2/12.1 |
64 |
RedHat Linux |
5 |
|
Oracle |
11.2/12.1 |
64 |
RedHat Linux |
6 |
|
Oracle |
11.2/12.1 |
64 |
Oracle Linux |
5 |
|
Oracle |
11.2/12.1 |
64 |
Oracle Linux |
6 |
Tip
While downloading the GoldenGate software from Oracle websites, ensure you choose the correct GoldenGate version, supported platform, architecture (32 or 64 bit), and database type and version.
The following table lists the certified non-Oracle databases that support Oracle GoldenGate 12.1:
|
Database |
DB Version |
|---|---|
|
IBM Infomix |
11.5 |
|
IBM Infomix |
11.7 |
|
IBM Infomix |
12.1 |
|
Microsoft SQL Server |
2008 |
|
Microsoft SQL Server |
2008R2 |
|
Microsoft SQL Server |
2012 |
|
Microsoft SQL Server |
2012R2 |
|
Microsoft SQL Server |
2014 |
|
MySQL |
5.5 |
|
MySQL |
5.6 |
Oracle GoldenGate is ideal for heterogeneous environments by replicating and integrating data across differing vendor systems. Log-based CDC is supported by nearly all major database vendors. GoldenGate can also integrate with JMS-based messaging systems to enable Event-Driven Architecture (EDA) and to support Service Oriented Architecture (SOA). In addition, GoldenGate provides further integration support with Oracle Data Integrator that leverages E-LT processes for OLAP and Data Warehouse implementations.