ogg实施（一），OGG安装、初始化

最新推荐文章于 2026-01-07 19:00:00 发布

原创

最新推荐文章于 2026-01-07 19:00:00 发布 · 1.4k 阅读

本文档详细记录了在两个主机ser1和ser2上安装Oracle GoldenGate 11.2.1.0.1的过程，包括创建OGG用户、数据库授权、ogg目录结构设置、数据库补充日志配置、extract和replicat进程的创建与启动，以及数据的初始化同步。

环境：

源数据库：实例名：source

DB版本：11.2.0.4.0

OGG版本：Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230_FBO

字符集：ZHS16GBK

主机名：ser1

目标数据库：实例名：target

DB版本：11.2.0.4.0

OGG版本：Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230_FBO

字符集：ZHS16GBK

主机名：ser2

oracle环境变量中添加：export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib

ogg安装：

ser1、ser2全部执行

[oracle@ser1 u01]$ mkdir ogg
[oracle@ser1 u01]$
[oracle@ser1 u01]$ cd ogg
[oracle@ser1 ogg]$
[oracle@ser1 ogg]$ cp /tmp/ogg112101_fbo_ggs_Linux_x64_ora11g_64bit.zip .
[oracle@ser1 ogg]$
[oracle@ser1 ogg]$ unzip ogg112101_fbo_ggs_Linux_x64_ora11g_64bit.zip
Archive: ogg112101_fbo_ggs_Linux_x64_ora11g_64bit.zip
inflating: fbo_ggs_Linux_x64_ora11g_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
[oracle@ser1 ogg]$
[oracle@ser1 ogg]$ tar xvf fbo_ggs_Linux_x64_ora11g_64bit.tar
UserExitExamples/
UserExitExamples/ExitDemo_more_recs/

…………

ulg.sql
usrdecs.h
zlib.txt
[oracle@ser1 ogg]$

[oracle@ser1 ogg]$ ./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 11g on Apr 23 2012 08:32:14

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

GGSCI (ser1) 1> create subdirs

Creating subdirectories under current directory /u01/ogg

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