Installing Oracle GoldenGate

Learn about the steps for installing Oracle GoldenGate Microservices Architecture for the first time and includes instructions to download the base release of a new version of Oracle GoldenGate.

To download and install subsequent patches to the base release, go to the Patches and Updates tab of My Oracle Support at:

http://support.oracle.com

Also see Installing Patches for Oracle GoldenGate Microservices Architecture.

Topics:

• Installing Oracle GoldenGate Microservices Architecture
  
• Integrating Oracle GoldenGate Microservices Architecture into a Cluster
  

Installing Oracle GoldenGate Microservices Architecture

Note:

Oracle recommends using Oracle GoldenGate Microservices Architecture. From Oracle GoldenGate 21c onward, Oracle GoldenGate Classic Architecture for Oracle Database has been deprecated and may be desupported and unavailable in future releases.

The steps for installing Oracle GoldenGate Microservices Architecture for Oracle and Non-Oracle databases are the same. However, there are some requirements before you begin the installation.

Verify that you meet the operating system and required database configuration before beginning the installation. See:

• Operating System Requirements

• Prepare Databases

The Oracle GoldenGate Microservices Architecture (MA) installation involves the following steps:

1. Install the Oracle GoldenGate software. See Performing an Interactive Installation with OUI for MA and Performing a Silent Installation with OUI.

2. Set the necessary environment variables for your database, if required.

   Note:

   (Oracle only) From the Oracle GoldenGate 21c release onward, ORACLE_HOME and LD_LIBRARY_PATH do not point to any database directories. With the unified build feature, these environment variables now point to the OGG_HOME (sub)directories as the Oracle Database Client Software is embedded in Oracle GoldenGate.

3. Run the Oracle GoldenGate Configuration Assistant (oggca) wizard to add a deployment for the Oracle GoldenGate installation. For steps to run the OGGCA utility, see Add a Deployment.

The installer registers the Oracle GoldenGate home directory ($OGG_HOME) 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:

• Performing an Interactive Installation with OUI for MA
  
• Performing a Silent Installation with OUI
  

Performing an Interactive Installation with OUI for MA

Use the graphical user interface to install Oracle GoldenGate with prompts for required installation information. These instructions apply to new installations and upgrades:

1. Create a temporary staging directory where you will install Oracle GoldenGate.
   For example, on Linux the directory would be mkdir /u01/stage/oggsc.

   For Windows, create a directory where you will install Oracle GoldenGate such as, gghome, and a directory where you will keep the installation .zip file such as ogg. For example: C:\>mkdir gghome ogg

2. Extract the installation .zip file into the temporary staging directory. For example:

   For Linux: unzip ./fbo_ggs_Linux_x64_services.zip -d ./temp directory

   For Windows: C:\ogg>unzip fbo_ggs_Windows_x64_Oracle_services_shiphome.zip -d temp

3. From the expanded directory, run the fbo_ggs_Linux_x64_Oracle_services_shiphome/Disk1/runInstaller program on UNIX or Linux. On Windows, run the fbo_ggs_Windows_x64_Oracle_services_shiphome/Disk1/setup.exe program.
   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:
   1. For Software Location, specify the location where Oracle GoldenGate software will be installed. This will be your Oracle GoldenGate Home (OGG_HOME) after the installation is complete. For example: C:\gghome for Windows. 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.
   2. Click Next.
6. On the Summary page, confirm that there is enough space for the installation and that the installation selections are correct.
   1. (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.
   2. 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.
   3. 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.

You'll need to perform DataDirect driver installation for PostgreSQL after installing Oracle GoldenGate. See Install the DataDirect Driver for PostgreSQL for steps to perform this task.

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

You'll need to perform DataDirect driver installation for PostgreSQL after installing Oracle GoldenGate. See Install the DataDirect Driver for PostgreSQL for steps to perform this task.

Integrating Oracle GoldenGate Microservices Architecture into a Cluster

If you installed Oracle GoldenGate in a cluster, take the following steps to integrate Oracle GoldenGate within the cluster solution.

Oracle GoldenGate Microservices Architecture provides REST-enabled services with features including remote configuration, administration, and monitoring through HTML5 web pages, command line interfaces, and APIs.

For more information about installing and using Oracle GoldenGate in a cluster, see the Oracle GoldenGate Microservices Architecture with Oracle Real Application Clusters Configuration Best Practices technical brief.