Book Image

Oracle GoldenGate 11g Implementer's guide

By : John P Jeffries, John P Jeffries
Book Image

Oracle GoldenGate 11g Implementer's guide

By: John P Jeffries, John P Jeffries

Overview of this book

Data replication is an important part of any database system that is growing due to today's demand for real-time reporting and regulatory requirements. GoldenGate has recently become Oracle's strategic real-time data replication solution. Until now, very little has been written about how to implement GoldenGate in a production enterprise environment where performance, scalability, and data integrity are paramount. Your days of dismay over the lack of documentation over Oracle GoldenGate are over. Welcome to Oracle GoldenGate 11g Implementer's guide – a comprehensive practical book, which will deliver answers to your questions in a clear, concise style, allowing you to progress effectively in a timeline-driven environment. Based on the author's own experience, this long awaited GoldenGate administration book has all that is required to install, design, configure, and tune data replication solutions suited to every environment. Be the first to master GoldenGate's power and flexibility by reading this unique hands-on implementation companion. Systems need to send data from one system to another in a timely manner to satisfy the ever-increasing need for speed. Regardless of whether you are a novice or an expert – or someone in between – this book will guide you through all the steps necessary to build a high-performance GoldenGate solution on Oracle11gR1. Expert users can dive into key topic areas such as performance tuning or troubleshooting, while novice users can step through the early installation and configuration chapters, later progressing to the advanced chapters. This book is more than an implementation guide. It offers detailed real-life examples, encouraging additional thought and discussion by going beyond the manual. With Oracle GoldenGate 11g Implementer's guide in hand, you'll be designing, installing, and configuring high-performance solutions using GoldenGate in less time than you can say "replicate"
Table of Contents (21 chapters)
Oracle GoldenGate 11 Implementer's guide
Credits
Foreword
About the Author
About the Reviewers
www.PacktPub.com
Preface
GGSCI Commands
GoldenGate Installed Components
The Future of Oracle GoldenGate
Index

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:

  1. Log on to your My Oracle Support account and click on the Knowledge tab.

  2. In the Search Product box near the top left of the page, type Oracle GoldenGate and click on the magnifying glass icon.

  3. 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.