What you need for this book
At the 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 that acts as a database server, running Oracle or Red Hat Enterprise Linux x86 Version 5.2. These can be native Linux or Linux virtual machines hosted on Microsoft Windows 7 or 8.
The same PC may be used as a client that supports terminal emulation software for logging in to the database server.
The following list provides the minimum hardware specification for the PC that will host the virtual machines:
- 1 x 2.3 GHz Core i7 Intel-based 64-bit architecture CPU
- 8 GB of physical memory
- 500 GB hard disk drive
- 1 x 1Gb/s Ethernet adapter
- Oracle VM VirtualBox 64-bit for Windows (version 4.3.26)
The virtual machine specification is as follows; for 2VMs, each has:
- 4 CPU cores
- 4 GB RAM
- 30 GB filesystem storage
To implement a simple point-to-point data replication solution, you will need two Oracle 12c Release 1 databases. Both source and target databases can reside on the same machine.
Refer to the preinstallation requirements found on the Oracle website at https://docs.oracle.com/database/121/LADBI/pre_install.htm#LADBI7487.
The following list provides the software requirements:
- Oracle or Red Hat Enterprise Linux Server Release 6.4 64 bit
- Oracle Server 12.1.0 on Oracle Enterprise Linux 6.4 64 bit (This is required for the 2 Oracle databases: source and target)
- Oracle GoldenGate Version 12.1.2.x for Oracle 12c on Oracle Enterprise Linux 6 64 bit
- Microsoft Windows 7 or 8
- Perl v5.10.1 (included with OEL/RHEL 6.4)
- PuTTY 0.64 for MS Windows (the terminal emulation software that supports the SSH protocol)
- WinSCP Version 5.7.2 for MS Windows (the file transfer software that supports the SFTP protocol)
