wengtf 发表于 2012-8-21 12:54:36

WARNING OGG-00869 OCI Error ORA-14400

环境：
oracle: 10.2.0.2
ogg: 11.1.1.1.2
hu-ux:  11.31

ggserr.log 报错如下：2012-08-18 15:07:29  WARNING OGG-00869  Oracle GoldenGate Delivery for Oracle, repoa.prm:  No unique key is defined for table /BIC/FZPMLPC03. All viable col
umns will be used to represent the key, but may not guarantee uniqueness.  KEYCOLS may be used to define the key.
2012-08-18 15:07:30  WARNING OGG-00869  Oracle GoldenGate Delivery for Oracle, repoa.prm:  OCI Error ORA-14400: inserted partition key does not map to any p
artition (status = 14400), SQL <INSERT INTO "SAPSR3"."/BIC/FZPMLPC03" ("KEY_ZPMLPC03P","KEY_ZPMLPC03T","KEY_ZPMLPC03U","KEY_ZPMLPC031","/BIC/ZPMGZPTJ") VALU
ES (:a0,:a1,:a2,:a3,:a4)>.
2012-08-18 15:07:30  WARNING OGG-01004  Oracle GoldenGate Delivery for Oracle, repoa.prm:  Aborted grouped transaction on 'SAPSR3./BIC/FZPMLPC03', Database
error 14400 (OCI Error ORA-14400: inserted partition key does not map to any partition (status = 14400), SQL <INSERT INTO "SAPSR3"."/BIC/FZPMLPC03" ("KEY_ZP
MLPC03P","KEY_ZPMLPC03T","KEY_ZPMLPC03U","KEY_ZPMLPC031","/BIC/ZPMGZPTJ") VALUES (:a0,:a1,:a2,:a3,:a4)>).
2012-08-18 15:07:30  WARNING OGG-01003  Oracle GoldenGate Delivery for Oracle, repoa.prm:  Repositioning to rba 185661450 in seqno 11.
2012-08-18 15:07:30  WARNING OGG-01154  Oracle GoldenGate Delivery for Oracle, repoa.prm:  SQL error 14400 mapping SAPSR3./BIC/FZPMLPC03 to SAPSR3./BIC/FZPM
LPC03 OCI Error ORA-14400: inserted partition key does not map to any partition (status = 14400), SQL <INSERT INTO "SAPSR3"."/BIC/FZPMLPC03" ("KEY_ZPMLPC03P
","KEY_ZPMLPC03T","KEY_ZPMLPC03U","KEY_ZPMLPC031","/BIC/ZPMGZPTJ") VALUES (:a0,:a1,:a2,:a3,:a4)>.
2012-08-18 15:07:30  WARNING OGG-01003  Oracle GoldenGate Delivery for Oracle, repoa.prm:  Repositioning to rba 186880153 in seqno 11.
2012-08-18 15:07:30  ERROR   OGG-01296  Oracle GoldenGate Delivery for Oracle, repoa.prm:  Error mapping from SAPSR3./BIC/FZPMLPC03 to SAPSR3./BIC/FZPMLPC03
.
2012-08-18 15:07:30  ERROR   OGG-01668  Oracle GoldenGate Delivery for Oracle, repoa.prm:  PROCESS ABENDING.
2012-08-18 15:09:29  INFO    OGG-01735  Oracle GoldenGate Collector:  Synchronizing ./dirdat/oa000012 to disk.
2012-08-18 15:09:29  INFO    OGG-01735  Oracle GoldenGate Collector:  Synchronizing ./dirdat/oa000012 to disk.
2012-08-18 15:09:29  INFO    OGG-01670  Oracle GoldenGate Collector:  Closing ./dirdat/oa000012.
2012-08-18 15:09:29  INFO    OGG-01669  Oracle GoldenGate Collector:  Opening ./dirdat/oa000013 (byte -1, current EOF 0).
2012-08-18 15:10:02  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): edit params repoa.
2012-08-18 15:11:14  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): start repoa.
2012-08-18 15:11:14  INFO    OGG-00963  Oracle GoldenGate Manager for Oracle, mgr.prm:  Command received from GGSCI on host 10.100.195.23 (START REPLICAT RE
POA ).
2012-08-18 15:11:14  INFO    OGG-00975  Oracle GoldenGate Manager for Oracle, mgr.prm:  REPLICAT REPOA starting.
2012-08-18 15:11:14  INFO    OGG-00995  Oracle GoldenGate Delivery for Oracle, repoa.prm:  REPLICAT REPOA starting.
2012-08-18 15:11:16  INFO    OGG-00893  Oracle GoldenGate Delivery for Oracle, repoa.prm:  SQL statement executed successfully.
2012-08-18 15:11:29  INFO    OGG-00996  Oracle GoldenGate Delivery for Oracle, repoa.prm:  REPLICAT REPOA started.
2012-08-18 15:12:38  INFO    OGG-01735  Oracle GoldenGate Collector:  Synchronizing ./dirdat/oa000013 to disk.
2012-08-18 15:12:38  INFO    OGG-01735  Oracle GoldenGate Collector:  Synchronizing ./dirdat/oa000013 to disk.
2012-08-18 15:12:38  INFO    OGG-01670  Oracle GoldenGate Collector:  Closing ./dirdat/oa000013.
2012-08-18 15:12:38  INFO    OGG-01669  Oracle GoldenGate Collector:  Opening ./dirdat/oa000014 (byte -1, current EOF 0).
2012-08-18 15:12:59  WARNING OGG-00869  Oracle GoldenGate Delivery for Oracle, repoa.prm:  No unique key is defined for table /BIC/FZPMLPC04. All viable col
umns will be used to represent the key, but may not guarantee uniqueness.  KEYCOLS may be used to define the key.
2012-08-18 15:12:59  WARNING OGG-00869  Oracle GoldenGate Delivery for Oracle, repoa.prm:  OCI Error ORA-14400: inserted partition key does not map to any p
artition (status = 14400), SQL <INSERT INTO "SAPSR3"."/BIC/FZPMLPC04" ("KEY_ZPMLPC04P","KEY_ZPMLPC04T","KEY_ZPMLPC04U","KEY_ZPMLPC041","/BIC/ZPMCZPTJ") VALU
ES (:a0,:a1,:a2,:a3,:a4)>.
2012-08-18 15:12:59  WARNING OGG-01004  Oracle GoldenGate Delivery for Oracle, repoa.prm:  Aborted grouped transaction on 'SAPSR3./BIC/FZPMLPC04', Database
error 14400 (OCI Error ORA-14400: inserted partition key does not map to any partition (status = 14400), SQL <INSERT INTO "SAPSR3"."/BIC/FZPMLPC04" ("KEY_ZP
MLPC04P","KEY_ZPMLPC04T","KEY_ZPMLPC04U","KEY_ZPMLPC041","/BIC/ZPMCZPTJ") VALUES (:a0,:a1,:a2,:a3,:a4)>).
2012-08-18 15:12:59  WARNING OGG-01003  Oracle GoldenGate Delivery for Oracle, repoa.prm:  Repositioning to rba 32114396 in seqno 12.
2012-08-18 15:13:00  WARNING OGG-01154  Oracle GoldenGate Delivery for Oracle, repoa.prm:  SQL error 14400 mapping SAPSR3./BIC/FZPMLPC04 to SAPSR3./BIC/FZPM
LPC04 OCI Error ORA-14400: inserted partition key does not map to any partition (status = 14400), SQL <INSERT INTO "SAPSR3"."/BIC/FZPMLPC04" ("KEY_ZPMLPC04P
","KEY_ZPMLPC04T","KEY_ZPMLPC04U","KEY_ZPMLPC041","/BIC/ZPMCZPTJ") VALUES (:a0,:a1,:a2,:a3,:a4)>.
2012-08-18 15:13:00  WARNING OGG-01003  Oracle GoldenGate Delivery for Oracle, repoa.prm:  Repositioning to rba 32425135 in seqno 12.
2012-08-18 15:13:00  ERROR   OGG-01296  Oracle GoldenGate Delivery for Oracle, repoa.prm:  Error mapping from SAPSR3./BIC/FZPMLPC04 to SAPSR3./BIC/FZPMLPC0
...
...
...
.2012-08-21 07:56:54  ERROR   OGG-00199  Oracle GoldenGate Delivery for Oracle, repoa.prm:  Table SAPSR3./BI0/0P00000012 does not exist in target database.
2012-08-21 07:56:54  ERROR   OGG-01668  Oracle GoldenGate Delivery for Oracle, repoa.prm:  PROCESS ABENDING.
2012-08-21 07:58:46  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): start repoa.
2012-08-21 07:58:46  INFO    OGG-00963  Oracle GoldenGate Manager for Oracle, mgr.prm:  Command received from GGSCI on host 10.100.195.23 (START REPLICAT RE
POA ).
2012-08-21 07:58:46  INFO    OGG-00975  Oracle GoldenGate Manager for Oracle, mgr.prm:  REPLICAT REPOA starting.
2012-08-21 07:58:46  INFO    OGG-00995  Oracle GoldenGate Delivery for Oracle, repoa.prm:  REPLICAT REPOA starting.
2012-08-21 07:58:47  INFO    OGG-00893  Oracle GoldenGate Delivery for Oracle, repoa.prm:  SQL statement executed successfully.结合上述报错，现在出现了2个问题：
1.SAPSR3./BIC/FZPMLPC04该表插入分区键的时候，没有匹配的表分区
我参考过这个帖子：http://space.itpub.net/11088128/viewspace-711613
但是查询不到 表分区的任何信息
so，分区信息都查不到 无法查对应的part_key了!!

2.SAPSR3./BI0/0P00000012
在生产库中，不管是索引，还是分区表都没查到,非常疑惑，着玩意哪来的！！？？

现在只能先mapexlude，先过滤了！求解啊求解

[ 本帖最后由 wengtf 于 2012-8-21 12:56 编辑 ]

Maclean Liu(刘相兵 发表于 2012-8-21 13:00:34

2012-08-18 15:07:30  WARNING OGG-01004  Oracle GoldenGate Delivery for Oracle, repoa.prm:  Aborted grouped transaction on 'SAPSR3./BIC/FZPMLPC03', Database
error 14400 (OCI Error ORA-14400: inserted partition key does not map to any partition (status = 14400), SQL <INSERT INTO "SAPSR3"."/BIC/FZPMLPC03" ("KEY_ZP
MLPC03P","KEY_ZPMLPC03T","KEY_ZPMLPC03U","KEY_ZPMLPC031","/BIC/ZPMGZPTJ") VALUES (:a0,:a1,:a2,:a3,:a4)>).
2012-08-18 15:07:30  WARNING OGG-01003  Oracle GoldenGate Delivery for Oracle, repoa.prm:  Repositioning to rba 185661450 in seqno 11.
2012-08-18 15:07:30  WARNING OGG-01154  Oracle GoldenGate Delivery for Oracle, repoa.prm:  SQL error 14400 mapping SAPSR3./BIC/FZPMLPC03 to SAPSR3./BIC/FZPM
LPC03 OCI Error ORA-14400: inserted partition key does not map to any partition (status = 14400), SQL <INSERT INTO "SAPSR3"."/BIC/FZPMLPC03" ("KEY_ZPMLPC03P
","KEY_ZPMLPC03T","KEY_ZPMLPC03U","KEY_ZPMLPC031","/BIC/ZPMGZPTJ") VALUES (:a0,:a1,:a2,:a3,:a4)>.
2012-08-18 15:07:30  WARNING OGG-01003  Oracle GoldenGate Delivery for Oracle, repoa.prm:  Repositioning to rba 186880153 in seqno 11.
2012-08-18 15:07:30  ERROR   OGG-01296  Oracle GoldenGate Delivery for Oracle, repoa.prm:  Error mapping from SAPSR3./BIC/FZPMLPC03 to SAPSR3./BIC/FZPMLPC03





"SAPSR3"."/BIC/FZPMLPC03"



列出在  source 和 target 上 这个表的DDL语句 和 分区情况

wengtf 发表于 2012-8-21 14:12:28

刘大，这个表是sap内部维护的表，看不到ddl语句！
很遗憾的是
select partition_name, high_value from user_tab_partitions wher table_name=‘SAPSR3."/BIC/FZPMLPC03" ’;
返回 no rows
因为不知道到sapsr3密码，只能通过sys用户查看如下信息：
select * from dba_PART_KEY_COLUMNS where table=‘SAPSR3."/BIC/FZPMLPC03" ‘;
返回no rows

还有其他方法获取相关信息么，刘大！！

Maclean Liu(刘相兵 发表于 2012-8-21 14:26:55

dbms_metadata.get_ddl不可以吗？

wengtf 发表于 2012-8-21 14:42:13

##源库：SQL> set long 90000
select dbms_metadata.get_ddl('TABLE','/BIC/FZPMLPC03','SAPSR3') from dual;
DBMS_METADATA.GET_DDL('TABLE','/BIC/FZPMLPC03','SAPSR3')
--------------------------------------------------------------------------------

  CREATE TABLE "SAPSR3"."/BIC/FZPMLPC03"
   (    "KEY_ZPMLPC03P" NUMBER(10,0) DEFAULT 0 NOT NULL ENABLE,

        "KEY_ZPMLPC03T" NUMBER(10,0) DEFAULT 0 NOT NULL ENABLE,
        "KEY_ZPMLPC03U" NUMBER(10,0) DEFAULT 0 NOT NULL ENABLE,
        "KEY_ZPMLPC031" NUMBER(10,0) DEFAULT 0 NOT NULL ENABLE,
        "/BIC/ZPMGZPTJ" NUMBER(17,3) DEFAULT 0 NOT NULL ENABLE,
         SUPPLEMENTAL LOG GROUP "GGS_/BIC/FZPMLPC03_514722"
("KEY_ZPMLPC03P", "KEY_ZPMLPC03T", "KEY_ZPMLPC03U",
"KEY_ZPMLPC031", "/BIC/ZPMGZPTJ") ALWAYS
   ) PCTFREE 10 PCTUSED 60 INITRANS 1 MAXTRANS 255
  STORAGE(INITIAL 16384 NEXT 10485760 MINEXTENTS 1 MAXEXTENTS 2
147483645
  PCTINCREASE 0 FREELISTS 4 BUFFER_POOL DEFAULT)
  TABLESPACE "PSAPSR3"
  PARTITION BY RANGE ("KEY_ZPMLPC03P")
(PARTITION "/BIC/FZPMLPC030"  VALUES LESS THAN (0)
  PCTFREE 10 PCTUSED 60 INITRANS 1 MAXTRANS 255
  STORAGE(INITIAL 16384 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS
2147483645
  PCTINCREASE 0 FREELISTS 4 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  TABLESPACE "PSAPSR3" NOCOMPRESS ,
PARTITION "/BIC/FZPMLPC030000001284"  VALUES LESS THAN (0000001284
)
  PCTFREE 10 PCTUSED 60 INITRANS 1 MAXTRANS 255
  STORAGE(INITIAL 16384 NEXT 1048576 MINEXTENTS 1 MA
XEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 4 FREELIST GROUPS 1 BUFFER_POOL
DEFAULT)
  TABLESPACE "PSAPSR3" NOCOMPRESS )

SQL> select count(*) from sapsr3."/BIC/FZPMLPC03";
  COUNT(*)
----------
     90531

##目标库：SQL> select dbms_metadata.get_ddl('TABLE','/BIC/FZPMLPC03','SAPSR3') from dual;
DBMS_METADATA.GET_DDL('TABLE','/BIC/FZPMLPC03','SAPSR3')
---------------------------------------------------------------------------

SQL> desc sapsr3."/BIC/FZPMLPC03"
Name                                      Null?    Type
----------------------------------------- --------
KEY_ZPMLPC03P                             NOT NULL NUMBER(10)
KEY_ZPMLPC03T                             NOT NULL NUMBER(10)
KEY_ZPMLPC03U                             NOT NULL NUMBER(10)
KEY_ZPMLPC031                             NOT NULL NUMBER(10)
/BIC/ZPMGZPTJ                             NOT NULL NUMBER(17,3)
SQL> select count(*) from sapsr3."/BIC/FZPMLPC03";
  COUNT(*)
----------
     90531

[ 本帖最后由 wengtf 于 2012-8-21 14:56 编辑 ]

wengtf 发表于 2012-8-21 15:04:26

补充点：因为业务是ERP的高级查询，ddl复制应该可以不开（事实没开），但是现在的报错感觉又有点像！！！

Maclean Liu(刘相兵 发表于 2012-8-21 15:10:10

没有显示 目标库的DDL?

wengtf 发表于 2012-8-21 15:15:21

原帖由 maclean 于 2012-8-21 15:10 发表 http://t.askmaclean.com/images/common/back.gif
没有显示 目标库的DDL?

是的，没有

ShineCQY 发表于 2012-8-21 15:17:52

翁总，以前不是出现过类似的情况了吗？开启OGG DDL复制功能。
还是初始化完成后就报错？

wengtf 发表于 2012-8-21 15:19:22

原帖由 ShineCQY 于 2012-8-21 15:17 发表 http://t.askmaclean.com/images/common/back.gif
翁总，以前不是出现过类似的情况了吗？开启OGG DDL复制功能。
还是初始化完成后就报错？
DDL复制还没开，8月18日 rman初始化之后就出现这个情况了！

wengtf 发表于 2012-8-21 15:46:54

这贴先结贴，等开了DDL复制后，再看是否能重现该错误！！
ps：多谢，以上各位的关注！
页: [1]
查看完整版本: WARNING OGG-00869 OCI Error ORA-14400