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
___________________________________________________________________________________________________
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.
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
http://www.oracle.com/technetwork/middleware/goldengate/downloads/index.html (OR) https://edelivery.oracle.com >> Select a Product Pack: Oracle Fusion Middleware
[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]$
[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
[oracle@rac2 Disk1]$ You can find the log of this install session at:
/u01/app/oraInventory/logs/installActions2020-02-16_03-29-08AM.log
[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: