GoldenGate Installation

Installing Oracle GoldenGate V11.2.x for Oracle 10gR2 on Linux x86-64

Note: The below procedure is same for “Installing Oracle GoldenGate V11.2.x for Oracle 11gR2 on Linux x86-64”

Contents:
_________________________________________________________________________________________________________________

1. Download software
2. Unzip the software
3. Set Environmental Variables
4. Verify Oracle GoldenGate libraries are linked with the Oracle Libraries
5. Perform database prerequisites
6. 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

2. Unzip the software

cd /u01/app/oracle/product/gg10 unzip V32400-01.zip Archive: V32400-01.zip inflating: fbo_ggs_Linux_x64_ora10g_64bit.tar inflating: OGG_WinUnix_Rel_Notes_11.2.1.0.1.pdf inflating: Oracle GoldenGate 11.2.1.0.1 README.txt inflating: Oracle GoldenGate 11.2.1.0.1 README.doc tar -xvf fbo_ggs_Linux_x64_ora10g_64bit.tar

3. Set Environmental Variables

[oracle@rac1 ~]$ export ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1 [oracle@rac1 ~]$ export PATH=$PATH:/u01/app/oracle/product/gg10 [oracle@rac1 ~]$ export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/u01/app/oracle/product/gg10 [oracle@rac1 ~]$ env | grep ORACLE ORACLE_SID=rcm ORACLE_BASE=/u01/app/oracle ORACLE_TERM=xterm ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1 [oracle@rac1 ~]$ env | grep LD_LIBR LD_LIBRARY_PATH=/u01/app/oracle/product/10.2.0/db_1/lib:/u01/app/oracle/product/gg10

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

[oracle@rac1 ~]$ cd /u01/app/oracle/product/gg10 [oracle@rac1 gg10]$ ldd mgr linux-vdso.so.1 => (0x00007fff6a098000) libdl.so.2 => /lib64/libdl.so.2 (0x00000039b1400000) libgglog.so => /u01/app/oracle/product/gg10/libgglog.so (0x00007f869c8af000) libggrepo.so => /u01/app/oracle/product/gg10/libggrepo.so (0x00007f869c75b000) libdb-5.2.so => /u01/app/oracle/product/gg10/libdb-5.2.so (0x00007f869c4ba000) libicui18n.so.38 => /u01/app/oracle/product/gg10/libicui18n.so.38 (0x00007f869c159000) libicuuc.so.38 => /u01/app/oracle/product/gg10/libicuuc.so.38 (0x00007f869be20000) libicudata.so.38 => /u01/app/oracle/product/gg10/libicudata.so.38 (0x00007f869ae44000) libxerces-c.so.28 => /u01/app/oracle/product/gg10/libxerces-c.so.28 (0x00007f869a92c000) libpthread.so.0 => /lib64/libpthread.so.0 (0x00000039b1800000) libantlr3c.so => /u01/app/oracle/product/gg10/libantlr3c.so (0x00007f869a816000) libnnz10.so => /u01/app/oracle/product/10.2.0/db_1/lib/libnnz10.so (0x00007f869a374000) libclntsh.so.10.1 => /u01/app/oracle/product/10.2.0/db_1/lib/libclntsh.so.10.1 (0x00007f8698e3a000) 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) [oracle@rac1 gg10]$ ldd extract linux-vdso.so.1 => (0x00007fff955ff000) libdl.so.2 => /lib64/libdl.so.2 (0x00000039b1400000) libicui18n.so.38 => /u01/app/oracle/product/gg10/libicui18n.so.38 (0x00007fcd10e6c000) libicuuc.so.38 => /u01/app/oracle/product/gg10/libicuuc.so.38 (0x00007fcd10b33000) libicudata.so.38 => /u01/app/oracle/product/gg10/libicudata.so.38 (0x00007fcd0fb57000) libxerces-c.so.28 => /u01/app/oracle/product/gg10/libxerces-c.so.28 (0x00007fcd0f63f000) libpthread.so.0 => /lib64/libpthread.so.0 (0x00000039b1800000) libantlr3c.so => /u01/app/oracle/product/gg10/libantlr3c.so (0x00007fcd0f529000) libgglog.so => /u01/app/oracle/product/gg10/libgglog.so (0x00007fcd0f2f0000) libggrepo.so => /u01/app/oracle/product/gg10/libggrepo.so (0x00007fcd0f19c000) libdb-5.2.so => /u01/app/oracle/product/gg10/libdb-5.2.so (0x00007fcd0eefb000) libnnz10.so => /u01/app/oracle/product/10.2.0/db_1/lib/libnnz10.so (0x00007fcd0ea59000) libclntsh.so.10.1 => /u01/app/oracle/product/10.2.0/db_1/lib/libclntsh.so.10.1 (0x00007fcd0d51f000) 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) [oracle@rac1 gg10]$ ldd replicat linux-vdso.so.1 => (0x00007fff113f7000) libdl.so.2 => /lib64/libdl.so.2 (0x00000039b1400000) libgglog.so => /u01/app/oracle/product/gg10/libgglog.so (0x00007f41575cd000) libggrepo.so => /u01/app/oracle/product/gg10/libggrepo.so (0x00007f4157479000) libdb-5.2.so => /u01/app/oracle/product/gg10/libdb-5.2.so (0x00007f41571d8000) libicui18n.so.38 => /u01/app/oracle/product/gg10/libicui18n.so.38 (0x00007f4156e77000) libicuuc.so.38 => /u01/app/oracle/product/gg10/libicuuc.so.38 (0x00007f4156b3e000) libicudata.so.38 => /u01/app/oracle/product/gg10/libicudata.so.38 (0x00007f4155b62000) libxerces-c.so.28 => /u01/app/oracle/product/gg10/libxerces-c.so.28 (0x00007f415564a000) libpthread.so.0 => /lib64/libpthread.so.0 (0x00000039b1800000) libantlr3c.so => /u01/app/oracle/product/gg10/libantlr3c.so (0x00007f4155534000) libnnz10.so => /u01/app/oracle/product/10.2.0/db_1/lib/libnnz10.so (0x00007f4155092000) libclntsh.so.10.1 => /u01/app/oracle/product/10.2.0/db_1/lib/libclntsh.so.10.1 (0x00007f4153b58000) 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) [oracle@rac1 gg10]$ ldd ggsci linux-vdso.so.1 => (0x00007fff4235e000) libdl.so.2 => /lib64/libdl.so.2 (0x00000039b1400000) libgglog.so => /u01/app/oracle/product/gg10/libgglog.so (0x00007fbb96a78000) libggrepo.so => /u01/app/oracle/product/gg10/libggrepo.so (0x00007fbb96924000) libdb-5.2.so => /u01/app/oracle/product/gg10/libdb-5.2.so (0x00007fbb96683000) libicui18n.so.38 => /u01/app/oracle/product/gg10/libicui18n.so.38 (0x00007fbb96322000) libicuuc.so.38 => /u01/app/oracle/product/gg10/libicuuc.so.38 (0x00007fbb95fe9000) libicudata.so.38 => /u01/app/oracle/product/gg10/libicudata.so.38 (0x00007fbb9500d000) libpthread.so.0 => /lib64/libpthread.so.0 (0x00000039b1800000) libxerces-c.so.28 => /u01/app/oracle/product/gg10/libxerces-c.so.28 (0x00007fbb94af5000) libantlr3c.so => /u01/app/oracle/product/gg10/libantlr3c.so (0x00007fbb949df000) libnnz10.so => /u01/app/oracle/product/10.2.0/db_1/lib/libnnz10.so (0x00007fbb9453d000) libclntsh.so.10.1 => /u01/app/oracle/product/10.2.0/db_1/lib/libclntsh.so.10.1 (0x00007fbb93003000) 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) [oracle@rac1 gg10]$

5. Perform database prerequisites

SQL> select file_name from dba_data_files;

FILE_NAME

+VOL/rcm/users01.dbf +VOL/rcm/sysaux01.dbf +VOL/rcm/undotbs01.dbf +VOL/rcm/system01.dbf SQL>

SQL> CREATE TABLESPACE GATE DATAFILE '+VOL' SIZE 100M AUTOEXTEND ON;

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>

6. Create the required working directories for GoldenGate

cd /u01/app/oracle/product/gg10 [oracle@rac1 gg10]$ ggsci

Oracle GoldenGate Command Interpreter for Oracle Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230_FBO Linux, x64, 64bit (optimized), Oracle 10g on Apr 23 2012 07:30:46

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

GGSCI (rac1.rajasekhar.com) 1> CREATE SUBDIRS

Creating subdirectories under current directory /u01/app/oracle/product/gg10

Parameter files /u01/app/oracle/product/gg10/dirprm: already exists Report files /u01/app/oracle/product/gg10/dirrpt: created Checkpoint files /u01/app/oracle/product/gg10/dirchk: created Process status files /u01/app/oracle/product/gg10/dirpcs: created SQL script files /u01/app/oracle/product/gg10/dirsql: created Database definitions files /u01/app/oracle/product/gg10/dirdef: created Extract data files /u01/app/oracle/product/gg10/dirdat: created Temporary files /u01/app/oracle/product/gg10/dirtmp: created Stdout files /u01/app/oracle/product/gg10/dirout: created

GGSCI (rac1.rajasekhar.com) 2>

GoldenGate 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.