1 Installing Oracle GoldenGate Microservices

The Oracle GoldenGate Microservices Architecture (MA) installation with an Oracle Database is a three-step process:

  1. Install the Oracle GoldenGate MA.

  2. Set the necessary environment variables.

  3. Deploy an Oracle GoldenGate instance using the configuration assistant.

MA is installed using OUI. You can also use a command line silent installation using OUI.

The installer registers the Oracle GoldenGate home directory with the central inventory that is associated with the selected database. The inventory stores information about all Oracle software products installed on a host if the product was installed using OUI.

Disk space is also required for the Oracle GoldenGate Bounded Recovery feature. Bounded Recovery is a component of the general Extract checkpointing facility. It caches long-running open transactions to disk at specific intervals to enable fast recovery upon a restart of Extract. At each bounded recovery interval (controlled by the BRINTERVAL option of the BR parameter) the disk required is as follows: for each transaction with cached data, the disk space required is usually 64k plus the size of the cached data rounded up to 64k. Not every long-running transaction is persisted to disk. For complete information about Bounded Recovery, see the BR parameter in Reference for Oracle GoldenGate.

Topics:

1.1 Prerequisites

Learn about what you need to do before installing.

Topics:

1.1.1 Setting ORACLE_HOME and ORACLE_SID

Make certain that the ORACLE_HOME and ORACLE_SID system environment variables are set to the correct Oracle instance. The Oracle GoldenGate processes refer to them when connecting to the database.

Specifying Oracle Variables on UNIX and Linux Systems

Specifying Oracle Variables on Windows Systems

1.1.1.1 Specifying Oracle Variables on UNIX and Linux Systems

If there is one instance of Oracle Database on the system, set the ORACLE_HOME and ORACLE_SID environment variables at the system level. If you cannot set them that way, use the following SETENV statements in the parameter file of every Extract and Replicat group that will be connecting to the instance. The SETENV parameters override the system settings and allow the Oracle GoldenGate process to set the variables at the session level when it connects to the database.

SETENV (ORACLE_HOME = path_to_Oracle_home_location)

SETENV (ORACLE_SID = SID)

If there are multiple Oracle instances on the system with Extract and Replicat processes connecting to them, you must use a SETENV statement in the parameter file of each process group. As input to the SETENV parameter, use the ORACLE_HOME and ORACLE_SID environment variables to point Oracle GoldenGate to the correct Oracle instance. For example, the following parameter file excerpts shows two Extract groups, each capturing from a different Oracle instance.

Group 1:

EXTRACT edbaa
SETENV (ORACLE_HOME = "/home/oracle/ora/product")
SETENV (ORACLE_SID = "oraa")
USERIDALIAS tiger1
RMTHOST sysb
RMTTRAIL /home/ggs/dirdat/rt
TABLE hr.emp;
TABLE hr.salary;

Group 2:

EXTRACT orab
SETENV (ORACLE_HOME = "/home/oracle/ora/product")
SETENV (ORACLE_SID = "orab")
USERIDALIAS tiger1
RMTHOST sysb
RMTTRAIL /home/ggs/dirdat/st
TABLE fin.sales;
TABLE fin.cust;
1.1.1.2 Specifying Oracle Variables on Windows Systems

If there is one instance of Oracle on the system, the Registry settings for ORACLE_HOME and ORACLE_SID should be sufficient for Oracle GoldenGate. If those settings are incorrect in the Registry and cannot be changed, you can set an override as follows.

  1. On the Desktop or Start menu, right-click My Computer, and then select Properties.

  2. In Properties, click the Advanced tab.

  3. Click Environment Variables.

  4. Under System Variables, click New.

  5. For the Variable Name, enter ORACLE_HOME.

  6. For the Variable Value, enter the path to the Oracle binaries.

  7. Click OK.

  8. Click New again.

  9. For the Variable Name, enter ORACLE_SID.

  10. For the Variable Value, enter the instance name.

  11. Click OK.

If there are multiple Oracle instances on the system with Extract and Replicat processes connecting to them, use these steps:

  1. Use the preceding procedure (single Oracle instance on system) to set the ORACLE_HOME and ORACLE_SID system variables to the first Oracle instance.
  2. Start all of the Oracle GoldenGate processes that will connect to that instance.
  3. Edit the existing ORACLE_HOME and ORACLE_SID variables to specify the new information., then repeat the procedure for the next Oracle instance.
  4. Start the Oracle GoldenGate processes that will connect to that instance.
  5. Repeat the edit and startup procedure for the rest of the Oracle instances.

1.1.2 What are the Key Microservices Architecture Directories and Variables?

The Microservices Architecture is designed with a simplified installation and deployment directory structure.

This directory structure is based on the Linux Foundation Filesystem Hierarchy Standard. Additional flexibility has been added to allow parts of the deployment subdirectories to be placed at other locations in the file system or on other devices, including shared network devices. The design is comprised of a read only home directory where you install Oracle GoldenGate and create a custom deployment specific directories as in the following:

The following table describes the key MA directories and the variables that are used when referring to those directories in an Oracle GoldenGate installation. When you see these variables in an example or procedure, replace the variable with the full path to the corresponding directory path in your enterprise topology.

Directory Name Variable Description Default Directory Path

Oracle Database home

ORACLE_HOME

The Oracle Database home that is created on a host computer is the directory that you choose to install the product. This read-only directory contains binary, executable, and library files for the product.

/database_install_location

Oracle GoldenGate home

OGG_HOME

The Oracle GoldenGate home that is created on a host computer is the directory that you choose to install the product. This read-only directory contains binary, executable, and library files for the product.

/ogg_install_location

Deployment configuration home

OGG_CONF_HOME

The location in which each deployment information and configuration artifacts are stored.

/ogg_deployment_location/etc/conf

Deployment security home

OGG_SSL_HOME

The location in which each deployment security artifacts (certificates, wallets) are stored.

/ogg_deployment_location/etc/ssl

Deployment data home

OGG_DATA_HOME

The location in which each deployment data artifacts (trail files) are stored.

/ogg_deployment_location/var/lib/data

Deployment variable home

OGG_VAR_HOME

The location in which each deployment logging and reporting processing artifacts are stored.

/ogg_deployment_location/var

Deployment etc home

OGG_ETC_HOME

The location in which your deployment configuration files are stored including parameter files.

/ogg_deployment_location/etc

You can change the default location of all of these to customize where you want to store these files.

In a configuration where the OGG_VAR_HOME is a local directory and the OGG_HOME is a shared read-only remote directory, many deployments with local OGG_VAR_HOME can share one read-only shared OGG_HOME.

This directory design facilitates a simple manual upgrade. To upgrade, you stop the services and then set the OGG_HOME in the web interface (or via a REST command) and then restart the processes. On the restart, Oracle GoldenGate picks up the updated environment variables. You simply switch a deployment to use a new Oracle GoldenGate release by changing the OGG_HOME directory path in your Service Manager to a new Oracle GoldenGate home directory, which completes the upgrade. You then must restart the MA servers, Extract processes, and Replicat processes.

In addition to many of the Oracle GoldenGate Classic Architecture Programs and Utilities, the following table describes the programs and utilities exclusive to the MA.

Name Description Default Directory

adminclient

The Admin Client is a standalone command line interface used to create processes, rather than using the MA UI.

$OGG_HOME/bin

adminsrvr

The Administration Server supervises, administers, manages, and monitors processes operating within an Oracle GoldenGate deployment for both active and inactive processes.

$OGG_HOME/bin

distsrvr

A Distribution Server is a service that functions as a networked data distribution agent in support of conveying and processing data and commands in a distributed deployment.

$OGG_HOME/bin

extract

Extract data process.

$OGG_HOME/bin

oggca.sh

The MA Configuration Assistant.

$OGG_HOME/bin

orapki

Utility to manage public key infrastructure elements, such as wallets and certificate revocation lists,

$OGG_HOME/bin

pmsrvr

The Performance Metrics Server uses the metrics service to collect and store instance deployment performance results.

$OGG_HOME/bin

recvsrvr

A Receiver Server is the central control service that handles all incoming trail files.

$OGG_HOME/bin

replicat

Replicat data process.

$OGG_HOME/bin

ServiceManager

A Service Manager acts as a watchdog for other services available with the MA.

$OGG_HOME/bin

crypto

$OGG_HOME/lib

htdocs

The MA HTML pages for all servers.

$OGG_HOME/lib

info

The various help files that support the MA HTML pages for all servers.

$OGG_HOME/lib

sql

An SQL directory that contains the healthcheck, legacy, and sharding utilities.

$OGG_HOME/lib

utl

A utility directory that contains the install, logging, reverseproxy, and sharding utilities.

$OGG_HOME/lib

1.2 Performing an Interactive Installation with OUI

Interactive installation provides a graphical user interface that prompts for the required installation information.

These instructions apply to new installations and upgrades.

  1. Create a temporary staging directory into which you will install Oracle GoldenGate. For example, mkdir /u01/stage/oggsc.
  2. Extract the installation ZIP file into the temporary staging directory. For example:

    unzip ./fbo_ggs_Linux_x64_services.zip -d ./temp directory

  3. From the expanded directory, run the fbo_ggs_Linux_x64_services_shophome/Disk1/runInstaller program on UNIX or Linux.
    The OUI Install Wizard is started.
  4. On the Select Installation Option page, select the Oracle Database version for your environment, then click Next.
  5. On the Specify Installation Details page, specify the following:
    • For Software Location, specify the location where Oracle GoldenGate software is to be installed. This will be your Oracle GoldenGate Home (OGG_HOME) after the installation is complete. If you have the $OGG_HOME environment variable set, this should be the path displayed. The specified directory cannot be a registered home in the Oracle Central Inventory.

    • Click Next.

  6. On the Summary page, confirm that there is enough space for the installation and that the installation selections are correct.
    • (Optional) Click Save Response File to save the installation information to a response file. You can run the installer from the command line with this file as input to duplicate the results of a successful installation on other systems. You can edit this file or create a new one from a template.

    • Click Install to begin the installation or Back to go back and change any input specifications. When upgrading an existing Oracle GoldenGate installation, OUI notifies you that the software location has files or directories. Click Yes to continue.

    • If you created a central inventory directory, you are prompted to run the INVENTORY_LOCATION/orainstRoot.sh script. This script must be executed as the root operating system user. This script establishes the inventory data and creates subdirectories for each installed Oracle product (in this case, Oracle GoldenGate).

    You are notified when the installation is finished.
  7. Click Close to complete the installation.

1.3 Performing a Silent Installation with OUI

Silent installation from the command line interface can be performed if your system does not have an X-Windows or graphical interface or you want to perform the installation in an automated way.

Silent installations ensure that multiple users in your organization use the same installation options when installing Oracle products.

Silent installations are driven by using a response file. Response files can be saved by selecting the Save Response File option during an interactive Oracle Universal Installer session or by editing the oggcore.rsp template located in the response directory after unzipping the binaries.

The Oracle GoldenGate response file contains a standard set of Oracle configuration parameters in addition to parameters that are specific to Oracle GoldenGate. These parameters correspond to the fields in the interactive session. The response file location is unzipped_directory/fbo_gg_Linux_x64_services_shiphome/Disk1/response.

To perform the installation using a response file, issue the following command:

unzipped_directory/fbo_gg_Linux_x64_services_shiphome/Disk1/runInstaller -silent -nowait -responseFile absolute_path_to_response_file