Preface

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

Computers 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 within minutes.

What this book covers

Chapter 1, Getting Started, provides an introduction to Oracle GoldenGate, inspiring thought by describing the key components, processes, and considerations required to build and implement a GoldenGate solution.

The topics covered the evolution of GoldenGate Software, including the architecture behind the technology followed by the solutions GoldenGate can provide, coupled with effective design.

Chapter 2, Installing and Preparing GoldenGate, walks you through the individual tasks needed to complete an end-to-end GoldenGate installation, including the download of the software through to creating a simple data replication environment.

Chapter 3, Design Considerations, addresses some of the issues that influence the decision making process when designing a GoldenGate solution. These include design considerations for both performance and high availability. Here you can choose the appropriate hardware and topology to deliver a fast, robust and scalable solution.

Chapter 4, Configuring Oracle GoldenGate, initially discusses the main GoldenGate parameters, and provides a methodical approach to the configuration process, stepping through each task to give the depth of information necessary to successfully implement GoldenGate on Oracle 11g. By providing the building blocks, this chapter forms the basis for more complex configurations.

Chapter 5, Configuration Options, looks at the available options that allow your configuration to extend in functionality and performance. We start with performance enhancements, later exploring the security features, including data compression and encryption, and finally discussing the options available to implement DDL replication.

Chapter 6, Configuring GoldenGate for HA teaches you how to configure Oracle GoldenGate in a RAC environment and explores the various components that effectively enable HA for data replication and integration.

Chapter 7, Advanced Configuration, gives you a deeper understanding of GoldenGate configuration. By the time you are done with this chapter, you will be able to explore and realize each parameter specification and further develop your GoldenGate configuration.

Chapter 8, Managing Oracle GoldenGate, focuses on the management features already built in to the GoldenGate Command Interpreter (GGSCI). We discuss and implement a number of utilities, including tips and tricks that allow you to manage your GoldenGate environment effectively at no extra cost. This includes a Perl script that will format the text output from the GGSCI "INFO ALL" command so that the data can be loaded into MS Excel for graphing and trend analysis.

Chapter 9, Performance Tuning, focuses on the main areas that lend themselves to tuning, especially parallel processing and load balancing, enabling high data throughput and very low latency. Performance enhancing new features that are available in the next version of GoldenGate are also discussed and evaluated.

Chapter 10, Troubleshooting GoldenGate, provides a troubleshooting guide for Oracle GoldenGate. We address some of the common issues faced by the implementer, followed by a discussion of the tools and utilities available to help resolve them. This includes the creation of an Exception Handler that automatically logs the details of a failed transaction for further analysis and resolution.

This book has three appendices; their purpose is to provide a "quick reference" as well as address any subjects and terminology not addressed in the previous chapters.

Appendix A, GGSCI Commands, provides a quick reference guide to all the available GoldenGate Software Command Interface (GGSCI) commands.

Appendix B, GoldenGate Installed Components, lists the GoldenGate installed components and their description.

Appendix C, The Future of Oracle GoldenGate, discusses Oracle's strategic approach to data replication and integration. The latest release of GoldenGate including its sister products are described along with links to official documentation and forums on the Oracle website.

What you need for this book

As a minimum you will require the following elements to run the code featured in this book. Starting with the hardware, you can configure a simple GoldenGate solution on just one personal computer acting as a database server, running Oracle or Redhat Enterprise Linux x86 version 5.2. This can be native Linux or Linux virtual machine hosted on MS Windows XP.

Ideally, another PC is required as a client that supports terminal emulation software for logging onto the database server, plus MS Excel for graphing and analysis of statistics.

The following list provides the minimum hardware specification for each PC:

• 1 x 2.5 GHz Dual Core Intel based 32 bit architecture CPU

• 2 GB of physical memory

• 250 GB hard disk drive for the database server

• 150 GB hard disk drive for the MS Windows client

• 1 x 100Mb/s Ethernet adapter

To implement a simple point to point data replication solution, you will need two Oracle 11g Release 1 databases. Both source and target databases can reside on the same machine. Please refer to the pre-installation requirements found on the Oracle Website at the following link: http://download.oracle.com/docs/cd/B28359_01/install.111/b32002/pre_install.htm

The following list provides the software requirements:

• Oracle or Redhat Enterprise Linux Server release 5.2 - 32-bit

• Oracle Server 11.1.0.6 on Oracle Enterprise Linux 5.0 32-bit, patched to 11.1.0.7 (this is required for the two Oracle databases, source & target)

• Oracle GoldenGate V10.4.0.x for Oracle 11g on Oracle Enterprise Linux 5.0 32-bit

• MS Windows XP 32-bit Professional Edition, Service Pack 3 with MS Excel 2007 installed

• Perl v5.8.8 (included with OEL/RHEL 5.2)

• PuTTY 0.56 for MS Windows XP (terminal emulation software that supports SSH protocol)

• WinSCP Version 3.8.2 for MS Windows XP (file transfer software that supports SFTP protocol)

Who this book is for

This book is for Solution Architects and Database Architects who wish to learn about the functionality and efforts required in implementing a data replication, migration or integration solution using GoldenGate. It is also designed for System Administrators and Database Administrators who want to implement, or those who have already implemented, GoldenGate and who want to explore its advanced features. An intermediate understanding of Oracle database technology is assumed.

Conventions

In this book, you will find a number of styles of text that distinguish between different kinds of information. Here are some examples of these styles, and an explanation of their meaning.

Code words in text are shown as follows: "We can include other contexts through the use of the include directive."

A block of code is set as follows:

EXTRACT EPMP01
PASSTHRU
RMTHOST dbserver2, MGRPORT 7809
RMTTRAIL ./dirdat/ta
TABLE SRC.DEPT;
TABLE SRC.EMP;

When we wish to draw your attention to a particular part of a code block, the relevant lines or items are set in bold:

EXTRACT EPMP01
PASSTHRU
RMTHOST dbserver2, MGRPORT 7809
RMTTRAIL ./dirdat/ta
TABLE SRC.DEPT;
TABLE SRC.EMP;

Any command-line input or output is written as follows:

cd /home/oracle/ggs

New terms and important words are shown in bold. Words that you see on the screen, in menus or dialog boxes for example, appear in the text like this: "clicking the Next button moves you to the next screen".

Note

Warnings or important notes appear in a box like this.

Tip

Tips and tricks appear like this.

Reader feedback

Feedback from our readers is always welcome. Let us know what you think about this book—what you liked or may have disliked. Reader feedback is important for us to develop titles that you really get the most out of.

To send us general feedback, simply send an e-mail to <[e-mail]>, and mention the book title via the subject of your message.

If there is a book that you need and would like to see us publish, please send us a note in the SUGGEST A TITLE form on www.packtpub.com or e-mail <[e-mail]>.

If there is a topic that you have expertise in and you are interested in either writing or contributing to a book, see our author guide on www.packtpub.com/authors.

Customer support

Now that you are the proud owner of a Packt book, we have a number of things to help you to get the most from your purchase.

Tip

Downloading the example code for this book

You can download the example code files for all Packt books you have purchased from your account at http://www.PacktPub.com. If you purchased this book elsewhere, you can visit http://www.PacktPub.com/support and register to have the files e-mailed directly to you.

Errata

Although we have taken every care to ensure the accuracy of our content, mistakes do happen. If you find a mistake in one of our books—maybe a mistake in the text or the code—we would be grateful if you would report this to us. By doing so, you can save other readers from frustration and help us improve subsequent versions of this book. If you find any errata, please report them by visiting http://www.packtpub.com/support, selecting your book, clicking on the errata submission form link, and entering the details of your errata. Once your errata are verified, your submission will be accepted and the errata will be uploaded on our website, or added to any list of existing errata, under the Errata section of that title. Any existing errata can be viewed by selecting your title from http://www.packtpub.com/support.

Piracy

Piracy of copyright material on the Internet is an ongoing problem across all media. At Packt, we take the protection of our copyright and licenses very seriously. If you come across any illegal copies of our works, in any form, on the Internet, please provide us with the location address or website name immediately so that we can pursue a remedy.

Please contact us at <[e-mail]> with a link to the suspected pirated material.

We appreciate your help in protecting our authors, and our ability to bring you valuable content.

Questions

You can contact us at <[e-mail]> if you are having a problem with any aspect of the book, and we will do our best to address it.