Install Oracle GoldenGate in 1 instance database [1]

30 Mar

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

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 ~]$ mkdir /u01/app/oracle/product/gg

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

4. extract
[oracle@orcl10 ~]$ export GGATE=/u01/app/oracle/product/gg
[oracle@orcl10 ~]$ 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 ~]$ export GGATE=/u01/app/oracle/product/gg
[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

1. install oracle goldengate in 1 instance database-1

2. install oracle goldengate in 1 instance database-2

3. install oracle goldengate in 1 instance database-3

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: