ITPub博客

首页 > 数据库 > Oracle > 【OGG】Oracle GoldenGate 11g (一) 安装GoldenGate 11g on Linux

【OGG】Oracle GoldenGate 11g (一) 安装GoldenGate 11g on Linux

原创 Oracle 作者:海星星hktk 时间:2017-11-20 15:24:30 0 删除 编辑


Oracle GoldenGate 11g (一) 

安装Oracle GoldenGate 11g on Linux


 

Item

Source System

Target System

Platform

RHEL6.4 - 64bit

RHEL6.4 - 64bit

Hostname

rhel64.oracle.com

ora11g.oracle.com

Database

Oracle 11.2.0.3

Oracle 11.2.0.3

Character Set

AL32UTF8

AL32UTF8

ORACLE_SID

PROD

EMREP

Listener Name/Port

LISTENER/1521

LISTENER/1521

Goldengate User

ogg

ogg

 


1.1    Introduction

       This Document briefly describes how to replicate data change from local database(Oracle11.2.0.3)  to remote database (Oracle11.2.0.3) through Goldengate 11g.

1.2    Downloading Goldengate 11g

 

Download URL:

 http://edelivery.oracle.com

 http://www.oracle.com/technetwork/middleware/goldengate/downloads/index.html

Platform: RedHat Enterprise Linux 6.4 x86-64

Choose: Oracle GoldenGate V11.2.1.0.3 for Oracle 11g on Linux x86-64

1.3    System requirements and preinstallation instructions

Item

Source System

Target System

Platform

RHEL6.4

RHEL6.4

Hostname

rhel101.oracle.com

rhel102.oracle.com

Database

Oracle 11.2.0.3

Oracle 11.2.0.3

Character Set

AL32UTF8

AL32UTF8

ORACLE_SID

PROD

EMREP

Listener Name/Port

LISTENER/1521

LISTENER/1521

Goldengate DB Account

ogg

ogg

 

1.4    Installing Oracle GoldenGate 11g on Linux

1.4.1  Setting ORACLE_HOME and ORACLE_SID

1.4.1.1 Source System

 

[oracle@rhel101 ~]$ cat .bash_profile

export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1

export ORACLE_SID=PROD

export PATH=$ORACLE_HOME/bin:$PATH

export NLS_LANG=AMERICAN_AMERICA.AL32UTF8

 

alias sqlplus='/usr/local/bin/rlwrap sqlplus'

alias rman='/usr/local/bin/rlwrap rman'

 

 

 

 

1.4.1.2 Target System

 

[oracle@rhel102 ~]$ cat .bash_profile

export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1

export ORACLE_SID=EMREP

export PATH=$ORACLE_HOME/bin:$PATH

export NLS_LANG=AMERICAN_AMERICA.AL32UTF8

 

alias sqlplus='/usr/local/bin/rlwrap sqlplus'

alias rman='/usr/local/bin/rlwrap rman'

 

 

 

 

 

1.4.2  Setting library paths for dynamic builds

 

oracle用户的环境变量中增加以下一行:

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/network/lib

 

[oracle@rhel101 ~]$ vi .bash_profile

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/network/lib

 

[oracle@rhel101 ~]$ source .bash_profile

[oracle@rhel101 ~]$ echo $LD_LIBRARY_PATH

 

 

[oracle@rhel102 ~]$ vi .bash_profile

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/network/lib

 

[oracle@rhel102 ~]$ source .bash_profile

[oracle@rhel102 ~]$ echo $LD_LIBRARY_PATH

 

1.4.3  Create install directory

For source system(PROD):

[oracle@rhel101 ~]$ mkdir -p /u01/app/oracle/ggs/11.2.1

[oracle@rhel101 ~]$ ls -ld /u01/app/oracle/ggs/11.2.1

 

[oracle@rhel101 ~]$ vi .bash_profile

export PATH=/u01/app/oracle/ggs/11.2.1:$:PATH

[oracle@rhel101 ~]$ source .bash_profile

 

 

For target system(EMREP):

 

[oracle@rhel102 ~]$ mkdir -p /u01/app/oracle/ggs/11.2.1

[oracle@rhel102 ~]$ ls -ld /u01/app/ oracle/ggs/11.2.1

 

[oracle@rhel102 ~]$ vi .bash_profile

export PATH=/u01/app/oracle/ggs/11.2.1:$PATH

[oracle@rhel102 ~]$ source .bash_profile

1.4.4  Upload and unzip file on both system

 

[oracle@rhel101 ~]$ cd /u01/app/oracle/ggs/11.2.1/

[oracle@rhel101 11.2.1]$ rz

 

[oracle@rhel101 11.2.1]$ ls -lh

[oracle@rhel101 11.2.1]$ tar -xf fbo_ggs_Linux_x64_ora11g_64bit.tar

[oracle@rhel101 11.2.1]$ ls -lh

 

 

[oracle@rhel101 11.2.1]$ which ggsci

 

[oracle@rhel101 11.2.1]$ vi /home/oracle/.bash_profile

alias ggsci='/usr/local/bin/rlwrap ggsci'

[oracle@rhel101 11.2.1]$ source /home/oracle/.bash_profile

 

 

 

 

 

 

[oracle@rhel102 11.2.1]$ which ggsci

 

[oracle@rhel102 11.2.1]$ vi /home/oracle/.bash_profile

alias ggsci='/usr/local/bin/rlwrap ggsci'

[oracle@rhel102 11.2.1]$ source /home/oracle/.bash_profile

 

 

 

1.4.5  Create sub working directories for Goldengate

For both Source system and Target system:

 

[oracle@rhel101 ~]$ cd /u01/app/oracle/ggs/11.2.1/

[oracle@rhel101 11.2.1]$ ggsci

Oracle GoldenGate Command Interpreter for Oracle

Version 11.2.1.0.3 14400833 OGGCORE_11.2.1.0.3_PLATFORMS_120823.1258_FBO

Linux, x64, 64bit (optimized), Oracle 11g on Aug 23 2012 20:20:21

 

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

GGSCI (rhel101.oracle.com) 1> create subdirs

Creating subdirectories under current directory /u01/app/oracle/ggs/11.2.1

Parameter files                /u01/app/oracle/ggs/11.2.1/dirprm: already exists

Report files                   /u01/app/oracle/ggs/11.2.1/dirrpt: created

Checkpoint files               /u01/app/oracle/ggs/11.2.1/dirchk: created

Process status files           /u01/app/oracle/ggs/11.2.1/dirpcs: created

SQL script files               /u01/app/oracle/ggs/11.2.1/dirsql: created

Database definitions files     /u01/app/oracle/ggs/11.2.1/dirdef: created

Extract data files             /u01/app/oracle/ggs/11.2.1/dirdat: created

Temporary files                /u01/app/oracle/ggs/11.2.1/dirtmp: created

Stdout files                   /u01/app/oracle/ggs/11.2.1/dirout: created

 

[oracle@rhel102 ~]$ cd /u01/app/oracle/ggs/11.2.1/

[oracle@rhel102 11.2.1]$ ggsci

Oracle GoldenGate Command Interpreter for Oracle

Version 11.2.1.0.3 14400833 OGGCORE_11.2.1.0.3_PLATFORMS_120823.1258_FBO

Linux, x64, 64bit (optimized), Oracle 11g on Aug 23 2012 20:20:21

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

GGSCI (rhel102.oracle.com) 1> create subdirs

Creating subdirectories under current directory /u01/app/oracle/ggs/11.2.1

Parameter files                /u01/app/oracle/ggs/11.2.1/dirprm: already exists

Report files                   /u01/app/oracle/ggs/11.2.1/dirrpt: created

Checkpoint files               /u01/app/oracle/ggs/11.2.1/dirchk: created

Process status files           /u01/app/oracle/ggs/11.2.1/dirpcs: created

SQL script files               /u01/app/oracle/ggs/11.2.1/dirsql: created

Database definitions files     /u01/app/oracle/ggs/11.2.1/dirdef: created

Extract data files             /u01/app/oracle/ggs/11.2.1/dirdat: created

Temporary files                /u01/app/oracle/ggs/11.2.1/dirtmp: created

Stdout files                   /u01/app/oracle/ggs/11.2.1/dirout: created

 

Above directories are created for following purpose:

Name

Purpose

dirchk

Checkpoint files

dirdat

GoldenGate trails

dirdef

Data definition files

dirprm

Parameter files

dirpcs

Process status files

dirrpt

Report files

dirsql

SQL script files

dirtmp

Temporary files




吕星昊
2017.11.20


来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29475508/viewspace-2147504/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
恩墨学院 Oracle OCM 认证培训教学总监。拥有RHCE、OCP、OCM 认证证书。5年教育培训行业经验。Oracle WDP 注册OCM讲师,已培养Oracle OCP认证专家1000余人,培养Oracle OCM认证大师200余人。

注册时间:2014-02-08

  • 博文量
    128
  • 访问量
    2516156