Oracle GoldenGate 系列：Replicat 进程遇 OCI Error ORA-14402 错误解决办法.pdf

DDBBAA nneevveerr sslleeeepp--DDBBAA，，永永不不眠眠 FFooccuuss oonn OOrraaccllee DDaattaabbaassee,, GGooddeennGGaattee aanndd UUnniixx [[ 顶顶]] OOrraaccllee GGoollddeennGGaattee 系系列列：：RReepplliiccaatt 进进程程遇遇 OOCCII EErrrroorr OORRAA--1144440022 错错误误解解决决办办 法法 分类： Oracle Troubleshooting Oracle GoldenGate 2013-04-25 23:03 410人阅读 评论 (0) 收藏 举报 Oracle GoldenGate 系列Replicat 进程遇 OCI ErrORA-14402 错误解决办法OGG-00869 生产环境发票管理库到总局主数据库 Replicat 进程因报如下错误 Abended： 2013-04-25 07:59:50  WARNING OGG-00869  OCI Error ORA-14402: updating partition keycolumn would cause a partition change (status = 14402). UPDATEHX_FP.FP_PZHDXX SET SWJG_DM =:a1,XGRQ = :a2, SJGSDQ = :a3 WHEREHDQCUUID = :b0. 2013-04-25 07:59:50  WARNING OGG-01004  Aborted grouped transaction onHX_FP.FP_PZHDXX, Database error 14402 (OCI Error ORA-14402: updatingpartition key column would cause a partition change (statu s = 14402). UPDATEHX_FP.FP_PZHDXX SET SWJG_DM = :a1,XGRQ= :a2,SJGSDQ = :a3 WHERE HDQCUUID = :b0). 2013-04-25 07:59:50  WARNING OGG-01003  Repositioning to rba 355778 in seqno 83. 2013-04-25 07:59:50  WARNING OGG-01154  SQL error 14402 mapping HX_FP.FP_PZHDXX toHX_FP.FP_PZHDXX OCI Error ORA-14402: updating partition key column would causea partition change (status = 14402). U PDATEHX_FP.FP_PZHDXX SET SWJG_DM =:a1,XGRQ = :a2,SJGSDQ = :a3 WHERE HDQCUUID= :b0. 2013-04-25 07:59:50  WARNING OGG-01003  Repositioning to rba 355778 in seqno 83. Source Context :  SourceModule            :[er.errors]  SourceID                : [/scratch/aime1/adestore/views/aime1_staxj16/oggcore/OpenSys/src/app/er/errors.cpp]  SourceFunction          :[take_rep_err_action (short, int32_t, const char *, extr_ptr_def *,std_rec_hdr_def *, char *, file_def *, bool)]   SourceLine              : [623] 2013-04-25 07:59:50  ERROR  OGG-01296  Error mapping fromHX_FP.FP_PZHDXX to HX_FP.FP_PZHDXX.   WARNNING OGG-00869根据官方的 Error Reference 中的描述，专指OGG遇到了特定的数据库错误，可以忽略。 O