【着急】OGG问题： 同样的错误，每天都会出现错误！

ShineCQY

刘老师    目标端ggserr.log中的warning 和error信息在附件中 errors.rar (761 Bytes, 下载次数: 1174)

2011-12-30 19:56 上传

点击文件名下载附件
ggserr.log

OGG版本 ：
        源端 oracle Goldengate command interpreter for oracle version 10.4.0.96 Build 001
                AIX 5L，ppc,64bit (optimized),oracle 9 on 0ct 21 2010 21:30:35
     目标端oracle Goldengate command interpreter for oracle version 10.4.0.96 Build 001
                AIX 5L，ppc,64bit (optimized),oracle 9 on 0ct 18 2010 09:43:30
数据库版本：
      源端：SQL>select * from v$version;
   BANNER
oracle9i Enterprise Edition Release 9.2.0.6-64bit Production
PL/SQL Release 9.2.0.6.0-Production
ORE     9.2.0.6.0         Production
TNS  for IBM/AIX RISC System/6000:Version 9.2.0.6.0-Production
NLSRTL Version 9.2.0.6.0 - Production
       目标端：SQL>select * from v$version;
   BANNER
oracle9i Enterprise Edition Release 9.2.0.8-64bit Production
PL/SQL Release 9.2.0.8.0-Production
ORE     9.2.0.8.0         Production
TNS  for IBM/AIX RISC System/6000:Version 9.2.0.8.0-Production
NLSRTL Version 9.2.0.8.0 - Production

主机信息
       源端： uname -a
     AIX DSY550 2 5  00C58A6F4C00
      目标端： uname -a
     AIX br-apms-db1  3  5 00C7C46C00

问题 ：
1、为什么向表中插入数据时就会报错（只是启用DML功能，没有改表结构）？
2、是不是OGG 10.4的BUG引起的？如果是，aix 5.2下能否安装最新的OGG11.1.1.2版本？

ShineCQY

2011-12-29 10:23:10  GGS WARNING     218  Oracle GoldenGate Delivery for Oracle, repsa.prm:  Aborted grouped transaction on 'PMS.PM_BDSB_YCSB', Database error 100 (retrieving bind info for query).
2011-12-29 10:23:10  GGS WARNING     218  Oracle GoldenGate Delivery for Oracle, repsa.prm:  Repositioning to rba 69293721 in seqno 16.
2011-12-29 10:23:10  GGS WARNING     218  Oracle GoldenGate Delivery for Oracle, repsa.prm:  SQL error 1403 mapping PMS.PM_BDSB_YCSB to PMS.PM_BDSB_YCSB.
2011-12-29 10:23:10  GGS WARNING     218  Oracle GoldenGate Delivery for Oracle, repsa.prm:  Repositioning to rba 69293721 in seqno 16.
2011-12-29 10:23:10  GGS ERROR       218  Oracle GoldenGate Delivery for Oracle, repsa.prm:  Error mapping from PMS.PM_BDSB_YCSB to PMS.PM_BDSB_YCSB.
2011-12-29 10:32:18  GGS WARNING     218  Oracle GoldenGate Delivery for Oracle, repsa.prm:  Aborted grouped transaction on 'PMS.PM_BDSB_YCSB', Database error 100 (retrieving bind info for query).
2011-12-29 10:32:18  GGS WARNING     218  Oracle GoldenGate Delivery for Oracle, repsa.prm:  Repositioning to rba 69293721 in seqno 16.
2011-12-29 10:32:18  GGS WARNING     218  Oracle GoldenGate Delivery for Oracle, repsa.prm:  SQL error 1403 mapping PMS.PM_BDSB_YCSB to PMS.PM_BDSB_YCSB.
2011-12-29 10:32:18  GGS WARNING     218  Oracle GoldenGate Delivery for Oracle, repsa.prm:  Repositioning to rba 69293721 in seqno 16.
2011-12-29 10:32:18  GGS ERROR       218  Oracle GoldenGate Delivery for Oracle, repsa.prm:  Error mapping from PMS.PM_BDSB_YCSB to PMS.PM_BDSB_YCSB.
2011-12-29 10:32:36  GGS WARNING     218  Oracle GoldenGate Delivery for Oracle, repsa.prm:  Aborted grouped transaction on 'PMS.PM_BDYX_BDQX', Database error 100 (retrieving bind info for query).
2011-12-29 10:32:36  GGS WARNING     218  Oracle GoldenGate Delivery for Oracle, repsa.prm:  Repositioning to rba 69295326 in seqno 16.
2011-12-29 10:32:37  GGS WARNING     218  Oracle GoldenGate Delivery for Oracle, repsa.prm:  SQL error 1403 mapping PMS.PM_BDYX_BDQX to PMS.PM_BDYX_BDQX.
2011-12-29 10:32:37  GGS WARNING     218  Oracle GoldenGate Delivery for Oracle, repsa.prm:  Repositioning to rba 69682774 in seqno 16.
2011-12-29 10:32:37  GGS ERROR       218  Oracle GoldenGate Delivery for Oracle, repsa.prm:  Error mapping from PMS.PM_BDYX_BDQX to PMS.PM_BDYX_BDQX.
2011-12-29 10:47:18  GGS WARNING     218  Oracle GoldenGate Delivery for Oracle, repsa.prm:  Aborted grouped transaction on 'PMS.PM_BDYX_JXSY', Database error 100 (retrieving bind info for query).
2011-12-29 10:47:18  GGS WARNING     218  Oracle GoldenGate Delivery for Oracle, repsa.prm:  Repositioning to rba 8727945 in seqno 17.
2011-12-29 10:47:18  GGS WARNING     218  Oracle GoldenGate Delivery for Oracle, repsa.prm:  SQL error 1403 mapping PMS.PM_BDYX_JXSY to PMS.PM_BDYX_JXSY.
2011-12-29 10:47:18  GGS WARNING     218  Oracle GoldenGate Delivery for Oracle, repsa.prm:  Repositioning to rba 8727945 in seqno 17.
2011-12-29 10:47:18  GGS ERROR       218  Oracle GoldenGate Delivery for Oracle, repsa.prm:  Error mapping from PMS.PM_BDYX_JXSY to PMS.PM_BDYX_JXSY.
2011-12-29 14:53:52  GGS WARNING     218  Oracle GoldenGate Delivery for Oracle, repsa.prm:  Aborted grouped transaction on 'PMS.PM_BDYX_QTGZ', Database error 100 (retrieving bind info for query).
2011-12-29 14:53:52  GGS WARNING     218  Oracle GoldenGate Delivery for Oracle, repsa.prm:  Repositioning to rba 12000601 in seqno 17.
2011-12-29 14:53:52  GGS WARNING     218  Oracle GoldenGate Delivery for Oracle, repsa.prm:  SQL error 1403 mapping PMS.PM_BDYX_QTGZ to PMS.PM_BDYX_QTGZ.
2011-12-29 14:53:52  GGS WARNING     218  Oracle GoldenGate Delivery for Oracle, repsa.prm:  Repositioning to rba 12000601 in seqno 17.
2011-12-29 14:53:52  GGS ERROR       218  Oracle GoldenGate Delivery for Oracle, repsa.prm:  Error mapping from PMS.PM_BDYX_QTGZ to PMS.PM_BDYX_QTGZ.
2011-12-30 10:29:49  GGS WARNING     218  Oracle GoldenGate Delivery for Oracle, repsa.prm:  Aborted grouped transaction on 'PMS.PM_BDYX_BDQX', Database error 100 (retrieving bind info for query).
2011-12-30 10:29:49  GGS WARNING     218  Oracle GoldenGate Delivery for Oracle, repsa.prm:  Repositioning to rba 12977986 in seqno 17.
2011-12-30 10:29:49  GGS WARNING     218  Oracle GoldenGate Delivery for Oracle, repsa.prm:  SQL error 1403 mapping PMS.PM_BDYX_BDQX to PMS.PM_BDYX_BDQX.
2011-12-30 10:29:49  GGS WARNING     218  Oracle GoldenGate Delivery for Oracle, repsa.prm:  Repositioning to rba 12977986 in seqno 17.
2011-12-30 10:29:49  GGS ERROR       218  Oracle GoldenGate Delivery for Oracle, repsa.prm:  Error mapping from PMS.PM_BDYX_BDQX to PMS.PM_BDYX_BDQX.
2011-12-30 10:33:20  GGS WARNING     218  Oracle GoldenGate Delivery for Oracle, repsa.prm:  Aborted grouped transaction on 'PMS.PM_BDYX_BDQX', Database error 100 (retrieving bind info for query).
2011-12-30 10:33:20  GGS WARNING     218  Oracle GoldenGate Delivery for Oracle, repsa.prm:  Repositioning to rba 12977986 in seqno 17.
2011-12-30 10:33:20  GGS WARNING     218  Oracle GoldenGate Delivery for Oracle, repsa.prm:  SQL error 1403 mapping PMS.PM_BDYX_BDQX to PMS.PM_BDYX_BDQX.
2011-12-30 10:33:20  GGS WARNING     218  Oracle GoldenGate Delivery for Oracle, repsa.prm:  Repositioning to rba 12977986 in seqno 17.
2011-12-30 10:33:20  GGS ERROR       218  Oracle GoldenGate Delivery for Oracle, repsa.prm:  Error mapping from PMS.PM_BDYX_BDQX to PMS.PM_BDYX_BDQX.
2011-12-30 10:33:26  GGS WARNING     218  Oracle GoldenGate Delivery for Oracle, repsa.prm:  Aborted grouped transaction on 'PMS.PM_BDYX_BDQX', Database error 100 (retrieving bind info for query).
2011-12-30 10:33:26  GGS WARNING     218  Oracle GoldenGate Delivery for Oracle, repsa.prm:  Repositioning to rba 12977986 in seqno 17.
2011-12-30 10:33:26  GGS WARNING     218  Oracle GoldenGate Delivery for Oracle, repsa.prm:  SQL error 1403 mapping PMS.PM_BDYX_BDQX to PMS.PM_BDYX_BDQX.
2011-12-30 10:33:26  GGS WARNING     218  Oracle GoldenGate Delivery for Oracle, repsa.prm:  Repositioning to rba 12977986 in seqno 17.
2011-12-30 10:33:26  GGS ERROR       218  Oracle GoldenGate Delivery for Oracle, repsa.prm:  Error mapping from PMS.PM_BDYX_BDQX to PMS.PM_BDYX_BDQX.
2011-12-30 10:33:43  GGS WARNING     218  Oracle GoldenGate Delivery for Oracle, repsa.prm:  Aborted grouped transaction on 'PMS.PM_BDYX_BDQX', Database error 100 (retrieving bind info for query).
2011-12-30 10:33:43  GGS WARNING     218  Oracle GoldenGate Delivery for Oracle, repsa.prm:  Repositioning to rba 12981808 in seqno 17.
2011-12-30 10:33:43  GGS WARNING     218  Oracle GoldenGate Delivery for Oracle, repsa.prm:  Repositioning to rba 12981808 in seqno 17.
2011-12-30 10:33:43  GGS ERROR       218  Oracle GoldenGate Delivery for Oracle, repsa.prm:  Error mapping from PMS.PM_BDYX_BDQX to PMS.PM_BDYX_BDQX.
2011-12-30 10:40:20  GGS WARNING     218  Oracle GoldenGate Delivery for Oracle, repsa.prm:  Aborted grouped transaction on 'PMS.PM_BDYX_BLQDZ', Database error 100 (retrieving bind info for query).
2011-12-30 10:40:20  GGS WARNING     218  Oracle GoldenGate Delivery for Oracle, repsa.prm:  Repositioning to rba 19384597 in seqno 17.
2011-12-30 10:40:20  GGS WARNING     218  Oracle GoldenGate Delivery for Oracle, repsa.prm:  SQL error 1403 mapping PMS.PM_BDYX_BLQDZ to PMS.PM_BDYX_BLQDZ.
2011-12-30 10:40:20  GGS WARNING     218  Oracle GoldenGate Delivery for Oracle, repsa.prm:  Repositioning to rba 19384597 in seqno 17.
2011-12-30 10:40:20  GGS ERROR       218  Oracle GoldenGate Delivery for Oracle, repsa.prm:  Error mapping from PMS.PM_BDYX_BLQDZ to PMS.PM_BDYX_BLQDZ.
2011-12-30 10:53:54  GGS WARNING     218  Oracle GoldenGate Delivery for Oracle, repsa.prm:  Aborted grouped transaction on 'PMS.PM_BDYX_JXSY', Database error 100 (retrieving bind info for query).
2011-12-30 10:53:54  GGS WARNING     218  Oracle GoldenGate Delivery for Oracle, repsa.prm:  Repositioning to rba 23294741 in seqno 17.
2011-12-30 10:53:54  GGS WARNING     218  Oracle GoldenGate Delivery for Oracle, repsa.prm:  SQL error 1403 mapping PMS.PM_BDYX_JXSY to PMS.PM_BDYX_JXSY.
2011-12-30 10:53:54  GGS WARNING     218  Oracle GoldenGate Delivery for Oracle, repsa.prm:  Repositioning to rba 23295334 in seqno 17.
2011-12-30 10:53:54  GGS ERROR       218  Oracle GoldenGate Delivery for Oracle, repsa.prm:  Error mapping from PMS.PM_BDYX_JXSY to PMS.PM_BDYX_JXSY.
2011-12-30 11:02:23  GGS WARNING     218  Oracle GoldenGate Delivery for Oracle, repsa.prm:  Aborted grouped transaction on 'PMS.PM_BDYX_JXSY', Database error 100 (retrieving bind info for query).
2011-12-30 11:02:23  GGS WARNING     218  Oracle GoldenGate Delivery for Oracle, repsa.prm:  Repositioning to rba 23295334 in seqno 17.
2011-12-30 11:02:23  GGS WARNING     218  Oracle GoldenGate Delivery for Oracle, repsa.prm:  SQL error 1403 mapping PMS.PM_BDYX_JXSY to PMS.PM_BDYX_JXSY.
2011-12-30 11:02:23  GGS WARNING     218  Oracle GoldenGate Delivery for Oracle, repsa.prm:  Repositioning to rba 23295334 in seqno 17.
2011-12-30 11:02:23  GGS ERROR       218  Oracle GoldenGate Delivery for Oracle, repsa.prm:  Error mapping from PMS.PM_BDYX_JXSY to PMS.PM_BDYX_JXSY.
2011-12-30 11:02:31  GGS WARNING     218  Oracle GoldenGate Delivery for Oracle, repsa.prm:  Aborted grouped transaction on 'PMS.PM_BDYX_JXSY', Database error 100 (retrieving bind info for query).
2011-12-30 11:02:31  GGS WARNING     218  Oracle GoldenGate Delivery for Oracle, repsa.prm:  Repositioning to rba 23295334 in seqno 17.
2011-12-30 11:02:31  GGS WARNING     218  Oracle GoldenGate Delivery for Oracle, repsa.prm:  SQL error 1403 mapping PMS.PM_BDYX_JXSY to PMS.PM_BDYX_JXSY.
2011-12-30 11:02:31  GGS WARNING     218  Oracle GoldenGate Delivery for Oracle, repsa.prm:  Repositioning to rba 23295334 in seqno 17.
2011-12-30 11:02:31  GGS ERROR       218  Oracle GoldenGate Delivery for Oracle, repsa.prm:  Error mapping from PMS.PM_BDYX_JXSY to PMS.PM_BDYX_JXSY.

Maclean Liu(刘相兵

SQL error 1403 mapping PMS.PM_BDSB_YCSB to PMS.PM_BDSB_YCSB.

SQL ERROR 1403属数据错误，指记录无法投递到目标数据库，需通过查看错误信息及discarded文件，到两端库寻找相应记录，并结合logdump工具分析队列中的实际数据，分析出现该错误的原因，进而解决该问题。

造成该错误的可能原因：

1        两端表结构不一致
2        附加日志错误
3        初始化方法错误导致不一致
4        目标端级联删除、trigger没有被禁止
5        该表存在不写日志的DML操作

Maclean Liu(刘相兵

问题2:

2、是不是OGG 10.4的BUG引起的？<br><br>如果是，aix 5.2下能否安装最新的OGG11.1.1.2版本？<br><br>&nbsp;是否是BUG 请去提交SR 要求Oracle Support确认<br><br><br>&nbsp;aix 5.2下能否安装最新的OGG11.1.1.2版本？


目前11.1.1 的兼容列表显示 是不支持AIX 5.2的<br><br><br>
<table frame="VOID" rules="NONE" border="0" cellspacing="0" cols="7">
        <colgroup><col width="95"><col width="107"><col width="70"><col width="195"><col width="67"><col width="165"><col width="385"></colgroup>
        <tbody>
                <tr>
                        <td style="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 3px solid #000000; border-right: 1px solid #000000" align="LEFT" height="142" valign="TOP" width="95"><font face="Arial" size="1">OGG Core</font></td>
                        <td style="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" align="LEFT" valign="TOP" width="107"><font face="Arial" size="1">11gR1 (11.1.1.0.0)</font></td>
                        <td style="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" align="LEFT" valign="TOP" width="70"><font face="Arial" size="1">POWER</font></td>
                        <td style="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" align="LEFT" valign="TOP" width="195"><font face="Arial" size="1">AIX 5.3 (TL8+)</font></td>
                        <td style="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" align="LEFT" valign="TOP" width="67"><font face="Arial" size="1">64</font></td>
                        <td style="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" align="LEFT" valign="TOP" width="165"><font face="Arial" size="1">Oracle 9.2.0.7+<br>Oracle 10.2.0.4+<br>Oracle 11.1.0.7+<br>Oracle 11.2.0.1+<br>IBM DB2 9.1   <br>IBM DB2 9.5  <br>IBM DB2 9.7<br>Sybase 12.5.4<br>Sybase 15.0<br></font></td>
                        <td style="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 3px solid #000000" align="LEFT" valign="TOP" width="385"><font face="Arial" size="1">n/a</font></td>
                </tr>
                <tr>
                        <td style="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 3px solid #000000; border-right: 1px solid #000000" align="LEFT" height="35" valign="TOP"><font face="Arial" size="1">OGG Core</font></td>
                        <td style="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" align="LEFT" valign="TOP"><font face="Arial" size="1">11gR1 (11.1.1.1.0)</font></td>
                        <td style="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" align="LEFT" valign="TOP"><font face="Arial" size="1">POWER</font></td>
                        <td style="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" align="LEFT" valign="TOP"><font face="Arial" size="1">AIX 5.3 (TL8+)</font></td>
                        <td style="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" align="LEFT" valign="TOP"><font face="Arial" size="1">64</font></td>
                        <td style="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" align="LEFT" valign="TOP"><font face="Arial" size="1">Oracle 10.2.0.4+<br>Oracle 11.1.0.7+<br></font></td>
                        <td style="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 3px solid #000000" align="LEFT" valign="TOP"><font face="Arial" size="1">n/a</font></td>
                </tr>
                <tr>
                        <td style="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 3px solid #000000; border-right: 1px solid #000000" align="LEFT" height="139" valign="TOP"><font face="Arial" size="1">OGG Core</font></td>
                        <td style="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" align="LEFT" valign="TOP"><font face="Arial" size="1">11gR1 (11.1.1.0.0)</font></td>
                        <td style="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" align="LEFT" valign="TOP"><font face="Arial" size="1">POWER</font></td>
                        <td style="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" align="LEFT" valign="TOP"><font face="Arial" size="1">AIX 6.1 (TL2+)</font></td>
                        <td style="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" align="LEFT" valign="TOP"><font face="Arial" size="1">64</font></td>
                        <td style="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" align="LEFT" valign="TOP"><font face="Arial" size="1">Oracle 9.2.0.7+<br>Oracle 10.2.0.4+<br>Oracle 11.1.0.7+<br>Oracle 11.2.0.1+<br>IBM DB2 9.1   <br>IBM DB2 9.5  <br>IBM DB2 9.7<br>Sybase 12.5.4<br>Sybase 15.0<br></font></td>
                        <td style="border-top: 1px solid #000000; border-bottom: 1px solid #000000; border-left: 1px solid #000000; border-right: 3px solid #000000" align="LEFT" valign="TOP"><font face="Arial" size="1">n/a</font></td>
                </tr>
                <tr>
                        <td style="border-bottom: 3px solid #000000; border-left: 3px solid #000000; border-right: 1px solid #000000" align="LEFT" height="50" valign="TOP"><font face="Arial" size="1">OGG Core</font></td>
                        <td style="border-top: 1px solid #000000; border-bottom: 3px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" align="LEFT" valign="TOP"><font face="Arial" size="1">11gR1 (11.1.1.1.0)</font></td>
                        <td style="border-bottom: 3px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" align="LEFT" valign="TOP"><font face="Arial" size="1">POWER</font></td>
                        <td style="border-bottom: 3px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" align="LEFT" valign="TOP"><font face="Arial" size="1">AIX 6.1 (TL2+)</font></td>
                        <td style="border-bottom: 3px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" align="LEFT" valign="TOP"><font face="Arial" size="1">64</font></td>
                        <td style="border-bottom: 3px solid #000000; border-left: 1px solid #000000; border-right: 1px solid #000000" align="LEFT" valign="TOP"><font face="Arial" size="1">Oracle 10.2.0.4+<br>Oracle 11.1.0.7+<br>Oracle 11.2.0.1+<br></font></td>
                        <td style="border-bottom: 3px solid #000000; border-left: 1px solid #000000; border-right: 3px solid #000000" align="LEFT" valign="TOP"><font face="Arial" size="1">n/a</font></td>
                </tr>
        </tbody>
</table>
<br>

[ 本帖最后由 maclean 于 2011-12-30 20:29 编辑 ]