GoldenGate 12C Installation

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

Contents:
_________________________________________________________________________________________________________________

1. Download software
2. Unzip the software
3. Installation
4. Set Environmental Variables
5. Verify Oracle GoldenGate libraries are linked with the Oracle Libraries
6. Perform database prerequisites
7. Create the required working directories for GoldenGate
_________________________________________________________________________________________________________________

1. Download software


2. Unzip the software

[oracle@rac1 share]$ unzip fbo_ggs_Linux_x64_shiphome.zip


3. Installation

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

gg1gg2
gg3
gg4
gg5


4. Set Environmental Variables

[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 ~]$


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

. 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]$


6. Perform database prerequisites

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>


7. Create the required working directories for GoldenGate

[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>

GoldenGate 12C 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