DBA Hub

📋Steps in this guide1/9

Install Oracle GoldenGate 19.1.0.0.4 for Oracle Database 19c on Linux 7

Install Oracle GoldenGate 19.1.0.0.4 for Oracle Database 19c on Linux 7

oracle Oracle 19cinstallationintermediate
by OracleDba
33 views
1

Overview

Install Oracle GoldenGate 19.1.0.0.4 for Oracle Database 19c on Linux 7 1. Overview

Code/Command (click line numbers to comment):

1
2
3
4
5
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

Section 2

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 /u01/app/oracle/product/19cogg 3. Verify Certification

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
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

Section 3

3. Verify Certification 4. Download software (OR)
Step 3

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
https://www.oracle.com/technetwork/middleware/ias/downloads/wls-1211x-certmatrix-1395408.xls

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

Section 4

https://edelivery.oracle.com >> Select a Product Pack : Oracle Fusion Middleware 5. Unzip the software 6. Installation

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
[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]$
5

Section 5

<----- ./runInstaller 7. Verify Central Inventory
Step 5

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
[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 ~]$
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]$
6

Section 6

<HOME NAME="OraHome1" LOC="/u01/app/oracle/product/ 19cogg " TYPE="O" IDX="5"/> 8. Set Environmental Variables 9. Verify Oracle GoldenGate libraries are linked with the Oracle Libraries

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
[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 ~]$
7

Section 7

ldd mgr ldd extract ldd replicat ldd ggsci Make sure no missing links to $ORACLE_HOME/lib.

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
[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.
8

Section 8

10. Create the required working directories for GoldenGate CREATE SUBDIRS Congratulations, Oracle GoldenGate 19c is installed 🙂 !!!

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
[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>
9

Section 9

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. 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. Reference: https://docs.oracle.com/en/middleware/goldengate/core/19.1/installing/installing-oracle-goldengate.html

Comments (0)

Please to add comments

No comments yet. Be the first to comment!