Installing Oracle GoldenGate binaries
Author: Bobby Curtis, MBA
Date: August 4, 2023
Organization: RheoData
Table of Contents
STEP 1: DOWNLOAD ORACLE GOLDENGATE 21.10
STEP 2: TRANSFER INSTALLATION FILES
STEP 3: EXTRACT INSTALLATION FILES
STEP 4: PRE-INSTALLATION CHECKS
STEP 5: INSTALL ORACLE GOLDENGATE
STEP 6: POST-INSTALLATION STEPS
Oracle GoldenGate is a real-time data integration and replication software that enables data movement and synchronization across heterogeneous databases and platforms. This installation documentation provides step-by-step instructions for installing Oracle GoldenGate 21.10 on a target server.
1. Ensure that you have the required hardware and software configurations as specified in the Oracle GoldenGate 21.10 documentation.
a. Memory
i. Modern servers have sufficient RAM combined with sufficient swap space and memory management systems to run Oracle GoldenGate. However, increasing the amount of RAM available to Oracle GoldenGate may significantly improve its performance, as well as that of the system in general.
b. Disk
i. The disk space requirements for a Oracle GoldenGate installation vary based on your operating system and database. Ensure that you have adequate disk space for the downloaded file, expanded files, and installed files, which can be up to 2GB.
c. Network
i. Use the fastest network possible and install redundancies at all points of failure for optimal performance and reliability, especially in maintaining low latency on the target.
ii. Configure the system to use both TCP and UDP services, including DNS. Oracle GoldenGate supports IPv4 and IPv6 and can operate in a system that supports one or both of these protocols.
iii. Configure the network with the host names or IP addresses of all systems that will be hosting Oracle GoldenGate processes and to which Oracle GoldenGate will be connecting.
iv. Oracle GoldenGate requires some unreserved and unrestricted TCP/IP network ports, the number of which depends on the number and types of processes in your configuration.
1. Keep a record of the ports that you assigned to Oracle GoldenGate processes. You specify them with parameters when configuring deployments for the Microservices Architecture.
2. Configure your firewalls to accept connections through the Oracle GoldenGate ports.
d. OS
i. The user who installs Oracle GoldenGate must be granted read and write privileges on the Oracle GoldenGate software home directory.
ii. The user who configures deployments using the oggca.sh script and creates Oracle GoldenGate Extract, Replicat processes must have read, write, and delete privileges on files and subdirectories in the Oracle GoldenGate directory.
iii. For Extract processes that read from transaction logs and backups, the user must have read access to the logs and backup files.
iv. Oracle recommends that you dedicate the Extract and Replicat operating system users to Oracle GoldenGate. Sensitive information might be available to anyone who runs an Oracle GoldenGate process, depending on how database authentication is configured.
2. Obtain the Oracle GoldenGate 21.10 installation files from the Oracle website or your licensed source.
3. Verify that you have the necessary permissions and credentials to perform the installation.
1. Go to the Oracle website or your licensed source to download Oracle GoldenGate 21.10 installation files.
2. Select the appropriate installation package for your operating system and database platform.
1. Transfer the downloaded installation files to the target server where you want to install Oracle GoldenGate. You can use SCP (Secure Copy Protocol) or any other file transfer method based on your server's configuration.
$ scp -i /Users/bcurtis/.ssh/id_rsa1 ./p35271084_2110000OGGRU_Linux-x86-64.zip <user>@<hostname>:/tmp
1. Log in to the target server using your credentials (SSH or local access).
$ ssh -i <path>/<private key> <user>@<hostname>
2. Navigate to the directory where you transferred the Oracle GoldenGate installation files.
$ cd /tmp
3. Extract the downloaded files using the appropriate command for your file format (e.g., tar, unzip).
unzip -q ./p35271084_2110000OGGRU_Linux-x86-64.zip -d ./ogg21
1. Before proceeding with the installation, ensure that your server meets the system requirements specified in the Oracle GoldenGate documentation.
2. Check for any conflicting software or applications that might interfere with the installation or functioning of Oracle GoldenGate.
3. Ensure that the Oracle prerequisites are installed.
$ sudo yum -y install oracle-database-preinstall-19c
4. Create directory structure for Oracle GoldenGate home.
$ sudo su – root
$ mkdir -p /app/oracle/21.10/oggcore_1
$ chown -R oracle. /app/oracle
5. Create directory structure for Oracle Inventory.
$ sudo su – root
$ mkdir -p /app/oraInventory
$ chown -R oracle. /app/oracle
6. Create and edit a response file.
$ cd /tmp/ogg21/fbo_ggs_Linux_x64_Oracle_services_shiphome/Disk1/response
$ sudo su - root
$ cp ./oggcore.rsp /tmp/oggcore.rsp
$ vi /tmp/oggcore.rsp
$ chown oracle. /tmp/oggcore.rsp
Contents of response file:
oracle.install.responseFileVersion=/oracle/install/rspfmt_ogginstall_response_schema_v21_1_0
INSTALL_OPTION=ora21c
SOFTWARE_LOCATION=/app/oracle/21.10/oggcore_1
INVENTORY_LOCATION=/app/oraInventory
UNIX_GROUP_NAME=oinstall
1. Open a terminal or command prompt on the target server.
2. Navigate to the directory where you extracted the Oracle GoldenGate installation files.
$ cd /tmp/ogg21/fbo_ggs_Linux_x64_Oracle_services_shiphome/Disk1
3. Start the installation by running the appropriate installer for your operating system and database platform.
Note: Exporting the Oracle Base before using the Oracle Universal Installer (OUI) will set place the oraInventory in /app. If this is not set, it will use the Oracle Home of the Oracle user as the location for the oraInventory.
$ cd /
$ chown -R oracle:oinstall /app
$ sudo su - oracle
$ export ORACLE_BASE=/app/oracle
$ cd /tmp/ogg21/fbo_ggs_Linux_x64_Oracle_services_shiphome/Disk1
$ ./runInstaller -silent -responseFile /tmp/oggcore.rsp
4. Review on-screen output. Upon successful installation, you will see:
./runInstaller -silent -responseFile /tmp/oggcore.rsp
Starting Oracle Universal Installer...
Checking Temp space: must be greater than 120 MB. Actual 25447 MB Passed
Checking swap space: must be greater than 150 MB. Actual 4095 MB Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2023-08-05_01-38-48PM. Please wait ...[oracle@ogg21-10-icon1 response]$ You can find the log of this install session at:
/tmp/OraInstall2023-08-05_01-38-48PM/installActions2023-08-05_01-38-48PM.log
The installation of Oracle GoldenGate Services was successful.
Please check '/home/oracle/oraInventory/logs/silentInstall2023-08-05_01-38-48PM.log' for more details.
As a root user, execute the following script(s):
1. /app/oraInventory/orainstRoot.sh
Successfully Setup Software.
The log of this install session can be found at:
/home/oracle/oraInventory/logs/installActions2023-08-05_01-38-48PM.log
1. Verify the installation by checking the installation logs and verifying the Oracle GoldenGate binaries and directories.
$ vi /home/oracle/oraInventory/logs/silentInstall2023-08-05_01-38-48PM.log
Congratulations! You have successfully installed Oracle GoldenGate 21.10 binaries on your target server. Nex you will need to define and install a deployment before replication can be established.