Install Oracle GoldenGate [1]

27 Mar

Install Oracle GoldenGate [1]
I. Asumsi
a. kernel : 2.6.18-92.el5
b. distro : CentOS release 5.2 (Final) 64 bit
c. oracle server : 11.1.0.6.0
d. SID source : orcl10
SID source : orcl3

II. Langkah – langkah
a. install Oracle GoldenGate di SID source [orcl10]
1. download Oracle GoldenGate, semisal disimpan di folder /u01
2. Create directory
[oracle@orcl10 gg]$ mkdir /u01/app/oracle/product/gg
[oracle@orcl10 gg]$ export GGATE=/u01/app/oracle/product/gg

3. Agar permanen, tambahkan pada /home/oracle/.bash_profile
[oracle@orcl10 gg]$ vi ~/.bash_profile
GGATE=/u01/app/oracle/product/gg; export GGATE
PATH=$ORACLE_HOME/bin:$PATH:$GGATE; export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/u01/app/oracle/product/gg; export LD_LIBRARY_PATH

4. extract
[oracle@orcl10 gg]$ cd $GGATE
[oracle@orcl10 gg]$ cp /u01/V18157-01.zip $GGATE/
[oracle@orcl10 gg]$ unzip V18157-01.zip
[oracle@orcl10 gg]$ tar -xf ggs_redhatAS40_x64_ora10g_64bit_v10.4.0.19_002.tar

5. cari file libnnz11.so dan buat link file
[oracle@orcl10 gg]$ locate libnnz11.so
/u01/app/oracle/product/11.1.0/db_1/lib/libnnz11.so
/u01/app/oracle/product/11.1.0/db_1/lib32/libnnz11.so

[oracle@orcl10 gg]$ ln -s /u01/app/oracle/product/11.1.0/db_1/lib/libnnz11.so /u01/app/oracle/product/11.1.0/db_1/lib/libnnz10.so

6. Setelah re-login lagi
[oracle@orcl10 ~]$ cd $GGATE
[oracle@orcl10 gg]$ ./ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 10.4.0.19 Build 002
Linux, x64, 64bit (optimized), Oracle 10 on Sep 22 2009 14:18:08
Copyright (C) 1995, 2009, Oracle and/or its affiliates. All rights reserved.
GGSCI (orcl10) 1>

7. Create directories GoldenGate
GGSCI (orcl10) 1> create subdirs
Creating subdirectories under current directory /u01/app/oracle/product/gg
Parameter files /u01/app/oracle/product/gg/dirprm: created
Report files /u01/app/oracle/product/gg/dirrpt: created
Checkpoint files /u01/app/oracle/product/gg/dirchk: created
Process status files /u01/app/oracle/product/gg/dirpcs: created
SQL script files /u01/app/oracle/product/gg/dirsql: created
Database definitions files /u01/app/oracle/product/gg/dirdef: created
Extract data files /u01/app/oracle/product/gg/dirdat: created
Temporary files /u01/app/oracle/product/gg/dirtmp: created
Veridata files /u01/app/oracle/product/gg/dirver: created
Veridata Lock files /u01/app/oracle/product/gg/dirver/lock: created
Veridata Out-Of-Sync files /u01/app/oracle/product/gg/dirver/oos: created
Veridata Out-Of-Sync XML files /u01/app/oracle/product/gg/dirver/oosxml: created
Veridata Parameter files /u01/app/oracle/product/gg/dirver/params: created
Veridata Report files /u01/app/oracle/product/gg/dirver/report: created
Veridata Status files /u01/app/oracle/product/gg/dirver/status: created
Veridata Trace files /u01/app/oracle/product/gg/dirver/trace: created
Stdout files /u01/app/oracle/product/gg/dirout: created

GGSCI (orcl10) 2> exit
[oracle@orcl10 gg]$ mkdir $GGATE/discard

b. install Oracle GoldenGate di SID target [orcl3]
ulangi langkah a1 sampai dengan a7

[oracle@orcl3 u01]$ mkdir /u01/app/oracle/product/gg
[oracle@orcl3 u01]$ export GGATE=/u01/app/oracle/product/gg/
[oracle@orcl3 u01]$ vi ~/.bash_profile
[oracle@orcl3 u01]$ cd $GGATE
[oracle@orcl3 gg]$ cp /u01/V18157-01.zip $GGATE/
[oracle@orcl3 gg]$ unzip V18157-01.zip
Archive: V18157-01.zip
inflating: ggs_redhatAS40_x64_ora10g_64bit_v10.4.0.19_002.tar
[oracle@orcl3 gg]$ tar -xf ggs_redhatAS40_x64_ora10g_64bit_v10.4.0.19_002.tar
[oracle@orcl3 gg]$ locate libnnz11.so
/u01/app/oracle/product/11.1.0/db_1/lib/libnnz11.so
/u01/app/oracle/product/11.1.0/db_1/lib32/libnnz11.so
[oracle@orcl3 gg]$ ln -s /u01/app/oracle/product/11.1.0/db_1/lib/libnnz11.so /u01/app/oracle/product/11.1.0/db_1/lib/libnnz10.so

[oracle@orcl3 ~]$ cd $GGATE
[oracle@orcl3 gg]$ ./ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 10.4.0.19 Build 002
Linux, x64, 64bit (optimized), Oracle 10 on Sep 22 2009 14:18:08
Copyright (C) 1995, 2009, Oracle and/or its affiliates. All rights reserved.
GGSCI (orcl3) 1> create subdirs
Creating subdirectories under current directory /u01/app/oracle/product/gg
Parameter files /u01/app/oracle/product/gg/dirprm: created
Report files /u01/app/oracle/product/gg/dirrpt: created
Checkpoint files /u01/app/oracle/product/gg/dirchk: created
Process status files /u01/app/oracle/product/gg/dirpcs: created
SQL script files /u01/app/oracle/product/gg/dirsql: created
Database definitions files /u01/app/oracle/product/gg/dirdef: created
Extract data files /u01/app/oracle/product/gg/dirdat: created
Temporary files /u01/app/oracle/product/gg/dirtmp: created
Veridata files /u01/app/oracle/product/gg/dirver: created
Veridata Lock files /u01/app/oracle/product/gg/dirver/lock: created
Veridata Out-Of-Sync files /u01/app/oracle/product/gg/dirver/oos: created
Veridata Out-Of-Sync XML files /u01/app/oracle/product/gg/dirver/oosxml: created
Veridata Parameter files /u01/app/oracle/product/gg/dirver/params: created
Veridata Report files /u01/app/oracle/product/gg/dirver/report: created
Veridata Status files /u01/app/oracle/product/gg/dirver/status: created
Veridata Trace files /u01/app/oracle/product/gg/dirver/trace: created
Stdout files /u01/app/oracle/product/gg/dirout: created

GGSCI (orcl3) 2> exit
[oracle@orcl3 gg]$ mkdir $GGATE/discard

referensi :
http://www.pythian.com/news/7959/oracle-goldengate-installation-part-1/
http://gavinsoorma.com/2010/02/08/goldengate-concepts-and-architecture/
http://gavinsoorma.com/2010/02/09/goldengate-installation-oracle-11g-on-red-hat-linux/
http://gavinsoorma.com/2010/02/11/goldengate-tutorial-3-configuring-the-manager-process/
http://gavinsoorma.com/2010/02/15/oracle-goldengate-tutorial-4-performing-initial-data-load/

1. Oracle Golden Gate

2. install-oracle-goldengate 1

3. install-oracle-goldengate 2

4. install-oracle-goldengate 3

5 Responses to “Install Oracle GoldenGate [1]”

  1. arnold rinaldi October 20, 2010 at 8:35 am #

    whoa, this is awesome…
    thanks for the simple guide, i would like to try GG and found your blog

    it’s really useful…

    sekarang kucoba dulu yah, mudah2an jalan mulus…
    dpt pe er bikin backup db remote pakai GG🙂

  2. setijoagus October 22, 2010 at 8:28 am #

    semoga sukses ya………..

  3. Mayura November 3, 2010 at 7:50 pm #

    Really very helpfull…i did not find demo on installation of GG online…but this is a good one

  4. Mayura November 3, 2010 at 7:51 pm #

    How to decide the schema size for GG?

    • setijoagus November 5, 2010 at 6:23 am #

      i am sorry, i am not expert to decide the schema size for GG, but i use tablespace users (AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED) .

      SQL> create user ggate identified by 123456 default tablespace users temporary tablespace temp;

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: