Supported platforms and databases
As this book is Oracle centric, below is a list of certified platforms and Oracle databases that officially support GoldenGate 10.4. The full comprehensive list for all certified platforms and databases is available at the My Oracle Support Website: https://support.oracle.com. (formerly, Metalink).
Follow the steps below to obtain the official Oracle Certification Matrix:
Log on to your My Oracle Support account and click on the Knowledge tab.
In the Search Product box near the top left of the page, type Oracle GoldenGate and click on the magnifying glass icon.
In the next search box type "Certification Matrix" and click on the magnifying glass icon to display the document ID 9762871.
Although GoldenGate supports earlier versions of Oracle, the following table lists the platforms supported by GoldenGate for Oracle 11g:
Supported platforms for Oracle Database 11g
|
DB |
Version |
Architecture |
OS |
Version |
Platform |
|---|---|---|---|---|---|
|
Oracle |
11.1 |
64 |
AIX |
5.3 |
IBM PowerPC |
|
Oracle |
11.1 |
32 |
AIX |
5.3 |
IBM PowerPC |
|
Oracle |
11.1 |
64 |
AIX |
6.1 |
IBM PowerPC |
|
Oracle |
11.1 / 11.2 |
64 |
HP-UX |
11.23 |
HP Intel IA64 |
|
Oracle |
11.1 / 11.2 |
64 |
HP-UX |
11.31 |
HP Intel IA64 |
|
Oracle |
11.1 / 11.2 |
64 |
RedHat AS |
4 |
AMD/Intel x64 |
|
Oracle |
11.1 / 11.2 |
32 |
RedHat AS |
4 |
Intel x86 |
|
Oracle |
11.1 / 11.2 |
64 |
RedHat AS |
5 |
AMD/Intel x64 |
|
Oracle |
11.1 / 11.2 |
64 |
Solaris |
10 |
Sun SPARC |
|
Oracle |
11.1 / 11.2 |
64 |
Windows |
2003 |
AMD/Intel x64 |
Tip
When 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.
For example, once unzipped and extracted, the following tar file installs GoldenGate 10.4.0.19 for Oracle 11g on Redhat or Oracle Enterprise Linux 32bit:
ggs_redhatAS50_x86_ora11g_32bit_v10.4.0.19_002.tar
The following is a list of certified non-Oracle databases that support Oracle GoldenGate 10.4:
|
Supported non-Oracle databases | |
|---|---|
|
Database |
DB Version |
|
IBM DB2 UDB |
8.1 |
|
IBM DB2 UDB |
8.2 |
|
IBM DB2 UDB |
9.1 / 9.5 |
|
Microsoft SQL Server |
2000 |
|
Microsoft SQL Server |
2005 |
|
Microsoft SQL Server |
2008 Delivery |
|
MySQL |
4.1 |
|
MySQL |
5 |
|
Sybase ASE |
12.5.4 |
|
Sybase ASE |
15 |
|
Teradata |
V2R5 |
|
Teradata |
V2R6 |
|
SQL/MX |
2.3 |
|
SQL/MP |
N/A |
|
TimesTen |
7.0.5 |
|
Enscribe |
N/A |
Oracle GoldenGate is ideal for heterogeneous environments by replicating and integrating data across differing vendor systems. Log-based Change Data Capture (CDC) is supported for 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). Further, integration support includes Extract Transformation and Load (ETL) products for OLAP and Data Warehouse implementations.
