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
http://www.oracle.com/technetwork/middleware/goldengate/downloads/index.html or https://edelivery.oracle.com >> Select a Product Pack: Oracle Fusion Middleware
[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 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
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=DBA Learning Hub1; 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=DBA Learning Hub1 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 (0xb2000000) libdl.so.2 => /lib64/libdl.so.2 (0xb1400000) 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 (0xb1800000) 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 (0xc3200000) libm.so.6 => /lib64/libm.so.6 (0xb1000000) libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0xbee00000) libc.so.6 => /lib64/libc.so.6 (0xb0c00000) /lib64/ld-linux-x86-64.so.2 (0xb0800000) libnsl.so.1 => /lib64/libnsl.so.1 (0xb5800000) libaio.so.1 => /usr/lib64/libaio.so.1 (0x00007f8e9a2c7000) [oracle@rac1 ogg11]$ [oracle@rac1 ogg11]$ ldd extract linux-vdso.so.1 => (0x00007fff) librt.so.1 => /lib64/librt.so.1 (0xb2000000) libdl.so.2 => /lib64/libdl.so.2 (0xb1400000) 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 (0xb1800000) 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 (0xc3200000) libm.so.6 => /lib64/libm.so.6 (0xb1000000) libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0xbee00000) libc.so.6 => /lib64/libc.so.6 (0xb0c00000) /lib64/ld-linux-x86-64.so.2 (0xb0800000) libnsl.so.1 => /lib64/libnsl.so.1 (0xb5800000) 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 (0xb2000000) libdl.so.2 => /lib64/libdl.so.2 (0xb1400000) 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 (0x00007ffc) libxerces-c.so.28 => /u01/app/oracle/product/gg/ogg11/libxerces-c.so.28 (0x00007ffc) libpthread.so.0 => /lib64/libpthread.so.0 (0xb1800000) libantlr3c.so => /u01/app/oracle/product/gg/ogg11/libantlr3c.so (0x00007ffc) 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 (0xc3200000) libm.so.6 => /lib64/libm.so.6 (0xb1000000) libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0xbee00000) libc.so.6 => /lib64/libc.so.6 (0xb0c00000) /lib64/ld-linux-x86-64.so.2 (0xb0800000) libnsl.so.1 => /lib64/libnsl.so.1 (0xb5800000) 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 (0xb2000000) libdl.so.2 => /lib64/libdl.so.2 (0xb1400000) 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 (0xb1800000) 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 (0xc3200000) libm.so.6 => /lib64/libm.so.6 (0xb1000000) libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0xbee00000) libc.so.6 => /lib64/libc.so.6 (0xb0c00000) /lib64/ld-linux-x86-64.so.2 (0xb0800000) libnsl.so.1 => /lib64/libnsl.so.1 (0xb5800000) 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/DBA Learning Hub/datafile/users. +TEST/DBA Learning Hub/datafile/undotbs5 +TEST/DBA Learning Hub/datafile/sysaux. +TEST/DBA Learning Hub/datafile/system. +TEST/DBA Learning Hub/datafile/undotbs5 +TEST/DBA Learning Hub/datafile/undotbs5 +TEST/DBA Learning Hub/datafile/ggadmin. 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 OGGCORE_12.1.2.0.0_PLATFORMS__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.DBA Learning Hub.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.DBA Learning Hub.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.