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 INSTALLATION FILES

STEP 4: PRE-INSTALLATION CHECKS

STEP 5: INSTALL ORACLE GOLDENGATE

STEP 6: POST-INSTALLATION STEPS

CONCLUSION:

Introduction:

The latest version of Oracle GoldenGate (12.3.0.1 and beyond) using the Microservices architecture is installed in two parts.  The first part is installing the binaries (covered in another document).  The second part is installing or building one or more deployments that will use the binaries that were previously installed.

Prerequisites:

1.     Oracle GoldenGate (Microservices) binaries are installed.

2.     Set appropriated environment variables.

3.     Ensure directory mount point is available and accessible.

Step 1: Create an Oracle GoldenGate Configuration Assistant (oggca) Response File

Oracle does not provide a response file for Oracle GoldenGate Configuration Assistant (oggca).  This means this file needs to be created from scratch or from a one-time walk through of the installer (oggca.sh).  The oggca.sh file can be found in $OGG_HOME/bin.

For this document, we will create the response file from scratch. 

1.     Create a new text file and save it as oggca.rsp.

2.     Edit oggca.rsp and add the required parameters.  Parameters that are prefixed/postfixed with pound signs are customizable. 

oracle.install.responseFileVersion=/oracle/install/rspfmt_oggca_response_schema_v21_1_0

CONFIGURATION_OPTION=ADD

DEPLOYMENT_NAME=###DEPLOYMENT_NAME###

ADMINISTRATOR_USER=oggadmin

ADMINISTRATOR_PASSWORD=###PWD###

SERVICEMANAGER_DEPLOYMENT_HOME=/gg_data/ServiceManager

HOST_SERVICEMANAGER=###HOST###

PORT_SERVICEMANAGER=###SMPORT###

SECURITY_ENABLED=false

STRONG_PWD_POLICY_ENABLED=true

CREATE_NEW_SERVICEMANAGER=###CREATESM###

REGISTER_SERVICEMANAGER_AS_A_SERVICE=false

INTEGRATE_SERVICEMANAGER_WITH_XAG=false

EXISTING_SERVICEMANAGER_IS_XAG_ENABLED=false

OGG_SOFTWARE_HOME=/app/oracle/21.10/oggcore_1

OGG_DEPLOYMENT_HOME=/gg_data/###DEPLOYMENT_NAME###

OGG_ETC_HOME=

OGG_CONF_HOME=

OGG_SSL_HOME=

OGG_VAR_HOME=

OGG_DATA_HOME=

ENV_ORACLE_HOME=/u01/app/oracle/product/19.3.0/db19c_client

ENV_LD_LIBRARY_PATH=${ORACLE_HOME}/lib

ENV_TNS_ADMIN=/u01/app/oracle/product/19.3.0/db19c_client/network/admin

ENV_ORACLE_SID=

ENV_STREAMS_POOL_SIZE=

ENV_USER_VARS=

CIPHER_SUITES=

SERVER_WALLET=

SERVER_CERTIFICATE=

SERVER_CERTIFICATE_KEY_FILE=

SERVER_CERTIFICATE_KEY_FILE_PWD=

CLIENT_WALLET=

CLIENT_CERTIFICATE=

CLIENT_CERTIFICATE_KEY_FILE=

CLIENT_CERTIFICATE_KEY_FILE_PWD=

SHARDING_ENABLED=false

SHARDING_USER=

ADMINISTRATION_SERVER_ENABLED=true

PORT_ADMINSRVR=###ASPORT###

DISTRIBUTION_SERVER_ENABLED=true

PORT_DISTSRVR=###DSPORT###

NON_SECURE_DISTSRVR_CONNECTS_TO_SECURE_RCVRSRVR=false

RECEIVER_SERVER_ENABLED=true

PORT_RCVRSRVR=###RSPORT###

METRICS_SERVER_ENABLED=true

METRICS_SERVER_IS_CRITICAL=false

PORT_PMSRVR=###PMPORT###

UDP_PORT_PMSRVR=###PMUDPPORT###

PMSRVR_DATASTORE_TYPE=LMDB

PMSRVR_DATASTORE_HOME=/u02/app/oracle/gg_deployment/###DEPLOYMENT_NAME###/lmdb

OGG_SCHEMA=ggate

REMOVE_DEPLOYMENT_FROM_DISK=

Step 2: Transfer OGGCA.rsp

1.     Transfer the oggca.rsp file to the target server where you want to build an Oracle GoldenGate deployment.  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 ./oggca.rsp <user>@<hostname>:/tmp

Step 3: Install Oracle GoldenGate Deployment

1.     Open a terminal or command prompt on the target server.

2.     Navigate to the directory where you transferred the oggca.rsp to and change ownership

$ cd /tmp

$chow oracle. ./oggca.rsp

3.     Set the environment variable for Oracle GoldenGate Home (OGG_HOME)

$ export OGG_HOME=/app/oracle/21.10/oggcore_1

4.     Start the installation of a deployment by running the oggca.sh script in $OGG_HOME/bin in silent mode.  Make sure to specify the absolute path to the oggca.rsp

$ $OGG_HOME/bin/oggca.sh -silent -responseFile /tmp/oggca.rsp

5.     Review on-screen output.  Upon successful installation, you will see:

$ $OGG_HOME/bin/oggca.sh -silent -responseFile /tmp/oggca.rsp

Successfully Setup Software.

Step 6: Post-installation Steps

1. Verify the installation by checking the installation by confirming that the ServiceManager and other sub-processes are running.

$ ps -ef | grep -i servicemanager

oracle     51188       1  0 13:57 ?        00:00:00 /app/oracle/21.10/oggcore_1/bin/ServiceManager --config /gg_data/ServiceManager/var/temp/ServiceManager-config.dat --force

oracle     51219   51188  0 13:57 ?        00:00:00 /app/oracle/21.10/oggcore_1/bin/adminsrvr --config /gg_data/ServiceManager/var/temp/Atlanta-adminsrvr-config.dat --force --quiet

oracle     51221   51188  0 13:57 ?        00:00:00 /app/oracle/21.10/oggcore_1/bin/distsrvr --config /gg_data/ServiceManager/var/temp/Atlanta-distsrvr-config.dat --force --quiet

oracle     51223   51188  0 13:57 ?        00:00:00 /app/oracle/21.10/oggcore_1/bin/recvsrvr --config /gg_data/ServiceManager/var/temp/Atlanta-recvsrvr-config.dat --force --quiet

oracle     51225   51188  0 13:57 ?        00:00:01 /app/oracle/21.10/oggcore_1/bin/pmsrvr --config /gg_data/ServiceManager/var/temp/Atlanta-pmsrvr-config.dat --force --quiet

oracle     51696   51054  0 13:59 pts/0    00:00:00 grep --color=auto -i servicemanager

At this point, you should be able to access the HTTP page for ServiceManager and any of the other services.

Conclusion:

Congratulations! You have successfully installed Oracle GoldenGate 21.10 Deployment on your target server.