Tag Archives: goden gate

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


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.