Oracle GoldenGate - Installing Oracle GoldenGate binaries

Oracle GoldenGate - Installing Oracle GoldenGate binaries

Installing Oracle GoldenGate binaries

 

Author: Bobby Curtis, MBA

 

Date: August 4, 2023

 

Organization: RheoData

Table of Contents

INTRODUCTION:

Prerequisites:

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

CONCLUSION:

 


 

Introduction:

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.

 

Prerequisites:

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.

Step 1: Download Oracle GoldenGate 21.10

 

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.

Step 2: Transfer Installation Files

 

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

Step 3: Extract Installation Files

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

Step 4: Pre-installation Checks

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

Step 5: Install Oracle GoldenGate

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

Step 6: Post-installation Steps

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

 

Conclusion:

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.

    • Related Articles

    • Installing Oracle GoldenGate deployments

      Installing Oracle GoldenGate deployments Author: Bobby Curtis, MBA Date: August 8, 2023 Organization: RheoData Table of Contents INTRODUCTION: Prerequisites: STEP 1: DOWNLOAD ORACLE GOLDENGATE 21.10 STEP 2: TRANSFER INSTALLATION FILES STEP 3: EXTRACT ...
    • Oracle GoldenGate - Out-of-Place Patching

      Oracle GoldenGate Out-of-Place Patching Author: Bobby Curtis, MBA Date: October 17, 2023 Updated: January 23, 2025 Organization: RheoData Table of Contents INTRODUCTION: PLATFORM PATCHING SECOND HOME PATCHSET LIST DEPLOYMENTS PATCH SERVICEMANAGER VIA ...
    • Oracle GoldenGate - Backup Oracle GoldenGate Deployments

      Backup Oracle GoldenGate Deployments Author: Bobby Curtis, MBA Date: January 23, 2025 Updated: October 13, 2023 Organization: RheoData Table of Contents INTRODUCTION: Assumption: STEP 1: ACCESS THE ORACLE GOLDENGATE SERVER STEP 2: IDENTIFY THE ...
    • Oracle GoldenGate - Deployments: Switchover

      Oracle GoldenGate Deployments: Switchover Author: Bobby Curtis, MBA Date: August 17, 2023 Organization: RheoData Table of Contents INTRODUCTION: PREREQUISITES STEP 1: EXPORT DEPLOYMENT VAR AND ETC HOMES STEP 2: STOP SERVICEMANAGER STEP 3: VERIFY ...
    • Oracle GoldenGate - Exception Handling

      Oracle GoldenGate Exception Handling Author: Bobby Curtis, MBA Date: October 3, 2023 Updated: January 23, 2025 Organization: RheoData Table of Contents INTRODUCTION: EXCEPTION TABLE(S) INFO Exception Table Exception Macro Update Replicat CONCLUSION: ...