
Nowadays the DBA has Sys Admin skills and vice versa. For a successful GoldenGate installation, you will need both, but don't let this put you off! This chapter describes the process of downloading, installing, and configuring the GoldenGate software, plus the pre-installation steps from the Operating System and database preparation to confirming the software and hardware requirements. Consideration has been made to the GoldenGate environment and the Oracle database setup, including a configuration overview that allows you to swiftly get up and running. The final section guides you through the de-installation of the GoldenGate software.
This chapter will step you through the tasks needed to complete an end to end GoldenGate installation in the order specified as follows:
- Downloading the software from the Oracle Website.
- Unpacking the installation zip file.
- Preparing the source and target systems.
- Installing the software on source and target systems.
- Preparing the source database.
- Configuring the Manager process on the source and target systems.
- Configuring the Extract process on the source system.
- Configuring the Data Pump process on the source system.
- Configuring the Replicat process on the target system.
- Starting the Extract process.
- Starting the Data Pump process.
- Starting the Replicat process.
Although the installation process may vary between platforms, for the purpose of this book, the discussion topics and demonstrations will be based on Oracle GoldenGate V10.4.0.x for Oracle 11g on Oracle Enterprise Linux 5.0 32-bit.
There are a number of prerequisites we need to be aware of before installing Oracle GoldenGate 10.4. Let's take a look at these.
At the time of writing, to obtain an evaluation copy of GoldenGate 10.4, we need to log on to the Oracle eDelivery website:
Oracle has placed GoldenGate in the Oracle Fusion Middleware family section, under Business Intelligence. Here you will find Oracle GoldenGate for Oracle and non-Oracle environments on a number of supported platforms.
For example, choose Linux x86 from the drop-down and select Oracle Media Pack v2 for Linux x86. Then click the Continue button.

On the next screen download Oracle GoldenGate V10.4.0.x for Oracle 11g on RedHat 5.0 by clicking on the Download button.

A dialog box will appear allowing you to choose where to save the file on your local file-system. The download time is small as the zipped installation file is just a few megabytes.
It is also possible to download the Oracle GoldenGate documentation from the same screen. The part number is V20521-01.
Starting with the operating system, Oracle Enterprise Linux (OEL) is the same as Redhat Enterprise Linux (RHEL), essentially rebadged. OEL 5 and RHEL 5 both use kernel version 2.6.18. Oracle and Redhat Support and Development teams collaborate to produce bug fixes for future releases.
To view the version of Linux, execute the following command as the Oracle user:
$ cat /etc/redhat-release Enterprise Linux Enterprise Linux Server release 5.2 (Carthage)
The installation is a breeze. In fact it should only take a couple of minutes, by unpacking the UNIX tar file found in V18429-01.zip
that you downloaded earlier from the Oracle Website. Configuring GoldenGate will take a bit longer, but we will discuss that later in this chapter.
When installing GoldenGate on a clustered environment such as Oracle Real Application Clusters (RAC), ensure the GoldenGate home or at least its subdirectories are mounted on a shared filesystem. This allows the GoldenGate processes to be started from any of the nodes and processing checkpoints to be preserved across the cluster.
For Linux installations, there are no specific requirements for kernel parameter settings or RPMs. Typically, GoldenGate is installed on a database server which has the necessary kernel parameter settings and OS RPMs for Oracle. That said, you may wish to adjust the network related kernel parameters to enhance performance. This topic is discussed in detail in Chapter 9, Performance Tuning, section Tuning the Network.
The hardware requirements for GoldenGate include the size of the physical and virtual memory, the number of CPUs and the available disk space.
The GoldenGate binaries only consume around 50MB of disk space; however, each GoldenGate instance can support up to 300 concurrent Extract and Replicat processes (inclusive). Each process consumes around 50MB of memory. So, if you plan on using the maximum number of processes, you will need at least 16GB of physical memory to support not only GoldenGate, but have enough system resources available for the OS. If you have an Oracle Instance running on the same machine (which is highly likely), additional memory will be required. Most modern day enterprise specification database servers have at least 32GB of physical RAM.
Let's consider the CPU requirements. GoldenGate will use 1 CPU core per Extract or Replicat process. However, having a large number of CPUs available is both very expensive and not necessary, as GoldenGate will typically use only 5% of a systems CPU resource. Modern Operating Systems can share available resources very efficiently; the machine will not necessarily become CPU bound. It is important however to size your requirements effectively, obtaining a balance between the maximum possible number of concurrent processes and number of CPUs.
In your GoldenGate environment, you may find that CPU and memory are not the performance bottlenecks. After all, modern CPUs can process data very quickly and GoldenGate may actually be waiting to send data across the network. Therefore, ensure you have a fast network between your source and target systems. If the network between sites is a WAN, the bandwidth may not be available for high performance data transfer. In this case, you could reduce the CPU requirement to alleviate the network bottleneck.
GoldenGate requires a number of TCP/IP ports in which to operate. It is important that your network firewall is allowed to pass traffic on these ports. One port is used solely for communication between the Manager process and other GoldenGate processes. This is normally set to port 7809 but can be changed. A range of other ports are for local GoldenGate communications. These can be the default range starting at port 7840 or a predefined range of up to 256 other ports.
The final hardware requirement is disk space. Firstly, the GoldenGate cache manager uses the OS memory management functions, paging least-used information to disk and allocating virtual memory (VM) on demand. This operation uses disk space, swapping data out to temporary files in the dirtmp
subdirectory. To calculate the required swap space, obtain the value of PROCESS VM AVAIL FROM OS (min) from the Extract or Replicat report files and multiply by the number of concurrent processes.
Secondly, an additional 40 MB of disk space is required for the working directories of each GoldenGate instance, plus at least 1GB for the trail files.