admin管理员组文章数量:1642236
OGG复制链路有如下报错:
OGG-01154
WARNING OGG-01154 Oracle GoldenGate Delivery for Oracle, rods-crs.prm: SQL error 4098 mapping NCPF_MAINT.NCPF_CUST_SITE to NCPF_MAINT.NCPF_CUST_SITE OCI Error ORA-04098: trigger 'NCPF_MAINT.NCPF_CUST_SITE_INS' is invalid and failed re-validation (status = 4098), SQL <INSERT INTO "NCPF_MAINT"."NCPF_CUST_SITE" ("NCPF_GNRC_CUST_UUID","SAP_ID","ISCUST_CUST_CDE","ISCUST_SUB_CDE","ISCUST_REGN_CDE","DEFAULT_MLNG_LBL_UUID") VALUES (:a0,:a1,:a2,:a3,:a4,:a5)>.
OGG-01296
ERROR OGG-01296 Oracle GoldenGate Delivery for Oracle, rods-crs.prm: Error mapping from NCPF_MAINT.NCPF_CUST_SITE to NCPF_MAINT.NCPF_CUST_SITE.
报错是由于触发器无效导致的链路异常,在配置ogg的过程中,对于触发器的处理方式最好的办法是采用禁用,但也存在没有禁用触发器的情况,故而引发了以上报错,根本的解决办法就是禁用触发器:
alter trigger NCPF_MAINT.NCPF_CUST_SITE_INS disable;
也可以尝试对触发器重新编译,无法编译的情况下,仍然需要禁用或者排除同步:
--在参数文件中添加以下排除语句
DDL EXCLUDE OBJNAME <schema>.<trigger-name>
--如果已有DDL INCLUDE,那么EXCLUDE必须跟在include之后,以‘,’隔开,例如:
DDL INCLUDE ALL,EXCLUDE OBJNAME <schema>.<trigger-name>
--重新编译触发器后,若触发器状态发生改变,则可以删除exclude
--可以使用以下脚本重编译,或单独编译触发器
@?/rdbms/admin/utlrp.sql
版权声明:本文标题:OGG-01154 ORA-04098 OGG-01296 报错解决 内容由热心网友自发贡献,该文观点仅代表作者本人, 转载请联系作者并注明出处:https://www.elefans.com/dongtai/1729333994a1196749.html, 本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容,一经查实,本站将立刻删除。
发表评论