Oracle GoldenGate 12c Classic Architecture Installation

This chapter includes instructions for installing the classic Oracle Goldengate for the first time. Installing Oracle Goldengate installs all the components required to run and manage processing (excluding any components provided by other vendors, such as drivers or libraries) and installs the Oracle Goldengate utility.

Theme:

• Set Oracle_home and Oracle_sid
• Database requirements
• Installing Oracle GoldenGate

Set Oracle_home and Oracle_sid

Make sure that the Oracle_home and ORACLE_SID system environment variables are set to the correct Oracle instance. The Oracle goldengate process references them when they connect to the database.

Environment variables under the Oracle user, such as:

Export oracle_home=/u01/app/oracle/product/11.2. 0/dbhome_1export oracle_sid=dg01

In addition, an additional environment variable ogg_home can be set to specify the installation directory of Ogg, which can be identified when Oui installed:

Export Ogg_home=/u01/app/OGG

Database requirements

This section contains Oracle Goldengate requirements that are specific to Oracle databases. Unless explicitly stated, these apply to both capture modes.

• If you are using Dbms_lob. The LoadFromFile process updates only the LOB columns, and your supplemental log is on all columns, integrated extract captures the key columns and the lob that improves performance. Classic extract captures all columns by default. These behaviors does not affect like to like replications. However, by copying to the Data warehouse, all columns may have to be updated. If you want to convert from classic Extract to integrated Extract, you must use one of the following parameters to ensure that the Extract is working correctly:
  1. Add all columns with Keycols (except LOB)
  2. Use Logallsupcols to control which columns are written to the supplemental record.
• Database user rights and configuration requirements are described in establishing Oracle GoldenGate credentials when installing and configuring an Oracle GoldenGate for Oracle Database
• If the database is configured to use a legacy connection, the Sqlnet.ora file must contain the Bequeath_detach = True setting.
• The Oracle database must be in Archivelog mode so that extract can process the log files.
• Make sure that supplemental LOGGING is enabled for your database.

To implement the operation:

To set the archive log directory and archive log file name, refer to: Oracle Enable archive logging

1. Enable Oracle Additional logging function

SQL>ALTERDATABASEADDLOG  DATA; Database altered.

2. Open Mandatory Archive

SQL>ALTERDATABASE Force LOGGING; Database altered.

3. Restart Oracle to Mount

Sql> shutdownimmediate;Databaseclosed.Databasedismounted. ORACLE instance shut down. SQL>Startup Mountoracle instance started. Total System Global Area1.9241E+Tenbytesfixed Size2261368bytesvariable Size2885684872bytesDatabaseBuffers1.6307E+TenBytesredo Buffers45658112bytesDatabasemounted. SQL> Altersystem Register; System altered. SQL> 

4. Open Archive

SQL>alterdatabase  archivelog; Database altered.

5. Open the Database

SQL>alterdatabaseopen; Database altered.

6. Enable OGG replication

SQL>alterset enable_goldengate_replication=true; System altered.

Installing Oracle GoldenGate

Racle Oracle GoldenGate for Oracle database is installed from Oracle Universal Installer (OUI). Oui is a graphical installer that prompts you for input required to install Oracle Goldengate binaries and working files, and sets the correct database environment in which Oracle Goldengate will run.

Oui can be used on any Linux,unix and Windows platform supported by Oui and on any platform supported by Oracle Goldengate.

Oracle version 11g and later supports Oui. An instance of Oracle Goldengate can only be installed in one of the primary Oracle database versions in any given Oracle home directory. For example, if you have Oracle Database 11.2 and 12.1, you must install the Oracle GoldenGate separately for each installation. This does not apply to data patch levels in the same major release. You can install multiple Oracle Goldengate instances on the same host for the same or different database versions.

The Setup program registers the Oracle Goldengate home directory with the central inventory associated with the selected database. If the product was installed using Oui, the inventory stores information about all Oracle software products installed on the host.

• Performing an interactive installation using Oui
• Use Oui to perform a silent installation
• Installing on Windows
• Integrated into a single cluster

Performing an interactive installation using Oui

The interactive installation provides a graphical user interface that prompts for the required installation information. These instructions apply to new installations and upgrades. However, to upgrade to Oracle GoldenGate, follow the instructions in upgrading Oracle GoldenGate for Windows and UNIX, including prompting to run Oui at the appropriate time.

1, decompression 123012_fbo_ggs_linux_x64_shiphome.zip

2. Run Runinstaller (This step uses VNC)

[[email protected] Disk1]$ ./Runinstaller starting Oracle Universal Installer ... CheckingTemp Space: Must be greater than -MB. Actual7471MB passedchecking SwapSpace: Must be greater than MaxMB. Actual65535MB passedchecking monitor:must be configured toDisplay at least theColors. Actual16777216passedpreparing toLaunch Oracle Universal Installer from /Tmp/OraInstall2018- .-14_Geneva- the-57PM. Please wait ...[[email protected] Disk1]$

Start the Oui interface here

Note: The path in is not the same as the environment variable set above, because the server for the environment variable and the server that is installed are not the same.

1) Select Installation Option

2) Specify installation Details

3) Summary

4) Install Product

5) Finish

Resources

https://docs.oracle.com/goldengate/c1230/gg-winux/OGGIN/installing-oracle-goldengate-db.htm# Oggin-guid-26b1503f-39a3-4020-8b1b-38846764dd64

Oracle GoldenGate 12c Classic Architecture Installation