Installing Oracle GoldenGate 19c on Linux 7
Introduction
Oracle GoldenGate is a comprehensive software package for real-time data integration and replication in heterogeneous IT environments. It enables high availability, real-time data integration, transactional change data capture, data replication, transformations, and verification between operational and analytical enterprise systems.
This article provides a step-by-step guide to installing Oracle GoldenGate 19c on a Linux 7 server. The installation is performed using the Oracle Universal Installer (OUI) wizard, which provides a graphical interface for the installation process.
Overview of the Installation Process
| # | Step | Description |
|---|---|---|
| 1 | Create Directory | Create a directory for the GoldenGate software |
| 2 | Set Environment | Add the GoldenGate home to the environment |
| 3 | Extract Software | Unzip the GoldenGate installation media |
| 4 | Run Installer | Start the Oracle Universal Installer |
| 5 | Choose Database Version | Select the database version for GoldenGate |
| 6 | Select GoldenGate Home | Specify the installation location |
| 7 | Review and Install | Confirm settings and begin installation |
| 8 | Installation Progress | Monitor the installation |
| 9 | Completion | Verify successful installation |
| 10 | Verify Manager | Confirm the Manager process is running |
Prerequisites
Before you begin, ensure the following:
A Linux 7 server with Oracle Database 19c installed
The oracle user account with appropriate permissions
Sufficient disk space for the GoldenGate software
The GoldenGate installation media downloaded
Download the Software
Download Oracle GoldenGate 19c from the Oracle website:
191004_fbo_ggs_Linux_x64_shiphome.zipNote: You may need an Oracle Support account to download the software, depending on your support status.
Step 1: Create the Directory for the Software
Create a directory where the GoldenGate software will be installed:
[oracle@dev19c ~]$ mkdir /u01/app/oracle/product/ggTip: Choose a directory path that follows your organization's standards. In this example, the GoldenGate home is
/u01/app/oracle/product/gg.
Step 2: Set the Environment Variables
Add the GoldenGate home to the Oracle user's environment file.
Edit the
setEnv.shscript:
[oracle@dev19c ~]$ cd /home/oracle/scripts/
[oracle@dev19c scripts]$ vi setEnv.shVerify the contents of
setEnv.sh:
[oracle@dev19c scripts]$ cat setEnv.sh
# Oracle Settings
export TMP=/tmp
export TMPDIR=$TMP
export ORACLE_HOSTNAME=`hostname -s`
export ORACLE_UNQNAME=ORCL
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/19.3.0/db_1
export ORA_INVENTORY=/u01/app/oraInventory
export ORACLE_SID=ORCL
export PATH=/usr/sbin:/usr/local/bin:$PATH
export PATH=$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
export GGATE=/u01/app/oracle/product/ggImportant: The
GGATEvariable points to the GoldenGate home directory. Make sure this matches the directory you created in Step 1.
Source the
.bash_profileand verify the GoldenGate home:
[oracle@dev19c scripts]$ cd $GGATE
[oracle@dev19c ~]$ . .bash_profile
[oracle@dev19c ~]$ cd $GGATE
[oracle@dev19c gg]$ pwd
/u01/app/oracle/product/ggResult: The
GGATEenvironment variable is now set and points to the correct directory.
Step 3: Move and Unzip the GoldenGate Software
Navigate to the GoldenGate home:
[oracle@dev19c Desktop]$ cd /u01/app/oracle/product/gg
[oracle@dev19c gg]$ ls -lrt
total 543208
-rwxr--r--. 1 oracle oinstall 556240981 Nov 24 17:56 191004_fbo_ggs_Linux_x64_shiphome.zipUnzip the software:
[oracle@dev19c gg]$ unzip 191004_fbo_ggs_Linux_x64_shiphome.zip
Archive: 191004_fbo_ggs_Linux_x64_shiphome.zip
creating: fbo_ggs_Linux_x64_shiphome/
creating: fbo_ggs_Linux_x64_shiphome/Disk1/
creating: fbo_ggs_Linux_x64_shiphome/Disk1/install/
inflating: fbo_ggs_Linux_x64_shiphome/Disk1/install/.oui
inflating: fbo_ggs_Linux_x64_shiphome/Disk1/install/attachHome.sh
inflating: fbo_ggs_Linux_x64_shiphome/Disk1/install/clusterparam.ini
inflating: fbo_ggs_Linux_x64_shiphome/Disk1/install/detachHome.shVerify the extracted files:
[oracle@dev19c gg]$ ls -lrt
total 543548
-rw-r--r--. 1 oracle oinstall 1413 May 29 16:49 OGG-19.1.0.0-README.txt
drwxr-xr-x. 3 oracle oinstall 4096 Oct 18 18:50 fbo_ggs_Linux_x64_shiphome
-rw-r--r--. 1 oracle oinstall 332523 Oct 21 11:01 OGG_WinUnix_Rel_Notes_19.1.0.0.4.pdf
-rwxr--r--. 1 oracle oinstall 556240981 Nov 24 17:56 191004_fbo_ggs_Linux_x64_shiphome.zipResult: The GoldenGate installation files are now extracted. The
fbo_ggs_Linux_x64_shiphomedirectory contains theDisk1directory with the installer.
Step 4: Run the Oracle GoldenGate 19c Installer
Navigate to the Disk1 directory:
[oracle@dev19c gg]$ cd fbo_ggs_Linux_x64_shiphome/
[oracle@dev19c fbo_ggs_Linux_x64_shiphome]$ ls
Disk1
[oracle@dev19c fbo_ggs_Linux_x64_shiphome]$ cd Disk1/Run the installer:
[oracle@dev19c Disk1]$ ./runInstallerNote: The installer requires a graphical display (X11). If you are working on a headless server, you will need to use X11 forwarding or a VNC session.
Tip: If the installer doesn't start, verify that the
DISPLAYenvironment variable is set correctly.
Step 5: Choose Your Database Version
The first screen of the installer asks you to choose your database version.
Select the appropriate database version for your environment (e.g., Oracle Database 19c)
Click Next to proceed
Note: GoldenGate 19c supports multiple database versions, including Oracle Database 11g, 12c, 18c, and 19c. Choose the version that matches your source or target database.
Step 6: Select the GoldenGate Home
The next screen asks you to select the GoldenGate Home (the installation location).
Specify the GoldenGate Home directory (e.g.,
/u01/app/oracle/product/gg)Click Next to proceed
Important: The GoldenGate Home should be an empty directory. If you created the directory in Step 1, it should already be empty.
Step 7: Double-Check and Start the Installation
The Summary screen displays all the settings you have chosen.
Review the settings carefully
Click Install to begin the installation
Tip: This is your last chance to go back and change any settings before the installation begins.
Step 8: Installation in Progress
The installer displays a progress screen as it installs Oracle GoldenGate 19c.
The progress bar shows the installation status
Wait for the installation to complete
Note: The installation typically takes a few minutes, depending on your system's performance.
Step 9: Installation Completed Successfully
Once the installation is complete, the installer displays a success message.
Click Finish to close the installer
Result: Oracle GoldenGate 19c is now installed in the specified GoldenGate Home directory.
Step 10: Verify the Manager is Running
After the installation, you should verify that the GoldenGate Manager process is up and running.
Log in to a new terminal session (e.g., via PuTTY)
Navigate to the GoldenGate home:
cd $GGATEStart the GoldenGate command interface (GGSCI):
./ggsciCheck the Manager status:
GGSCI> info allStart the Manager if it is not running:
GGSCI> start managerResult: The Manager process is now up and running, and GoldenGate is ready for configuration.
The Complete Installation Flow
┌─────────────────────────────────────────────────────────────────┐
│ 1. CREATE DIRECTORY │
│ mkdir /u01/app/oracle/product/gg │
└──────────────────────────┬──────────────────────────────────────┘
│
▼
┌─────────────────────────────────────────────────────────────────┐
│ 2. SET ENVIRONMENT │
│ Add GGATE=/u01/app/oracle/product/gg to setEnv.sh │
│ Source .bash_profile │
└──────────────────────────┬──────────────────────────────────────┘
│
▼
┌─────────────────────────────────────────────────────────────────┐
│ 3. EXTRACT SOFTWARE │
│ unzip 191004_fbo_ggs_Linux_x64_shiphome.zip │
└──────────────────────────┬──────────────────────────────────────┘
│
▼
┌─────────────────────────────────────────────────────────────────┐
│ 4. RUN INSTALLER │
│ cd fbo_ggs_Linux_x64_shiphome/Disk1 │
│ ./runInstaller │
└──────────────────────────┬──────────────────────────────────────┘
│
▼
┌─────────────────────────────────────────────────────────────────┐
│ 5. CHOOSE DATABASE VERSION │
│ Select Oracle Database 19c │
└──────────────────────────┬──────────────────────────────────────┘
│
▼
┌─────────────────────────────────────────────────────────────────┐
│ 6. SELECT GOLDENGATE HOME │
│ Specify /u01/app/oracle/product/gg │
└──────────────────────────┬──────────────────────────────────────┘
│
▼
┌─────────────────────────────────────────────────────────────────┐
│ 7. REVIEW AND INSTALL │
│ Confirm settings and click Install │
└──────────────────────────┬──────────────────────────────────────┘
│
▼
┌─────────────────────────────────────────────────────────────────┐
│ 8. INSTALLATION PROGRESS │
│ Wait for the progress bar to complete │
└──────────────────────────┬──────────────────────────────────────┘
│
▼
┌─────────────────────────────────────────────────────────────────┐
│ 9. COMPLETION │
│ Click Finish to close the installer │
└──────────────────────────┬──────────────────────────────────────┘
│
▼
┌─────────────────────────────────────────────────────────────────┐
│ 10. VERIFY MANAGER │
│ ./ggsci │
│ GGSCI> info all │
│ GGSCI> start manager │
└─────────────────────────────────────────────────────────────────┘Key Paths and Configuration
| Item | Path / Value |
|---|---|
| GoldenGate Home | /u01/app/oracle/product/gg |
| GGATE Environment Variable | /u01/app/oracle/product/gg |
| Installer Location | fbo_ggs_Linux_x64_shiphome/Disk1/runInstaller |
| GGSCI Command | $GGATE/ggsci |
| Manager Process | Started via GGSCI> start manager |
Best Practices
| Practice | Description |
|---|---|
| Use a Dedicated Directory | Install GoldenGate in a dedicated directory separate from the database |
| Set Environment Variables | Add GGATE to the environment for easy access |
| Verify Manager Status | Always verify the Manager is running after installation |
| Secure the Installation | Restrict access to the GoldenGate home directory |
| Document the Installation | Keep a record of the installation path and version |
| Back Up Configuration | Back up GoldenGate configuration files regularly |
| Monitor Disk Space | Ensure sufficient disk space for trail files and logs |
| Apply Patches | Keep GoldenGate updated with the latest patches |
Troubleshooting Common Issues
| Issue | Possible Cause | Solution |
|---|---|---|
| Installer won't start | DISPLAY not set | Set the DISPLAY variable or use X11 forwarding |
| Installation fails | Insufficient disk space | Free up disk space and retry |
| Manager won't start | Wrong environment | Verify GGATE and source .bash_profile |
| GGSCI command not found | Wrong directory | Navigate to $GGATE before running ./ggsci |
| Permission denied | Wrong user | Run the installer as the oracle user |
| Unzip fails | Corrupted download | Re-download the software |
| GoldenGate Home not empty | Existing files | Use an empty directory or clean it first |
Summary
Installing Oracle GoldenGate 19c on Linux 7 involves the following key steps:
Create Directory: Create a directory for the GoldenGate software
Set Environment: Add
GGATEto the environment and source.bash_profileExtract Software: Unzip the GoldenGate installation media
Run Installer: Start the Oracle Universal Installer from the
Disk1directoryChoose Database Version: Select the appropriate database version
Select GoldenGate Home: Specify the installation location
Review and Install: Confirm settings and begin installation
Wait for Completion: Monitor the installation progress
Finish: Close the installer upon successful completion
Verify Manager: Confirm the Manager process is running
Key Points to Remember
The GoldenGate Home is a dedicated directory for the software
The
GGATEenvironment variable provides easy access to the GoldenGate homeThe Oracle Universal Installer provides a graphical interface for the installation
The Manager process is the heart of GoldenGate and must be running
The GGSCI command interface is used to manage GoldenGate
X11 forwarding is required for the graphical installer
The installation is straightforward and takes only a few minutes
Why This Matters
Oracle GoldenGate is essential for:
Real-Time Data Integration: Enables real-time data movement between systems
High Availability: Supports active-active and active-passive configurations
Disaster Recovery: Provides data replication for business continuity
Data Warehousing: Enables real-time data feeds to analytical systems
Zero Downtime Migrations: Supports migrations with minimal downtime
Heterogeneous Replication: Works across different database platforms
By mastering Oracle GoldenGate installation, you can build robust data integration and replication solutions that meet the most demanding business requirements.
References
Oracle GoldenGate Documentation: Installation and Setup Guide
Oracle GoldenGate Documentation: Administrator's Guide
Oracle Database Documentation: Database Installation Guide for Linux
My Oracle Support: Oracle GoldenGate 19c Certification Matrix
Related Articles: Oracle Database 19c Installation, Oracle GoldenGate Configuration
No comments:
Post a Comment