OGG部署过程错误总结

以你之姓@ 2022-02-02 00:51 385阅读 0赞

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

## 错误1： ##

源端安装完ogg后，执行./ggsci 进不去，报错 ：[无法打开libjvm.so][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][libjvm.so 1] => not found [没找到libjvm.so][libjvm.so 2]  
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]  
将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）\*\*  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjE5MzQ4OQ_size_16_color_FFFFFF_t_70]  
***此处 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
    ~

[https_www.cnblogs.com_houzhiqing_p_5289383.html]: https://www.cnblogs.com/houzhiqing/p/5289383.html
[libjvm.so]: http://xn--libjvm-oi2ls3tzzi4ws.so
[libjvm.so 1]: http://libjvm.so
[libjvm.so 2]: http://xn--libjvm-or3j909hjct.so
[jdk_libjvm.so]: http://xn--jdklibjvm-2b6n60eynw06cvhksqqnjppzxx7fhf3382axbgvl8hri8c.so
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjE5MzQ4OQ_size_16_color_FFFFFF_t_70]: /images/20220202/b8d09a6851064cb0a29a4702d5bf4df6.png