没有合适的资源?快使用搜索试试~ 我知道了~
资源推荐
资源详情
资源评论
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![rar](https://img-home.csdnimg.cn/images/20210720083606.png)
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![application/pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![](https://csdnimg.cn/release/download_crawler_static/21004635/bg1.jpg)
Oracle OGG 同步搭建
1. 背景
OGG 的安装和部署如下
实验环境:
操作系统:
操作系统:Redhat 5.8 x86-64
数据库版本:Oracle 12.1.0.2.0
Golden Gate : Version 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401_FBO
Linux, x64, 64bit (optimized), Oracle 12c on Dec 12 2015 02:56:48
源端: hostname:nxmicdb IP:172.18.0.74 instance_name :WXMESBD
目标端:hostname:micdbbak IP:172.18.0.65 instance_name :WXMESBD2
一、安装
1.1 将软件包下载到相关路径之下,更改相应权限,然后创建 OGG 的安装路径
[oracle@nxmicdb ~]$ ls ~/ogg/fbo_ggs_Linux_x64_shiphome.zip
/home/oracle/ogg/fbo_ggs_Linux_x64_shiphome.zip
[oracle@nxmicdb.tp-link.net ~]$ mkdir -p /u1/app/oracle/ogg
1.2 设置环境变量
[oracle@nxmicdb.tp-link.net ~]$ more .bash_profile
ORACLE_SID=WXMESBD
export ORACLE_SID
ORACLE_BASE=/u1/app/oracle
export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/12.1.0/db1
export ORACLE_HOME
export
PATH=$PATH:$HOME/bin:$ORACLE_BASE/ogg:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:/
usr/bin:/bin:/usr/bin/X11:/usr/local/bin:.
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/ogg:/lib:/usr/lib
export OGG=/u1/app/oracle/ogg
[oracle@nxmicdb.tp-link.net ~]$source .bash_profile
1.3 解压安装
[oracle@nxmicdb ~] cd ogg
[oracle@nxmicdb ogg]$ unzip fbo_ggs_Linux_x64_ora10g_64bit.zip
[oracle@nxmicdb ogg] fbo_ggs_Linux_x64_shiphome/Disk1/runInstaller
![](https://csdnimg.cn/release/download_crawler_static/21004635/bg2.jpg)
Software Location 默认设置的是 ORACLE_HOME,这里变更为已新增的路径
![](https://csdnimg.cn/release/download_crawler_static/21004635/bg3.jpg)
1.5 使用 ggsci 工具,创建必要的目录
[oracle@nxmicdb ogg]$ ./ggsci
![](https://csdnimg.cn/release/download_crawler_static/21004635/bg4.jpg)
Oracle GoldenGate Command Interpreter for Oracle
Version 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401_FBO
Linux, x64, 64bit (optimized), Oracle 12c on Dec 12 2015 02:56:48
Operating system character set identified as UTF-8.
Copyright (C) 1995, 2015, Oracle and/or its affiliates. All rights reserved.
GGSCI (nxmicdb.tp-link.net) 1> create subdirs
Creating subdirectories under current directory /u1/app/oracle/ogg
Parameter files /u1/app/oracle/ogg/dirprm: already exists
Report files /u1/app/oracle/ogg/dirrpt: already exists
Checkpoint files /u1/app/oracle/ogg/dirchk: already exists
Process status files /u1/app/oracle/ogg/dirpcs: already exists
SQL script files /u1/app/oracle/ogg/dirsql: already exists
Database definitions files /u1/app/oracle/ogg/dirdef: already exists
Extract data files /u1/app/oracle/ogg/dirdat: already exists
Temporary files /u1/app/oracle/ogg/dirtmp: already exists
Credential store files /u1/app/oracle/ogg/dircrd: already exists
Masterkey wallet files /u1/app/oracle/ogg/dirwlt: already exists
Dump files /u1/app/oracle/ogg/dirdmp: already exists
GGSCI (nxmicdb.tp-link.net) 2>
在运行 ggsci 的时候,出现 Cannot load ICU resource bundle ‘ggMessage’, error
code 2 – No such file or directory 需要在 ggs 的 HOME 目录下执行 ggsci 才 OK,在其他
位置执行会报错,找不到文件或是目录
1.6 配置 GoldenGate 主进程参数
GGSCI (nxmicdb.tp-link.net) 2> edit params mgr
添加如下内容:
port 7809 —GoldenGate 主进程端口号
然后可以启动 GoldenGate 主控制进程
GGSCI (nxmicdb.tp-link.net) 3> start mgr
MGR is already running.
GGSCI (nxmicdb.tp-link.net) 4> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
剩余23页未读,继续阅读
资源评论
![avatar-default](https://csdnimg.cn/release/downloadcmsfe/public/img/lazyLogo2.1882d7f4.png)
![avatar](https://profile-avatar.csdnimg.cn/default.jpg!1)
qtyj102
- 粉丝: 0
- 资源: 1
上传资源 快速赚钱
我的内容管理 展开
我的资源 快来上传第一个资源
我的收益
登录查看自己的收益我的积分 登录查看自己的积分
我的C币 登录后查看C币余额
我的收藏
我的下载
下载帮助
![voice](https://csdnimg.cn/release/downloadcmsfe/public/img/voice.245cc511.png)
![center-task](https://csdnimg.cn/release/downloadcmsfe/public/img/center-task.c2eda91a.png)
最新资源
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
![feedback](https://img-home.csdnimg.cn/images/20220527035711.png)
![feedback](https://img-home.csdnimg.cn/images/20220527035711.png)
![feedback-tip](https://img-home.csdnimg.cn/images/20220527035111.png)
安全验证
文档复制为VIP权益,开通VIP直接复制
![dialog-icon](https://csdnimg.cn/release/downloadcmsfe/public/img/green-success.6a4acb44.png)