- Oracle GoldenGate 11g Implementer's guide
- John P Jeffries
- 291字
- 2025-02-15 21:16:51
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)