Tag Archives: oracle goldengate 19c

Install Oracle GoldenGate 19c

Installing Oracle GoldenGate 19.1.0.0 for Oracle DB 12c on Linux 7

Table of Contents
___________________________________________________________________________________________________

1. Overview
2. Environment
3. Verify Certification
4. Download software
5. Unzip the software
6. Installation
7. Verify Central Inventory
8. Set Environmental Variables
9. Verify Oracle GoldenGate libraries are linked with the Oracle Libraries
10. Create the required working directories for GoldenGate

___________________________________________________________________________________________________


1. Overview

An instance of Oracle GoldenGate can be installed for only one major Oracle Database version in any given Oracle home. For example, if you have Oracle Database 11.2 and 12.1, you must have separate Oracle GoldenGate installations for each one.

(Optional) Select Start Manager to perform configuration functions, such as creating the Oracle GoldenGate subdirectories in the installation location, setting library paths, and starting Manager on the specified port number. To proceed, a database must exist on the system. When Start Manager is selected, the Database Location and Manager Port fields are displayed.

The default port is the first available one starting with 7809. If you are installing multiple instances of Oracle GoldenGate on the same system, each must use a different port number.


2. Environment

Server Name		: RAC1
OS Version		: Red Hat Enterprise Linux Server release 7.5
Database Version	: 12.2.0.1
GoldenGate Version	: 19.1.0.0.4 for oracle db 12.2.0.1
Oracle Home		: /u01/app/oracle/product/12.2.0/dbhome_1
GoldenGate Home		: /u01/app/oracle/product/12cogg


3. Verify Certification


4. Download software

http://www.oracle.com/technetwork/middleware/goldengate/downloads/index.html 
or
https://edelivery.oracle.com >> Select a Product Pack: Oracle Fusion Middleware


5. Unzip the software

[oracle@rac1 GG]$ pwd
/u01/app/backup/GG
[oracle@rac1 GG]$
[oracle@rac1 GG]$ unzip 191004_fbo_ggs_Linux_x64_shiphome.zip
[oracle@rac1 GG]$ ls -ltr
total 543540
-rw-r--r--. 1 oracle oinstall      1413 May 29  2019 OGG-19.1.0.0-README.txt
drwxr-xr-x. 3 oracle oinstall        19 Oct 18 21:20 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
-rw-r--r--. 1 oracle oinstall 556240981 Feb 11 21:22 191004_fbo_ggs_Linux_x64_shiphome.zip
[oracle@rac1 GG]$ 

[oracle@rac1 GG]$ cd fbo_ggs_Linux_x64_shiphome/Disk1
[oracle@rac1 Disk1]$ ls -ltr
total 12
drwxr-xr-x.  4 oracle oinstall 4096 Oct 18 21:20 install
drwxr-xr-x. 12 oracle oinstall 4096 Oct 18 21:20 stage
-rwxr-xr-x.  1 oracle oinstall  918 Oct 18 21:20 runInstaller
drwxrwxr-x.  2 oracle oinstall   25 Oct 18 21:20 response
[oracle@rac1 Disk1]$


6. Installation

[oracle@rac1 ~]$ mkdir -p /u01/app/oracle/product/12cogg

[oracle@rac1 Disk1]$ pwd
/u01/app/backup/GG/fbo_ggs_Linux_x64_shiphome/Disk1
[oracle@rac1 Disk1]$ export DISPLAY=192.168.2.2:0.0
[oracle@rac1 Disk1]$ ls -ltr
total 12
drwxr-xr-x.  4 oracle oinstall 4096 Oct 18 21:20 install
drwxr-xr-x. 12 oracle oinstall 4096 Oct 18 21:20 stage
-rwxr-xr-x.  1 oracle oinstall  918 Oct 18 21:20 runInstaller <----
drwxrwxr-x.  2 oracle oinstall   25 Oct 18 21:20 response
[oracle@rac1 Disk1]$ ./runInstaller
Starting Oracle Universal Installer...

Checking Temp space: must be greater than 120 MB.   Actual 4047 MB    Passed
Checking swap space: must be greater than 150 MB.   Actual 4095 MB    Passed
Checking monitor: must be configured to display at least 256 colors.    Actual 16777216    Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2020-02-12_12-58-11AM. Please wait ...[oracle@rac1 Disk1]$











[oracle@rac1 Disk1]$ You can find the log of this install session at:
 /u01/app/oraInventory/logs/installActions2020-02-12_12-58-11AM.log


7. Verify Central Inventory

[oracle@rac1 ContentsXML]$ pwd
/u01/app/oraInventory/ContentsXML
[oracle@rac1 ContentsXML]$ cat inventory.xml | grep -i "/u01/app/oracle/product/12cogg"
<HOME NAME="OraHome1" LOC="/u01/app/oracle/product/12cogg" TYPE="O" IDX="6"/>
[oracle@rac1 ContentsXML]$


8. Set Environmental Variables

[oracle@rac1 ~]$ cat 12cogg.env
GG12C=/u01/app/oracle/product/12cogg; export GG12C
ORACLE_HOME=/u01/app/oracle/product/12.2.0/dbhome_1;  export ORACLE_HOME
ORACLE_SID=MAVIC12; export ORACLE_SID
PATH=$PATH:/u01/app/oracle/product/12cogg; export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/u01/app/oracle/product/12cogg; export LD_LIBRARY_PATH
alias ggsci='cd $GG12C; ./ggsci'
[oracle@rac1 ~]$


9. Verify Oracle GoldenGate libraries are linked with the Oracle Libraries

[oracle@rac1 ~]$ . 12cogg.env
[oracle@rac1 ~]$ env | grep ORACLE
ORACLE_SID=MAVIC12
ORACLE_HOME=/u01/app/oracle/product/12.2.0/dbhome_1
[oracle@rac1 ~]$

[oracle@rac1 ~]$ env | grep LD_LIBR
LD_LIBRARY_PATH=/u01/app/oracle/product/12.2.0/dbhome_1/lib:/u01/app/oracle/product/12cogg
[oracle@rac1 ~]$

[oracle@rac1 ~]$ cd /u01/app/oracle/product/12cogg
[oracle@rac1 12cogg]$
[oracle@rac1 12cogg]$ ldd mgr
        linux-vdso.so.1 =>  (0x00007ffde853a000)
        librt.so.1 => /lib64/librt.so.1 (0x00007f3e7c71f000)
        libdl.so.2 => /lib64/libdl.so.2 (0x00007f3e7c51a000)
        libgglog.so => /u01/app/oracle/product/12cogg/./libgglog.so (0x00007f3e7c1b4000)
        libggutil.so => /u01/app/oracle/product/12cogg/./libggutil.so (0x00007f3e7bf98000)
        libggrepo.so => /u01/app/oracle/product/12cogg/./libggrepo.so (0x00007f3e7bcdd000)
        libdb-6.1.so => /u01/app/oracle/product/12cogg/./libdb-6.1.so (0x00007f3e7b8c7000)
        liblmdb.so => /u01/app/oracle/product/12cogg/./liblmdb.so (0x00007f3e7b6b2000)
        libggperf.so => /u01/app/oracle/product/12cogg/./libggperf.so (0x00007f3e7b47f000)
        libggparam.so => /u01/app/oracle/product/12cogg/./libggparam.so (0x00007f3e79d66000)
        libicui18n.so.62 => /u01/app/oracle/product/12cogg/./libicui18n.so.62 (0x00007f3e79881000)
        libicuuc.so.62 => /u01/app/oracle/product/12cogg/./libicuuc.so.62 (0x00007f3e7947f000)
        libicudata.so.62 => /u01/app/oracle/product/12cogg/./libicudata.so.62 (0x00007f3e77467000)
        libxerces-c-3.2.so => /u01/app/oracle/product/12cogg/./libxerces-c-3.2.so (0x00007f3e76df3000)
        libpthread.so.0 => /lib64/libpthread.so.0 (0x00007f3e76bd6000)
        libantlr3c.so => /u01/app/oracle/product/12cogg/./libantlr3c.so (0x00007f3e769bb000)
        libnnz12.so => /u01/app/oracle/product/12.2.0/dbhome_1/lib/libnnz12.so (0x00007f3e76272000)
        libclntsh.so.12.1 => /u01/app/oracle/product/12.2.0/dbhome_1/lib/libclntsh.so.12.1 (0x00007f3e727cc000)
        libons.so => /u01/app/oracle/product/12.2.0/dbhome_1/lib/libons.so (0x00007f3e7257e000)
        libclntshcore.so.12.1 => /u01/app/oracle/product/12.2.0/dbhome_1/lib/libclntshcore.so.12.1 (0x00007f3e71fb0000)
        libggnnzitp.so => /u01/app/oracle/product/12cogg/./libggnnzitp.so (0x00007f3e714dd000)
        libstdc++.so.6 => /u01/app/oracle/product/12cogg/./libstdc++.so.6 (0x00007f3e71146000)
        libm.so.6 => /lib64/libm.so.6 (0x00007f3e70e44000)
        libgcc_s.so.1 => /u01/app/oracle/product/12cogg/./libgcc_s.so.1 (0x00007f3e70c2d000)
        libc.so.6 => /lib64/libc.so.6 (0x00007f3e70860000)
        /lib64/ld-linux-x86-64.so.2 (0x000055fd1da0b000)
        libnsl.so.1 => /lib64/libnsl.so.1 (0x00007f3e70645000)
        libmql1.so => /u01/app/oracle/product/12.2.0/dbhome_1/lib/libmql1.so (0x00007f3e703ce000)
        libipc1.so => /u01/app/oracle/product/12.2.0/dbhome_1/lib/libipc1.so (0x00007f3e6ff9a000)
        libaio.so.1 => /lib64/libaio.so.1 (0x00007f3e6fd98000)
        libresolv.so.2 => /lib64/libresolv.so.2 (0x00007f3e6fb7f000)
[oracle@rac1 12cogg]$

[oracle@rac1 12cogg]$ ldd extract
        linux-vdso.so.1 =>  (0x00007ffdad253000)
        librt.so.1 => /lib64/librt.so.1 (0x00007f6a88b86000)
        libdl.so.2 => /lib64/libdl.so.2 (0x00007f6a88981000)
        libgglog.so => /u01/app/oracle/product/12cogg/./libgglog.so (0x00007f6a8861b000)
        libggutil.so => /u01/app/oracle/product/12cogg/./libggutil.so (0x00007f6a883ff000)
        libggrepo.so => /u01/app/oracle/product/12cogg/./libggrepo.so (0x00007f6a88144000)
        libdb-6.1.so => /u01/app/oracle/product/12cogg/./libdb-6.1.so (0x00007f6a87d2e000)
        liblmdb.so => /u01/app/oracle/product/12cogg/./liblmdb.so (0x00007f6a87b19000)
        libggperf.so => /u01/app/oracle/product/12cogg/./libggperf.so (0x00007f6a878e6000)
        libggparam.so => /u01/app/oracle/product/12cogg/./libggparam.so (0x00007f6a861cd000)
        libicui18n.so.62 => /u01/app/oracle/product/12cogg/./libicui18n.so.62 (0x00007f6a85ce8000)
        libicuuc.so.62 => /u01/app/oracle/product/12cogg/./libicuuc.so.62 (0x00007f6a858e6000)
        libicudata.so.62 => /u01/app/oracle/product/12cogg/./libicudata.so.62 (0x00007f6a838ce000)
        libxerces-c-3.2.so => /u01/app/oracle/product/12cogg/./libxerces-c-3.2.so (0x00007f6a8325a000)
        libpthread.so.0 => /lib64/libpthread.so.0 (0x00007f6a8303d000)
        libantlr3c.so => /u01/app/oracle/product/12cogg/./libantlr3c.so (0x00007f6a82e22000)
        libnnz12.so => /u01/app/oracle/product/12.2.0/dbhome_1/lib/libnnz12.so (0x00007f6a826d9000)
        libclntsh.so.12.1 => /u01/app/oracle/product/12.2.0/dbhome_1/lib/libclntsh.so.12.1 (0x00007f6a7ec33000)
        libons.so => /u01/app/oracle/product/12.2.0/dbhome_1/lib/libons.so (0x00007f6a7e9e5000)
        libclntshcore.so.12.1 => /u01/app/oracle/product/12.2.0/dbhome_1/lib/libclntshcore.so.12.1 (0x00007f6a7e417000)
        libggnnzitp.so => /u01/app/oracle/product/12cogg/./libggnnzitp.so (0x00007f6a7d944000)
        libstdc++.so.6 => /u01/app/oracle/product/12cogg/./libstdc++.so.6 (0x00007f6a7d5ad000)
        libm.so.6 => /lib64/libm.so.6 (0x00007f6a7d2ab000)
        libgcc_s.so.1 => /u01/app/oracle/product/12cogg/./libgcc_s.so.1 (0x00007f6a7d094000)
        libc.so.6 => /lib64/libc.so.6 (0x00007f6a7ccc7000)
        /lib64/ld-linux-x86-64.so.2 (0x000055e7e6189000)
        libnsl.so.1 => /lib64/libnsl.so.1 (0x00007f6a7caac000)
        libmql1.so => /u01/app/oracle/product/12.2.0/dbhome_1/lib/libmql1.so (0x00007f6a7c835000)
        libipc1.so => /u01/app/oracle/product/12.2.0/dbhome_1/lib/libipc1.so (0x00007f6a7c401000)
        libaio.so.1 => /lib64/libaio.so.1 (0x00007f6a7c1ff000)
        libresolv.so.2 => /lib64/libresolv.so.2 (0x00007f6a7bfe6000)
[oracle@rac1 12cogg]$

[oracle@rac1 12cogg]$ ldd replicat
        linux-vdso.so.1 =>  (0x00007ffeca88d000)
        librt.so.1 => /lib64/librt.so.1 (0x00007fa8bfba9000)
        libdl.so.2 => /lib64/libdl.so.2 (0x00007fa8bf9a4000)
        libgglog.so => /u01/app/oracle/product/12cogg/./libgglog.so (0x00007fa8bf63e000)
        libggutil.so => /u01/app/oracle/product/12cogg/./libggutil.so (0x00007fa8bf422000)
        libggrepo.so => /u01/app/oracle/product/12cogg/./libggrepo.so (0x00007fa8bf167000)
        libdb-6.1.so => /u01/app/oracle/product/12cogg/./libdb-6.1.so (0x00007fa8bed51000)
        liblmdb.so => /u01/app/oracle/product/12cogg/./liblmdb.so (0x00007fa8beb3c000)
        libggperf.so => /u01/app/oracle/product/12cogg/./libggperf.so (0x00007fa8be909000)
        libggparam.so => /u01/app/oracle/product/12cogg/./libggparam.so (0x00007fa8bd1f0000)
        libicui18n.so.62 => /u01/app/oracle/product/12cogg/./libicui18n.so.62 (0x00007fa8bcd0b000)
        libicuuc.so.62 => /u01/app/oracle/product/12cogg/./libicuuc.so.62 (0x00007fa8bc909000)
        libicudata.so.62 => /u01/app/oracle/product/12cogg/./libicudata.so.62 (0x00007fa8ba8f1000)
        libxerces-c-3.2.so => /u01/app/oracle/product/12cogg/./libxerces-c-3.2.so (0x00007fa8ba27d000)
        libpthread.so.0 => /lib64/libpthread.so.0 (0x00007fa8ba060000)
        libantlr3c.so => /u01/app/oracle/product/12cogg/./libantlr3c.so (0x00007fa8b9e45000)
        libnnz12.so => /u01/app/oracle/product/12.2.0/dbhome_1/lib/libnnz12.so (0x00007fa8b96fc000)
        libclntsh.so.12.1 => /u01/app/oracle/product/12.2.0/dbhome_1/lib/libclntsh.so.12.1 (0x00007fa8b5c56000)
        libons.so => /u01/app/oracle/product/12.2.0/dbhome_1/lib/libons.so (0x00007fa8b5a08000)
        libclntshcore.so.12.1 => /u01/app/oracle/product/12.2.0/dbhome_1/lib/libclntshcore.so.12.1 (0x00007fa8b543a000)
        libggnnzitp.so => /u01/app/oracle/product/12cogg/./libggnnzitp.so (0x00007fa8b4967000)
        libstdc++.so.6 => /u01/app/oracle/product/12cogg/./libstdc++.so.6 (0x00007fa8b45d0000)
        libm.so.6 => /lib64/libm.so.6 (0x00007fa8b42ce000)
        libgcc_s.so.1 => /u01/app/oracle/product/12cogg/./libgcc_s.so.1 (0x00007fa8b40b7000)
        libc.so.6 => /lib64/libc.so.6 (0x00007fa8b3cea000)
        /lib64/ld-linux-x86-64.so.2 (0x000055bb3e3e8000)
        libnsl.so.1 => /lib64/libnsl.so.1 (0x00007fa8b3acf000)
        libmql1.so => /u01/app/oracle/product/12.2.0/dbhome_1/lib/libmql1.so (0x00007fa8b3858000)
        libipc1.so => /u01/app/oracle/product/12.2.0/dbhome_1/lib/libipc1.so (0x00007fa8b3424000)
        libaio.so.1 => /lib64/libaio.so.1 (0x00007fa8b3222000)
        libresolv.so.2 => /lib64/libresolv.so.2 (0x00007fa8b3009000)
[oracle@rac1 12cogg]$

[oracle@rac1 12cogg]$ ldd ggsci
        linux-vdso.so.1 =>  (0x00007ffd3cdd0000)
        librt.so.1 => /lib64/librt.so.1 (0x00007fcbc2f48000)
        libdl.so.2 => /lib64/libdl.so.2 (0x00007fcbc2d43000)
        libgglog.so => /u01/app/oracle/product/12cogg/./libgglog.so (0x00007fcbc29dd000)
        libggutil.so => /u01/app/oracle/product/12cogg/./libggutil.so (0x00007fcbc27c1000)
        libggrepo.so => /u01/app/oracle/product/12cogg/./libggrepo.so (0x00007fcbc2506000)
        libdb-6.1.so => /u01/app/oracle/product/12cogg/./libdb-6.1.so (0x00007fcbc20f0000)
        liblmdb.so => /u01/app/oracle/product/12cogg/./liblmdb.so (0x00007fcbc1edb000)
        libggperf.so => /u01/app/oracle/product/12cogg/./libggperf.so (0x00007fcbc1ca8000)
        libggparam.so => /u01/app/oracle/product/12cogg/./libggparam.so (0x00007fcbc058f000)
        libicui18n.so.62 => /u01/app/oracle/product/12cogg/./libicui18n.so.62 (0x00007fcbc00aa000)
        libicuuc.so.62 => /u01/app/oracle/product/12cogg/./libicuuc.so.62 (0x00007fcbbfca8000)
        libicudata.so.62 => /u01/app/oracle/product/12cogg/./libicudata.so.62 (0x00007fcbbdc90000)
        libpthread.so.0 => /lib64/libpthread.so.0 (0x00007fcbbda74000)
        libxerces-c-3.2.so => /u01/app/oracle/product/12cogg/./libxerces-c-3.2.so (0x00007fcbbd3ff000)
        libantlr3c.so => /u01/app/oracle/product/12cogg/./libantlr3c.so (0x00007fcbbd1e4000)
        libnnz12.so => /u01/app/oracle/product/12.2.0/dbhome_1/lib/libnnz12.so (0x00007fcbbca9b000)
        libclntsh.so.12.1 => /u01/app/oracle/product/12.2.0/dbhome_1/lib/libclntsh.so.12.1 (0x00007fcbb8ff5000)
        libons.so => /u01/app/oracle/product/12.2.0/dbhome_1/lib/libons.so (0x00007fcbb8da7000)
        libclntshcore.so.12.1 => /u01/app/oracle/product/12.2.0/dbhome_1/lib/libclntshcore.so.12.1 (0x00007fcbb87d9000)
        libggnnzitp.so => /u01/app/oracle/product/12cogg/./libggnnzitp.so (0x00007fcbb7d06000)
        libstdc++.so.6 => /u01/app/oracle/product/12cogg/./libstdc++.so.6 (0x00007fcbb796f000)
        libm.so.6 => /lib64/libm.so.6 (0x00007fcbb766d000)
        libgcc_s.so.1 => /u01/app/oracle/product/12cogg/./libgcc_s.so.1 (0x00007fcbb7456000)
        libc.so.6 => /lib64/libc.so.6 (0x00007fcbb7089000)
        /lib64/ld-linux-x86-64.so.2 (0x000055f4b6ba5000)
        libnsl.so.1 => /lib64/libnsl.so.1 (0x00007fcbb6e6e000)
        libmql1.so => /u01/app/oracle/product/12.2.0/dbhome_1/lib/libmql1.so (0x00007fcbb6bf7000)
        libipc1.so => /u01/app/oracle/product/12.2.0/dbhome_1/lib/libipc1.so (0x00007fcbb67c3000)
        libaio.so.1 => /lib64/libaio.so.1 (0x00007fcbb65c1000)
        libresolv.so.2 => /lib64/libresolv.so.2 (0x00007fcbb63a8000)
[oracle@rac1 12cogg]$

Make sure no missing links to $ORACLE_HOME/lib.


10. Create the required working directories for GoldenGate

[oracle@rac1 ~]$ . 12cogg.env
[oracle@rac1 ~]$
[oracle@rac1 ~]$ ggsci

Oracle GoldenGate Command Interpreter for Oracle
Version 19.1.0.0.4 OGGCORE_19.1.0.0.0_PLATFORMS_191017.1054_FBO
Linux, x64, 64bit (optimized), Oracle 12c on Oct 18 2019 01:38:51
Operating system character set identified as UTF-8.

Copyright (C) 1995, 2019, Oracle and/or its affiliates. All rights reserved.



GGSCI (rac1) 1> CREATE SUBDIRS

Creating subdirectories under current directory /u01/app/oracle/product/12cogg

Parameter file                 /u01/app/oracle/product/12cogg/dirprm: created.
Report file                    /u01/app/oracle/product/12cogg/dirrpt: created.
Checkpoint file                /u01/app/oracle/product/12cogg/dirchk: created.
Process status files           /u01/app/oracle/product/12cogg/dirpcs: created.
SQL script files               /u01/app/oracle/product/12cogg/dirsql: created.
Database definitions files     /u01/app/oracle/product/12cogg/dirdef: created.
Extract data files             /u01/app/oracle/product/12cogg/dirdat: created.
Temporary files                /u01/app/oracle/product/12cogg/dirtmp: created.
Credential store files         /u01/app/oracle/product/12cogg/dircrd: created.
Masterkey wallet files         /u01/app/oracle/product/12cogg/dirwlt: created.
Dump files                     /u01/app/oracle/product/12cogg/dirdmp: created.


GGSCI (rac1) 2>

Congratulations, Oracle GoldenGate 19c is installed 🙂 !!!

Caution: Your use of any information or materials on this website is entirely at your own risk. It is provided for educational purposes only. It has been tested internally, however, we do not guarantee that it will work for you. Ensure that you run it in your test environment before using.

Thank you,
Rajasekhar Amudala
Email: br8dba@gmail.com
WhatsApp : +
Linkedin: https://www.linkedin.com/in/rajasekhar-amudala/

Reference:

https://docs.oracle.com/en/middleware/goldengate/core/19.1/installing/installing-oracle-goldengate.html