DBA Hub

📋Steps in this guide1/6

Installing Oracle GoldenGate 12.1.2.0.0 for Oracle 11.2.0.3 on Linux x86-64

Installing Oracle GoldenGate 12.1.2.0.0 for Oracle 11.2.0.3 on Linux x86-64 Contents:

oracle installationintermediate
by OracleDba
14 views
1

Overview

Contents: 2. Unzip the software

Code/Command (click line numbers to comment):

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

Section 2

3. Installation *** Screenshots took from different server, so directory path will be different from this article 4. Set Environmental Variables
Step 2

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
[oracle@rac1 share]$ unzip fbo_ggs_Linux_x64_shiphome.zip

Please click here to download the screen shot
*** Screenshots took from different server, so directory path will be different from this article
[oracle@rac1 share]$
cd fbo_ggs_Linux_x64_shiphome
[oracle@rac1 fbo_ggs_Linux_x64_shiphome]$ ll
total 4
drwxr-xr-x 5 oracle oinstall 4096 Sep 25  2013 Disk1
[oracle@rac1 fbo_ggs_Linux_x64_shiphome]$
cd Disk1/
[oracle@rac1 Disk1]$ ll
total 16
drwxr-xr-x  4 oracle oinstall 4096 Sep 25  2013 install
drwxrwxr-x  2 oracle oinstall 4096 Sep 25  2013 response
-rwxr-xr-x  1 oracle oinstall  918 Sep 25  2013
runInstaller <-----
drwxr-xr-x 11 oracle oinstall 4096 Sep 25  2013 stage
[oracle@rac1 Disk1]$ export DISPLAY=192.168.2.2:0.0
[oracle@rac1 Disk1]$
./runInstaller
Starting Oracle Universal Installer...

Checking Temp space: must be greater than 120 MB.   Actual 5571 MB    Passed
Checking swap space: must be greater than 150 MB.   Actual 5671 MB    Passed
Checking monitor: must be configured to display at least 256 colors.    Actual 16777216    Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2016-12-03_04-15-08PM. Please wait ...[oracle@rac1 Disk1]$ You can find the log of this install session at:
 /u01/app/oraInventory/logs/installActions2016-12-03_04-15-08PM.log
3

Section 3

4. Set Environmental Variables 5. Verify Oracle GoldenGate libraries are linked with the Oracle Libraries ldd mgr

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
[oracle@rac1 ~]$
cat 11.env
GG11=/u01/app/oracle/product/gg/ogg11; export GG11
ORACLE_HOME=/u01/app/oracle/product/11.2.0.3/db_1;  export ORACLE_HOME
ORACLE_SID=br8dba1; export ORACLE_SID
PATH=$PATH:/u01/app/oracle/product/gg/ogg11; export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/u01/app/oracle/product/gg/ogg11; export LD_LIBRARY_PATH
alias ggsci='cd $GG11; ./ggsci'
[oracle@rac1 ~]$

. 11g.env
[oracle@rac1 ~]$
env | grep ORACLE
ORACLE_SID=br8dba1
ORACLE_BASE=/u01/app/oracle
ORACLE_TERM=xterm
ORACLE_HOME=/u01/app/oracle/product/11.2.0.3/db_1
[oracle@rac1 ~]$

[oracle@rac1 ~]$
env | grep LD_LIBR
LD_LIBRARY_PATH=/u01/app/oracle/product/11.2.0.3/db_1/lib:/u01/app/oracle/product/gg/ogg11
[oracle@rac1 ~]$

[oracle@rac1 ~]$ cd /u01/app/oracle/product/gg/ogg11
[oracle@rac1 ogg11]$
ldd mgr
linux-vdso.so.1 =>  (0x00007fffa67ff000)
        librt.so.1 => /lib64/librt.so.1 (0x00000039b2000000)
        libdl.so.2 => /lib64/libdl.so.2 (0x00000039b1400000)
        libgglog.so => /u01/app/oracle/product/gg/ogg11/libgglog.so (0x00007f8ea033c000)
        libggrepo.so => /u01/app/oracle/product/gg/ogg11/libggrepo.so (0x00007f8ea00d1000)
        libdb-5.2.so => /u01/app/oracle/product/gg/ogg11/libdb-5.2.so (0x00007f8e9fe35000)
        libggperf.so => /u01/app/oracle/product/gg/ogg11/libggperf.so (0x00007f8e9fc07000)
        libicui18n.so.48 => /u01/app/oracle/product/gg/ogg11/libicui18n.so.48 (0x00007f8e9f8f9000)
        libicuuc.so.48 => /u01/app/oracle/product/gg/ogg11/libicuuc.so.48 (0x00007f8e9f67a000)
        libicudata.so.48 => /u01/app/oracle/product/gg/ogg11/libicudata.so.48 (0x00007f8e9dfb5000)
        libxerces-c.so.28 => /u01/app/oracle/product/gg/ogg11/libxerces-c.so.28 (0x00007f8e9da9e000)
        libpthread.so.0 => /lib64/libpthread.so.0 (0x00000039b1800000)
        libantlr3c.so => /u01/app/oracle/product/gg/ogg11/libantlr3c.so (0x00007f8e9d987000)
        libnnz11.so => /u01/app/oracle/product/11.2.0.3/db_1/lib/libnnz11.so (0x00007f8e9d5ba000)
        libclntsh.so.11.1 => /u01/app/oracle/product/11.2.0.3/db_1/lib/libclntsh.so.11.1 (0x00007f8e9ac23000)
        libggnnzitp.so => /u01/app/oracle/product/gg/ogg11/libggnnzitp.so (0x00007f8e9a4ca000)
        libstdc++.so.6 => /usr/lib64/libstdc++.so.6 (0x00000039c3200000)
        libm.so.6 => /lib64/libm.so.6 (0x00000039b1000000)
        libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x00000039bee00000)
        libc.so.6 => /lib64/libc.so.6 (0x00000039b0c00000)
        /lib64/ld-linux-x86-64.so.2 (0x00000039b0800000)
        libnsl.so.1 => /lib64/libnsl.so.1 (0x00000039b5800000)
        libaio.so.1 => /usr/lib64/libaio.so.1 (0x00007f8e9a2c7000)
[oracle@rac1 ogg11]$
[oracle@rac1 ogg11]$
ldd extract
linux-vdso.so.1 =>  (0x00007fff75363000)
        librt.so.1 => /lib64/librt.so.1 (0x00000039b2000000)
        libdl.so.2 => /lib64/libdl.so.2 (0x00000039b1400000)
        libicui18n.so.48 => /u01/app/oracle/product/gg/ogg11/libicui18n.so.48 (0x00007f52d1e8e000)
        libicuuc.so.48 => /u01/app/oracle/product/gg/ogg11/libicuuc.so.48 (0x00007f52d1c10000)
        libicudata.so.48 => /u01/app/oracle/product/gg/ogg11/libicudata.so.48 (0x00007f52d054a000)
        libxerces-c.so.28 => /u01/app/oracle/product/gg/ogg11/libxerces-c.so.28 (0x00007f52d0033000)
        libpthread.so.0 => /lib64/libpthread.so.0 (0x00000039b1800000)
        libantlr3c.so => /u01/app/oracle/product/gg/ogg11/libantlr3c.so (0x00007f52cff1c000)
        libgglog.so => /u01/app/oracle/product/gg/ogg11/libgglog.so (0x00007f52cfb74000)
        libggrepo.so => /u01/app/oracle/product/gg/ogg11/libggrepo.so (0x00007f52cf909000)
        libdb-5.2.so => /u01/app/oracle/product/gg/ogg11/libdb-5.2.so (0x00007f52cf66d000)
        libggperf.so => /u01/app/oracle/product/gg/ogg11/libggperf.so (0x00007f52cf43f000)
        libnnz11.so => /u01/app/oracle/product/11.2.0.3/db_1/lib/libnnz11.so (0x00007f52cf072000)
        libclntsh.so.11.1 => /u01/app/oracle/product/11.2.0.3/db_1/lib/libclntsh.so.11.1 (0x00007f52cc6db000)
        libggnnzitp.so => /u01/app/oracle/product/gg/ogg11/libggnnzitp.so (0x00007f52cbf82000)
        libstdc++.so.6 => /usr/lib64/libstdc++.so.6 (0x00000039c3200000)
        libm.so.6 => /lib64/libm.so.6 (0x00000039b1000000)
        libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x00000039bee00000)
        libc.so.6 => /lib64/libc.so.6 (0x00000039b0c00000)
        /lib64/ld-linux-x86-64.so.2 (0x00000039b0800000)
        libnsl.so.1 => /lib64/libnsl.so.1 (0x00000039b5800000)
        libaio.so.1 => /usr/lib64/libaio.so.1 (0x00007f52cbd7f000)
[oracle@rac1 ogg11]$
[oracle@rac1 ogg11]$
ldd replicat
linux-vdso.so.1 =>  (0x00007fff7f3c6000)
        librt.so.1 => /lib64/librt.so.1 (0x00000039b2000000)
        libdl.so.2 => /lib64/libdl.so.2 (0x00000039b1400000)
        libgglog.so => /u01/app/oracle/product/gg/ogg11/libgglog.so (0x00007ffc2ad0e000)
        libggrepo.so => /u01/app/oracle/product/gg/ogg11/libggrepo.so (0x00007ffc2aaa3000)
        libdb-5.2.so => /u01/app/oracle/product/gg/ogg11/libdb-5.2.so (0x00007ffc2a807000)
        libggperf.so => /u01/app/oracle/product/gg/ogg11/libggperf.so (0x00007ffc2a5d9000)
        libicui18n.so.48 => /u01/app/oracle/product/gg/ogg11/libicui18n.so.48 (0x00007ffc2a2cb000)
        libicuuc.so.48 => /u01/app/oracle/product/gg/ogg11/libicuuc.so.48 (0x00007ffc2a04c000)
        libicudata.so.48 => /u01/app/oracle/product/gg/ogg11/libicudata.so.48 (0x00007ffc28987000)
        libxerces-c.so.28 => /u01/app/oracle/product/gg/ogg11/libxerces-c.so.28 (0x00007ffc28470000)
        libpthread.so.0 => /lib64/libpthread.so.0 (0x00000039b1800000)
        libantlr3c.so => /u01/app/oracle/product/gg/ogg11/libantlr3c.so (0x00007ffc28359000)
        libnnz11.so => /u01/app/oracle/product/11.2.0.3/db_1/lib/libnnz11.so (0x00007ffc27f8c000)
        libclntsh.so.11.1 => /u01/app/oracle/product/11.2.0.3/db_1/lib/libclntsh.so.11.1 (0x00007ffc255f5000)
        libggnnzitp.so => /u01/app/oracle/product/gg/ogg11/libggnnzitp.so (0x00007ffc24e9c000)
        libstdc++.so.6 => /usr/lib64/libstdc++.so.6 (0x00000039c3200000)
        libm.so.6 => /lib64/libm.so.6 (0x00000039b1000000)
        libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x00000039bee00000)
        libc.so.6 => /lib64/libc.so.6 (0x00000039b0c00000)
        /lib64/ld-linux-x86-64.so.2 (0x00000039b0800000)
        libnsl.so.1 => /lib64/libnsl.so.1 (0x00000039b5800000)
        libaio.so.1 => /usr/lib64/libaio.so.1 (0x00007ffc24c99000)
[oracle@rac1 ogg11]$
[oracle@rac1 ogg11]$
ldd ggsci
linux-vdso.so.1 =>  (0x00007fff947ff000)
        librt.so.1 => /lib64/librt.so.1 (0x00000039b2000000)
        libdl.so.2 => /lib64/libdl.so.2 (0x00000039b1400000)
        libgglog.so => /u01/app/oracle/product/gg/ogg11/libgglog.so (0x00007f4bd913f000)
        libggrepo.so => /u01/app/oracle/product/gg/ogg11/libggrepo.so (0x00007f4bd8ed4000)
        libdb-5.2.so => /u01/app/oracle/product/gg/ogg11/libdb-5.2.so (0x00007f4bd8c38000)
        libggperf.so => /u01/app/oracle/product/gg/ogg11/libggperf.so (0x00007f4bd8a0a000)
        libicui18n.so.48 => /u01/app/oracle/product/gg/ogg11/libicui18n.so.48 (0x00007f4bd86fc000)
        libicuuc.so.48 => /u01/app/oracle/product/gg/ogg11/libicuuc.so.48 (0x00007f4bd847d000)
        libicudata.so.48 => /u01/app/oracle/product/gg/ogg11/libicudata.so.48 (0x00007f4bd6db8000)
        libpthread.so.0 => /lib64/libpthread.so.0 (0x00000039b1800000)
        libxerces-c.so.28 => /u01/app/oracle/product/gg/ogg11/libxerces-c.so.28 (0x00007f4bd68a0000)
        libantlr3c.so => /u01/app/oracle/product/gg/ogg11/libantlr3c.so (0x00007f4bd678a000)
        libnnz11.so => /u01/app/oracle/product/11.2.0.3/db_1/lib/libnnz11.so (0x00007f4bd63bd000)
        libclntsh.so.11.1 => /u01/app/oracle/product/11.2.0.3/db_1/lib/libclntsh.so.11.1 (0x00007f4bd3a26000)
        libggnnzitp.so => /u01/app/oracle/product/gg/ogg11/libggnnzitp.so (0x00007f4bd32cd000)
        libstdc++.so.6 => /usr/lib64/libstdc++.so.6 (0x00000039c3200000)
        libm.so.6 => /lib64/libm.so.6 (0x00000039b1000000)
        libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x00000039bee00000)
        libc.so.6 => /lib64/libc.so.6 (0x00000039b0c00000)
        /lib64/ld-linux-x86-64.so.2 (0x00000039b0800000)
        libnsl.so.1 => /lib64/libnsl.so.1 (0x00000039b5800000)
        libaio.so.1 => /usr/lib64/libaio.so.1 (0x00007f4bd30ca000)
[oracle@rac1 ogg11]$
4

Section 4

ldd extract ldd replicat ldd ggsci 6. Perform database prerequisites

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
SQL>
select file_name from dba_data_files;
FILE_NAME
--------------------------------------------------------------------------------
+TEST/br8dba/datafile/users.259.924476255
+TEST/br8dba/datafile/undotbs1.260.924476255
+TEST/br8dba/datafile/sysaux.258.924476255
+TEST/br8dba/datafile/system.256.924476253
+TEST/br8dba/datafile/undotbs2.263.924476255
+TEST/br8dba/datafile/undotbs3.262.924476255
+TEST/br8dba/datafile/ggadmin.261.924476255

7 rows selected.

SQL>
CREATE TABLESPACE GATE DATAFILE '+TEST' SIZE 100M AUTOEXTEND ON MAXSIZE 30g;
Tablespace created.

SQL>
CREATE USER GATE IDENTIFIED BY gate DEFAULT TABLESPACE GATE TEMPORARY TABLESPACE TEMP;
User created.

SQL>
GRANT CONNECT TO GATE;
Grant succeeded.

SQL>
GRANT DBA TO GATE;
Grant succeeded.

SQL>
GRANT UNLIMITED TABLESPACE TO GATE;
Grant succeeded.

SQL>
GRANT SELECT ANY DICTIONARY TO GATE;
Grant succeeded.

SQL>
SELECT SUPPLEMENTAL_LOG_DATA_MIN FROM V$DATABASE;
SUPPLEME
--------
NO

SQL>
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
Database altered.

SQL>
ALTER SYSTEM SWITCH LOGFILE;
System altered.

SQL>
SELECT SUPPLEMENTAL_LOG_DATA_MIN FROM V$DATABASE;
SUPPLEME
--------
YES <----
SQL>
5

Section 5

7. Create the required working directories for GoldenGate GoldenGate 12 C 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. Caution:

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@rac1 ogg11]$ pwd
/u01/app/oracle/product/gg/ogg11
[oracle@rac1 ogg11]$
ggsci <----
Oracle GoldenGate Command Interpreter for Oracle
Version
12.1.2.0.0
17185003 OGGCORE_12.1.2.0.0_PLATFORMS_130924.1316_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Sep 25 2013 00:31:13
Operating system character set identified as UTF-8.

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

GGSCI (rac1.rajasekhar.com) 1>
CREATE SUBDIRS
Creating subdirectories under current directory /u01/app/oracle/product/gg/ogg11

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


GGSCI (rac1.rajasekhar.com) 2>
6

Section 6

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.

Comments (0)

Please to add comments

No comments yet. Be the first to comment!