Tag Archives: Install Oracle Goldengate 19c Install Oracle Goldengate 19c

Install Oracle GoldenGate 19C for Database 19C

Install Oracle GoldenGate 19.1.0.0.4 for Oracle Database 19c 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 sub directories 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		: RAC2
OS Version		: Red Hat Enterprise Linux Server release 7.5
Database Version	: 19c
GoldenGate Version	: 19.1.0.0.4 for oracle db 19c
Oracle Home		: /u01/app/oracle/product/19.0.0/dbhome_1
GoldenGate Home		: /u01/app/oracle/product/19cogg


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@rac2 GG19]$ pwd
/u01/app/backup/GG19
[oracle@rac2 GG19]$ unzip 191004_fbo_ggs_Linux_x64_shiphome.zip
[oracle@rac2 GG19]$ 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@rac2 GG19]$

[oracle@rac2 GG19]$ cd fbo_ggs_Linux_x64_shiphome/Disk1
[oracle@rac2 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@rac2 Disk1]$


6. Installation

[oracle@rac2 ~]$ mkdir -p /u01/app/oracle/product/19cogg

[oracle@rac2 Disk1]$ pwd
/u01/app/backup/GG19/fbo_ggs_Linux_x64_shiphome/Disk1
[oracle@rac2 Disk1]$ export DISPLAY=192.168.2.2:0.0
[oracle@rac2 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@rac2 Disk1]$
[oracle@rac2 Disk1]$ ./runInstaller
Starting Oracle Universal Installer...

Checking Temp space: must be greater than 120 MB.   Actual 4044 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-16_03-29-08AM. Please wait ...











[oracle@rac2 Disk1]$ You can find the log of this install session at:
 /u01/app/oraInventory/logs/installActions2020-02-16_03-29-08AM.log


7. Verify Central Inventory

[oracle@rac2 ~]$ cd /u01/app/oraInventory/ContentsXML
[oracle@rac2 ContentsXML]$ cat inventory.xml | grep -i "/u01/app/oracle/product/19cogg"
<HOME NAME="OraHome1" LOC="/u01/app/oracle/product/19cogg" TYPE="O" IDX="5"/>
[oracle@rac2 ContentsXML]$


8. Set Environmental Variables

[oracle@rac2 ~]$ cat 19cogg.env
GG19C=/u01/app/oracle/product/19cogg; export GG19C
ORACLE_HOME=/u01/app/oracle/product/19.0.0/dbhome_1;  export ORACLE_HOME
ORACLE_SID=MAVIC12; export ORACLE_SID
PATH=$PATH:/u01/app/oracle/product/19cogg; export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/u01/app/oracle/product/19cogg; export LD_LIBRARY_PATH
alias ggsci='cd $GG19C; ./ggsci'
[oracle@rac2 ~]$


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

[oracle@rac2 ~]$ . 19cogg.env
[oracle@rac2 ~]$ env | grep ORACLE
ORACLE_SID=MAVIC12
ORACLE_HOME=/u01/app/oracle/product/19.0.0/dbhome_1
[oracle@rac2 ~]$
[oracle@rac2 ~]$ env | grep LD_LIBR
LD_LIBRARY_PATH=/u01/app/oracle/product/19.0.0/dbhome_1/lib:/u01/app/oracle/product/19cogg
[oracle@rac2 ~]$
[oracle@rac2 ~]$ cd /u01/app/oracle/product/19cogg
[oracle@rac2 19cogg]$
[oracle@rac2 19cogg]$ ldd mgr
        linux-vdso.so.1 =>  (0x00007fffe37fa000)
        librt.so.1 => /lib64/librt.so.1 (0x00007f3b96a4d000)
        libdl.so.2 => /lib64/libdl.so.2 (0x00007f3b96848000)
        libgglog.so => /u01/app/oracle/product/19cogg/./libgglog.so (0x00007f3b964e2000)
        libggutil.so => /u01/app/oracle/product/19cogg/./libggutil.so (0x00007f3b962c6000)
        libggrepo.so => /u01/app/oracle/product/19cogg/./libggrepo.so (0x00007f3b9600b000)
        libdb-6.1.so => /u01/app/oracle/product/19cogg/./libdb-6.1.so (0x00007f3b95bf5000)
        liblmdb.so => /u01/app/oracle/product/19cogg/./liblmdb.so (0x00007f3b959e0000)
        libggperf.so => /u01/app/oracle/product/19cogg/./libggperf.so (0x00007f3b957ad000)
        libggparam.so => /u01/app/oracle/product/19cogg/./libggparam.so (0x00007f3b94094000)
        libicui18n.so.62 => /u01/app/oracle/product/19cogg/./libicui18n.so.62 (0x00007f3b93baf000)
        libicuuc.so.62 => /u01/app/oracle/product/19cogg/./libicuuc.so.62 (0x00007f3b937ad000)
        libicudata.so.62 => /u01/app/oracle/product/19cogg/./libicudata.so.62 (0x00007f3b91795000)
        libxerces-c-3.2.so => /u01/app/oracle/product/19cogg/./libxerces-c-3.2.so (0x00007f3b91121000)
        libpthread.so.0 => /lib64/libpthread.so.0 (0x00007f3b90f04000)
        libantlr3c.so => /u01/app/oracle/product/19cogg/./libantlr3c.so (0x00007f3b90ce9000)
        libnnz19.so => /u01/app/oracle/product/19.0.0/dbhome_1/lib/libnnz19.so (0x00007f3b905a1000)
        libclntsh.so.19.1 => /u01/app/oracle/product/19.0.0/dbhome_1/lib/libclntsh.so.19.1 (0x00007f3b8c57d000)
        libclntshcore.so.19.1 => /u01/app/oracle/product/19.0.0/dbhome_1/lib/libclntshcore.so.19.1 (0x00007f3b8bfdd000)
        libggnnzitp.so => /u01/app/oracle/product/19cogg/./libggnnzitp.so (0x00007f3b8b4c6000)
        libstdc++.so.6 => /u01/app/oracle/product/19cogg/./libstdc++.so.6 (0x00007f3b8b12e000)
        libm.so.6 => /lib64/libm.so.6 (0x00007f3b8ae2c000)
        libgcc_s.so.1 => /u01/app/oracle/product/19cogg/./libgcc_s.so.1 (0x00007f3b8ac16000)
        libc.so.6 => /lib64/libc.so.6 (0x00007f3b8a848000)
        /lib64/ld-linux-x86-64.so.2 (0x000055ea0224e000)
        libnsl.so.1 => /lib64/libnsl.so.1 (0x00007f3b8a62e000)
        libaio.so.1 => /lib64/libaio.so.1 (0x00007f3b8a42b000)
        libresolv.so.2 => /lib64/libresolv.so.2 (0x00007f3b8a212000)
[oracle@rac2 19cogg]$
[oracle@rac2 19cogg]$ ldd extract
        linux-vdso.so.1 =>  (0x00007ffc1cf96000)
        librt.so.1 => /lib64/librt.so.1 (0x00007f520828e000)
        libdl.so.2 => /lib64/libdl.so.2 (0x00007f5208089000)
        libgglog.so => /u01/app/oracle/product/19cogg/./libgglog.so (0x00007f5207d23000)
        libggutil.so => /u01/app/oracle/product/19cogg/./libggutil.so (0x00007f5207b07000)
        libggrepo.so => /u01/app/oracle/product/19cogg/./libggrepo.so (0x00007f520784c000)
        libdb-6.1.so => /u01/app/oracle/product/19cogg/./libdb-6.1.so (0x00007f5207436000)
        liblmdb.so => /u01/app/oracle/product/19cogg/./liblmdb.so (0x00007f5207221000)
        libggperf.so => /u01/app/oracle/product/19cogg/./libggperf.so (0x00007f5206fee000)
        libggparam.so => /u01/app/oracle/product/19cogg/./libggparam.so (0x00007f52058d5000)
        libicui18n.so.62 => /u01/app/oracle/product/19cogg/./libicui18n.so.62 (0x00007f52053f0000)
        libicuuc.so.62 => /u01/app/oracle/product/19cogg/./libicuuc.so.62 (0x00007f5204fee000)
        libicudata.so.62 => /u01/app/oracle/product/19cogg/./libicudata.so.62 (0x00007f5202fd6000)
        libxerces-c-3.2.so => /u01/app/oracle/product/19cogg/./libxerces-c-3.2.so (0x00007f5202962000)
        libpthread.so.0 => /lib64/libpthread.so.0 (0x00007f5202745000)
        libantlr3c.so => /u01/app/oracle/product/19cogg/./libantlr3c.so (0x00007f520252a000)
        libnnz19.so => /u01/app/oracle/product/19.0.0/dbhome_1/lib/libnnz19.so (0x00007f5201de2000)
        libclntsh.so.19.1 => /u01/app/oracle/product/19.0.0/dbhome_1/lib/libclntsh.so.19.1 (0x00007f51fddbe000)
        libclntshcore.so.19.1 => /u01/app/oracle/product/19.0.0/dbhome_1/lib/libclntshcore.so.19.1 (0x00007f51fd81e000)
        libggnnzitp.so => /u01/app/oracle/product/19cogg/./libggnnzitp.so (0x00007f51fcd07000)
        libstdc++.so.6 => /u01/app/oracle/product/19cogg/./libstdc++.so.6 (0x00007f51fc96f000)
        libm.so.6 => /lib64/libm.so.6 (0x00007f51fc66d000)
        libgcc_s.so.1 => /u01/app/oracle/product/19cogg/./libgcc_s.so.1 (0x00007f51fc457000)
        libc.so.6 => /lib64/libc.so.6 (0x00007f51fc089000)
        /lib64/ld-linux-x86-64.so.2 (0x00005600bebc9000)
        libnsl.so.1 => /lib64/libnsl.so.1 (0x00007f51fbe6f000)
        libaio.so.1 => /lib64/libaio.so.1 (0x00007f51fbc6c000)
        libresolv.so.2 => /lib64/libresolv.so.2 (0x00007f51fba53000)
[oracle@rac2 19cogg]$
[oracle@rac2 19cogg]$ ldd replicat
        linux-vdso.so.1 =>  (0x00007ffe6ad7f000)
        librt.so.1 => /lib64/librt.so.1 (0x00007f1649396000)
        libdl.so.2 => /lib64/libdl.so.2 (0x00007f1649191000)
        libgglog.so => /u01/app/oracle/product/19cogg/./libgglog.so (0x00007f1648e2b000)
        libggutil.so => /u01/app/oracle/product/19cogg/./libggutil.so (0x00007f1648c0f000)
        libggrepo.so => /u01/app/oracle/product/19cogg/./libggrepo.so (0x00007f1648954000)
        libdb-6.1.so => /u01/app/oracle/product/19cogg/./libdb-6.1.so (0x00007f164853e000)
        liblmdb.so => /u01/app/oracle/product/19cogg/./liblmdb.so (0x00007f1648329000)
        libggperf.so => /u01/app/oracle/product/19cogg/./libggperf.so (0x00007f16480f6000)
        libggparam.so => /u01/app/oracle/product/19cogg/./libggparam.so (0x00007f16469dd000)
        libicui18n.so.62 => /u01/app/oracle/product/19cogg/./libicui18n.so.62 (0x00007f16464f8000)
        libicuuc.so.62 => /u01/app/oracle/product/19cogg/./libicuuc.so.62 (0x00007f16460f6000)
        libicudata.so.62 => /u01/app/oracle/product/19cogg/./libicudata.so.62 (0x00007f16440de000)
        libxerces-c-3.2.so => /u01/app/oracle/product/19cogg/./libxerces-c-3.2.so (0x00007f1643a6a000)
        libpthread.so.0 => /lib64/libpthread.so.0 (0x00007f164384d000)
        libantlr3c.so => /u01/app/oracle/product/19cogg/./libantlr3c.so (0x00007f1643632000)
        libnnz19.so => /u01/app/oracle/product/19.0.0/dbhome_1/lib/libnnz19.so (0x00007f1642eea000)
        libclntsh.so.19.1 => /u01/app/oracle/product/19.0.0/dbhome_1/lib/libclntsh.so.19.1 (0x00007f163eec6000)
        libclntshcore.so.19.1 => /u01/app/oracle/product/19.0.0/dbhome_1/lib/libclntshcore.so.19.1 (0x00007f163e926000)
        libggnnzitp.so => /u01/app/oracle/product/19cogg/./libggnnzitp.so (0x00007f163de0f000)
        libstdc++.so.6 => /u01/app/oracle/product/19cogg/./libstdc++.so.6 (0x00007f163da77000)
        libm.so.6 => /lib64/libm.so.6 (0x00007f163d775000)
        libgcc_s.so.1 => /u01/app/oracle/product/19cogg/./libgcc_s.so.1 (0x00007f163d55f000)
        libc.so.6 => /lib64/libc.so.6 (0x00007f163d191000)
        /lib64/ld-linux-x86-64.so.2 (0x00005634bbe76000)
        libnsl.so.1 => /lib64/libnsl.so.1 (0x00007f163cf77000)
        libaio.so.1 => /lib64/libaio.so.1 (0x00007f163cd74000)
        libresolv.so.2 => /lib64/libresolv.so.2 (0x00007f163cb5b000)
[oracle@rac2 19cogg]$
[oracle@rac2 19cogg]$ ldd ggsci
        linux-vdso.so.1 =>  (0x00007fffdb8df000)
        librt.so.1 => /lib64/librt.so.1 (0x00007f73a1461000)
        libdl.so.2 => /lib64/libdl.so.2 (0x00007f73a125c000)
        libgglog.so => /u01/app/oracle/product/19cogg/./libgglog.so (0x00007f73a0ef6000)
        libggutil.so => /u01/app/oracle/product/19cogg/./libggutil.so (0x00007f73a0cda000)
        libggrepo.so => /u01/app/oracle/product/19cogg/./libggrepo.so (0x00007f73a0a1f000)
        libdb-6.1.so => /u01/app/oracle/product/19cogg/./libdb-6.1.so (0x00007f73a0609000)
        liblmdb.so => /u01/app/oracle/product/19cogg/./liblmdb.so (0x00007f73a03f4000)
        libggperf.so => /u01/app/oracle/product/19cogg/./libggperf.so (0x00007f73a01c1000)
        libggparam.so => /u01/app/oracle/product/19cogg/./libggparam.so (0x00007f739eaa8000)
        libicui18n.so.62 => /u01/app/oracle/product/19cogg/./libicui18n.so.62 (0x00007f739e5c3000)
        libicuuc.so.62 => /u01/app/oracle/product/19cogg/./libicuuc.so.62 (0x00007f739e1c1000)
        libicudata.so.62 => /u01/app/oracle/product/19cogg/./libicudata.so.62 (0x00007f739c1a9000)
        libpthread.so.0 => /lib64/libpthread.so.0 (0x00007f739bf8d000)
        libxerces-c-3.2.so => /u01/app/oracle/product/19cogg/./libxerces-c-3.2.so (0x00007f739b918000)
        libantlr3c.so => /u01/app/oracle/product/19cogg/./libantlr3c.so (0x00007f739b6fd000)
        libnnz19.so => /u01/app/oracle/product/19.0.0/dbhome_1/lib/libnnz19.so (0x00007f739afb5000)
        libclntsh.so.19.1 => /u01/app/oracle/product/19.0.0/dbhome_1/lib/libclntsh.so.19.1 (0x00007f7396f91000)
        libclntshcore.so.19.1 => /u01/app/oracle/product/19.0.0/dbhome_1/lib/libclntshcore.so.19.1 (0x00007f73969f1000)
        libggnnzitp.so => /u01/app/oracle/product/19cogg/./libggnnzitp.so (0x00007f7395eda000)
        libstdc++.so.6 => /u01/app/oracle/product/19cogg/./libstdc++.so.6 (0x00007f7395b42000)
        libm.so.6 => /lib64/libm.so.6 (0x00007f7395840000)
        libgcc_s.so.1 => /u01/app/oracle/product/19cogg/./libgcc_s.so.1 (0x00007f739562a000)
        libc.so.6 => /lib64/libc.so.6 (0x00007f739525c000)
        /lib64/ld-linux-x86-64.so.2 (0x000055f6fb3e5000)
        libnsl.so.1 => /lib64/libnsl.so.1 (0x00007f7395041000)
        libaio.so.1 => /lib64/libaio.so.1 (0x00007f7394e3f000)
        libresolv.so.2 => /lib64/libresolv.so.2 (0x00007f7394c26000)
[oracle@rac2 19cogg]$

Make sure no missing links to $ORACLE_HOME/lib.


10. Create the required working directories for GoldenGate

[oracle@rac2 ~]$ . 19cogg.env
[oracle@rac2 ~]$ 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 19c on Oct 17 2019 21:16:29
Operating system character set identified as UTF-8.

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



GGSCI (rac2.rajasekhar.com) 1> CREATE SUBDIRS

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

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


GGSCI (rac2.rajasekhar.com) 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

GG 19C

Table of Contents
________________________________________________________________________________________________

1. Installing Oracle GoldenGate 19.1.0.0 for Oracle 12c on Linux 7

2. Installing Oracle GoldenGate 19.1.0.0 for Oracle 19c on Linux 7

________________________________________________________________________________________________