程序员经验分享-hwhale

OGG部署过程错误总结

2023-05-16

安装过程可参考：https://www.cnblogs.com/houzhiqing/p/5289383.html

错误1：

源端安装完ogg后，执行./ggsci 进不去，报错 ：无法打开libjvm.so ，找不到路径，或者文件

./ggsci: error while loading shared libraries: libjvm.so: cannot open shared object file: No such file or directory

使用 ldd ggsci

    [oracle@oracle ogg]$ ldd ggsci
            linux-vdso.so.1 =>  (0x00007ffd7b1ed000)
            librt.so.1 => /lib64/librt.so.1 (0x0000003bd1c00000)
            libdl.so.2 => /lib64/libdl.so.2 (0x0000003bd1000000)
            libgglog.so => /home/oracle/ogg/./libgglog.so (0x00007fe26f169000)
            libggutil.so => /home/oracle/ogg/./libggutil.so (0x00007fe26ef47000)
            libggrepo.so => /home/oracle/ogg/./libggrepo.so (0x00007fe26ec59000)
            libdb-6.1.so => /home/oracle/ogg/./libdb-6.1.so (0x00007fe26e843000)
            liblmdb.so => /home/oracle/ogg/./liblmdb.so (0x00007fe26e62e000)
            libggperf.so => /home/oracle/ogg/./libggperf.so (0x00007fe26e3f2000)
            libggparam.so => /home/oracle/ogg/./libggparam.so (0x00007fe26cbdf000)
            libicui18n.so.56 => /home/oracle/ogg/./libicui18n.so.56 (0x00007fe26c719000)
            libicuuc.so.56 => /home/oracle/ogg/./libicuuc.so.56 (0x00007fe26c31d000)
            libicudata.so.56 => /home/oracle/ogg/./libicudata.so.56 (0x00007fe26a4ba000)
            libpthread.so.0 => /lib64/libpthread.so.0 (0x0000003bd1800000)
            libxerces-c-3.1.so => /home/oracle/ogg/./libxerces-c-3.1.so (0x00007fe269e2a000)
            libantlr3c.so => /home/oracle/ogg/./libantlr3c.so (0x00007fe269c11000)
            libjvm.so => not found
            libggnnzitp.so => /home/oracle/ogg/./libggnnzitp.so (0x00007fe26919c000)
            libm.so.6 => /lib64/libm.so.6 (0x0000003bd2000000)
            libc.so.6 => /lib64/libc.so.6 (0x0000003bd1400000)
            /lib64/ld-linux-x86-64.so.2 (0x0000003bd0c00000)
            libnsl.so.1 => /lib64/libnsl.so.1 (0x0000003bdf400000)
            libstdc++.so.6 => /usr/lib64/libstdc++.so.6 (0x0000003bdc800000)
            libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x0000003bdc400000)

由上 libjvm.so => not found 没找到libjvm.so
vi .bash_profile 查看配置的LD_LIBRARY_PATH环境变量

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

去$ORACLE_HOME/lib并未找到libjvm.so，说明确实缺少该文件
最后得知在jdk的安装文件从下面有libjvm.so
将jdk路径下的libjvm.so配置到LD_LIBRARY_PATH里面

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib:/opt/jdk1.8.0_161/jre/lib/amd64/server

现在 .bash_profile 格式为

[oracle@oracle ~]$ vi .bash_profile 
# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
        . ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/bin

export PATH
umask 022
export ORACLE_BASE=/home/oracle/app
export ORACLE_HOME=$ORACLE_BASE/oracle/product/11.2.0/dbhome_1
export ORACLE_SID=orcl
export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib:/opt/jdk1.8.0_161/jre/lib/amd64/server

export GGATE_HOME=/home/oracle/og

生效

 source .bash_profile

执行./ggsci

[oracle@oracle ogg]$ ./ggsci 

Oracle GoldenGate for Big Data
Version 12.3.2.1.0 (Build 018)

Oracle GoldenGate Command Interpreter
Version 12.3.0.1.2 OGGCORE_OGGADP.12.3.0.1.2_PLATFORMS_180430.2321
Linux, x64, 64bit (optimized), Generic on May  1 2018 19:58:51
Operating system character set identified as UTF-8.

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



GGSCI (oracle) 1>

ok,解决问题！

错误2：

创建投递进程pump的时候，先编辑投递进程**（实际我用投递进程的命名是pushxh3）**
在这里插入图片描述
此处 rmttrail 所绑定的为目标端 trail 文件，这里的路径是目标端 OGG 对应的 dirdat 路径(如果目标端没有此目录，使用 create subdirs 命令可创建相关目录)
添加投递进程pushxh3到管理进程中，将本地的./dirdat/tc文件传送到目标端

    GGSCI> add extract pushxh3, EXTTRAILSOURCE ./dirdat/tc
   将目标端的ogg管理进程，起起来之后，启动源端的pump进程，发现报错

2019-05-11 18:08:38  ERROR   OGG-01044  The trail '/home/newdisk/ogg/dirdat/tc' is not assigned to extract 'PUSHXH3'. Assign the trail to the extract with the command "ADD
 EXTTRAIL/RMTTRAIL /home/newdisk/ogg/dirdat/tc, EXTRACT PUSHXH3".

2019-05-11 18:08:38  ERROR   OGG-01668  PROCESS ABENDING.

错误原因:
没有将trail轨迹文件tc ,添加到投递进程中pushxh3中
按照指示执行add exttrail /home/newdisk/ogg/dirdat/tc,extract pushxh3

GGSCI (oracle) 14> add  exttrail /home/newdisk/ogg/dirdat/tc,extract pushxh3
EXTTRAIL added.

重新启动，观察进程：

GGSCI (oracle) 15> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                           
EXTRACT     RUNNING     CQ1         00:00:00      00:00:10    
EXTRACT     ABENDED     PUSHXH3     00:00:00      00:42:03    
EXTRACT     STOPPED     PUXH2   00:00:00      11:35:23    


GGSCI (oracle) 16> start pushxh3

Sending START request to MANAGER ...
EXTRACT PUSHXH3 starting


GGSCI (oracle) 17> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                           
EXTRACT     RUNNING     CQ1         00:00:00      00:00:05    
EXTRACT     RUNNING     PUSHXH3     00:00:00      00:42:09    
EXTRACT     STOPPED     PUXH2   00:00:00      11:35:28

错误总结： 新增投递进程之后，需要操作两步：
1、需要将投递进程添加到管理进程中，
执行add extract pushxh3, EXTTRAILSOURCE ./dirdat/tc
2、需要将源端生成的trail轨迹文件tc,添加到投递进程中pushxh3中，
执行 add exttrail /home/newdisk/ogg/dirdat/tc,extract pushxh3

错误3:

在解决上面的问题之后，能成功启动pump进程，但是过一段时间会自动断掉，查看报错日志：

2019-05-11T18:18:32.123-0700  WARNING OGG-01221  Oracle GoldenGate Capture for Oracle, pushxh3.prm:  Connect failed to 192.168.197.134:7819, error 111:Connection refused.
2019-05-11T18:18:33.076-0700  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): info all.
2019-05-11T18:18:42.125-0700  WARNING OGG-01221  Oracle GoldenGate Capture for Oracle, pushxh3.prm:  Connect failed to 192.168.197.134:7819, error 111:Connection refused.
2019-05-11T18:18:52.134-0700  WARNING OGG-01221  Oracle GoldenGate Capture for Oracle, pushxh3.prm:  Connect failed to 192.168.197.134:7819, error 111:Connection refused.
2019-05-11T18:19:02.136-0700  WARNING OGG-01221  Oracle GoldenGate Capture for Oracle, pushxh3.prm:  Connect failed to 192.168.197.134:7819, error 111:Connection refused.
2019-05-11T18:19:09.963-0700  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): info all.
2019-05-11T18:19:12.145-0700  WARNING OGG-01221  Oracle GoldenGate Capture for Oracle, pushxh3.prm:  Connect failed to 192.168.197.134:7819, error 111:Connection refused.
2019-05-11T18:19:12.492-0700  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): info all.
2019-05-11T18:19:14.578-0700  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): info all.
2019-05-11T18:19:22.146-0700  WARNING OGG-01221  Oracle GoldenGate Capture for Oracle, pushxh3.prm:  Connect failed to 192.168.197.134:7819, error 111:Connection refused.
2019-05-11T18:19:26.677-0700  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): stop pushxh3.
2019-05-11T18:19:32.148-0700  WARNING OGG-01221  Oracle GoldenGate Capture for Oracle, pushxh3.prm:  Connect failed to 192.168.197.134:7819, error 111:Connection refused.
2019-05-11T18:19:42.150-0700  WARNING OGG-01221  Oracle GoldenGate Capture for Oracle, pushxh3.prm:  Connect failed to 192.168.197.134:7819, error 111:Connection refused.
2019-05-11T18:19:52.154-0700  WARNING OGG-01221  Oracle GoldenGate Capture for Oracle, pushxh3.prm:  Connect failed to 192.168.197.134:7819, error 111:Connection refused.
2019-05-11T18:20:02.168-0700  WARNING OGG-01221  Oracle GoldenGate Capture for Oracle, pushxh3.prm:  Connect failed to 192.168.197.134:7819, error 111:Connection refused.
2019-05-11T18:20:02.673-0700  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): info all.
2019-05-11T18:20:05.383-0700  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): info all.
2019-05-11T18:20:07.325-0700  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): info all.
2019-05-11T18:20:12.169-0700  WARNING OGG-01221  Oracle GoldenGate Capture for Oracle, pushxh3.prm:  Connect failed to 192.168.197.134:7819, error 111:Connection refused.
2019-05-11T18:20:22.175-0700  ERROR   OGG-01224  Oracle GoldenGate Capture for Oracle, pushxh3.prm:  Connect failed to 192.168.197.134:7819, error 111:Connection refused - retries exceeded.
2019-05-11T18:20:22.175-0700  ERROR   OGG-01668  Oracle GoldenGate Capture for Oracle, pushxh3.prm:  PROCESS ABENDING.
2019-05-11T18:20:22.177-0700  ERROR   OGG-15163  Oracle GoldenGate Command Interpreter for Oracle:  There was a problem sending a message to EXTRACT PUSHXH3 (Connection reset by peer).

错误显示：连接目标端的192。168.197.134 7819 拒绝连接，网上说的是，源端的mgr进程、pump进程，和目标端的mgr进程设置的端口号不同，实际检查我的是一样的，都是7809
思考：我设置的端口是7809 连接的时候为什么会是7819呢，并未设置过7819端口。
但是在设置pump参数文件的时候，加了一个dynamicresolution 动态解析
但是在源端和目标端的管理进程中，并未添加dynamicresolution
解决办法：将两端的mgr进程参数文件，都添加上解析列表dynamicportlist 7810-7819
重启两端的管理进程，和源端的pump进程，观察OK！

总结：（按照格式来配置，不要配置错误）

源端的管理进程配置文件格式：

GGSCI (oracle) 55> edit params mgr
PORT 7809
dynamicportlist 7810-7819
purgeoldextracts ./dirdat/*,usecheckpoints, minkeepdays 7

源端的pump进程格式：

GGSCI (oracle) 66> edit params pushxh3
extract pushxh3
setenv ( NLS_LANG = AMERICAN_AMERICA.ZHS16GBK )
passthru
dynamicresolution
userid ggs,password ggs
rmthost 192.168.197.134 mgrport 7809
rmttrail /home/newdisk/ogg/dirdat/tc
table ggs.source_test1;

目标端的管理进程格式：（同源端）

GGSCI (oracle) 8> edit params mgr
port 7809
dynamicportlist 7810-7819
PURGEOLDEXTRACTS ./dirdat/*,usecheckpoints, minkeepdays 3
~
本文内容由网友自发贡献，版权归原作者所有，本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容，请联系:hwhale#tublm.com(使用前将#替换为@)

OGG

部署过程错误总结

OGG部署过程错误总结 的相关文章

  • ajax 神,ajax

    ajax一个前后台配合的技术 xff0c 它可以让javascript发送http请求 xff0c 与后台通信 xff0c 获取数据和信息 ajax技术的原理是实例化xmlhttp对象 xff0c 使用此对象与后台通信 jquery将它封装

随机推荐

热门标签