WARNING OGG-00869 Oracle GoldenGate Delivery for Oracle, OCI Error ORA-26945
1,報錯日誌
2017-03-23 12:48:00 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): start YLREP.
2017-03-23 12:48:00 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from GGSCI on host qs-proxydb2.800best.com (START REPLICAT YLREP ).
2017-03-23 12:48:00 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: REPLICAT YLREP starting.
2017-03-23 12:48:00 INFO OGG-00995 Oracle GoldenGate Delivery for Oracle, ylrep.prm: REPLICAT YLREP starting.
2017-03-23 12:48:00 INFO OGG-03035 Oracle GoldenGate Delivery for Oracle, ylrep.prm: Operating system character set identified as UTF-8. Locale: en_US, LC_ALL:.
2017-03-23 12:48:00 INFO OGG-01815 Oracle GoldenGate Delivery for Oracle, ylrep.prm: Virtual Memory Facilities for: COM
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/tmpdata/ogg/dirtmp.
2017-03-23 12:48:00 INFO OGG-00996 Oracle GoldenGate Delivery for Oracle, ylrep.prm: REPLICAT YLREP started.
2017-03-23 12:48:00 WARNING OGG-00869 Oracle GoldenGate Delivery for Oracle, ylrep.prm: OCI Error ORA-26945: unsupported hint RESTRICT_ALL_REF_CONS (status = 26945). UPDATE /*+ RESTRICT_ALL_REF_CONS */ "BTR_WYVERN"."WY_ONLINE_SCHEDULE" SET "LOCK_VERSION" = :a1,"MODIFY_FLAG" = :a2,"STATUS" = :a3,"PRE_EFFECT_TO" = :a4 WHERE "ID" = :b0.
2017-03-23 12:48:00 WARNING OGG-01004 Oracle GoldenGate Delivery for Oracle, ylrep.prm: Aborted grouped transaction on 'BTR_WYVERN.WY_ONLINE_SCHEDULE', Database error 26945 (OCI Error ORA-26945: unsupported hint RESTRICT_ALL_REF_CONS (status = 26945). UPDATE /*+ RESTRICT_ALL_REF_CONS */ "BTR_WYVERN"."WY_ONLINE_SCHEDULE" SET "LOCK_VERSION" = :a1,"MODIFY_FLAG" = :a2,"STATUS" = :a3,"PRE_EFFECT_TO" = :a4 WHERE "ID" = :b0).
2017-03-23 12:48:00 WARNING OGG-01003 Oracle GoldenGate Delivery for Oracle, ylrep.prm: Repositioning to rba 1260 in seqno 73.
2017-03-23 12:48:00 WARNING OGG-01154 Oracle GoldenGate Delivery for Oracle, ylrep.prm: SQL error 26945 mapping BTR_WYVERN.WY_ONLINE_SCHEDULE to BTR_WYVERN.WY_ONLINE_SCHEDULE OCI Error ORA-26945: unsupported hint RESTRICT_ALL_REF_CONS (status = 26945). UPDATE /*+ RESTRICT_ALL_REF_CONS */ "BTR_WYVERN"."WY_ONLINE_SCHEDULE" SET "LOCK_VERSION" = :a1,"MODIFY_FLAG" = :a2,"STATUS" = :a3,"PRE_EFFECT_TO" = :a4 WHERE "ID" = :b0.
2017-03-23 12:48:00 WARNING OGG-01003 Oracle GoldenGate Delivery for Oracle, ylrep.prm: Repositioning to rba 1260 in seqno 73.
2017-03-23 12:48:00 ERROR OGG-01296 Oracle GoldenGate Delivery for Oracle, ylrep.prm: Error mapping from BTR_WYVERN.WY_ONLINE_SCHEDULE to BTR_WYVERN.WY_ONLINE_SCHEDULE.
2017-03-23 12:48:00 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, ylrep.prm: PROCESS ABENDING.
GGSCI (qs-proxydb2.800best.com) 3> view params YLREP
replicat ylrep
setenv (NLS_LANG = AMERICAN_AMERICA.ZHS16GBK)
setenv (ORACLE_SID =prob阿薩德飛灑發的 )
userid ggs, password A, encryptkey default
reperror default,abend
purgeoldextracts /tmpdata/ogg/dirdat/yl/*, usecheckpoints, minkeepdays 7
discardfile /tmpdata/ogg/dirdat/ylrep.dsc,append, megabytes 20
discardrollover on sunday
assumetargetdefs
dboptions deferrefconst
2,修改oracle引數
12:47:28 sys@proxydb2>show parameter ENABLE_GOLDENGATE_REPLICATION;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
enable_goldengate_replication boolean FALSE
12:49:53 sys@proxydb2>ALTER SYSTEM SET ENABLE_GOLDENGATE_REPLICATION = TRUE SCOPE=BOTH;
System altered.
Elapsed: 00:00:00.08
3,重新啟動程式
GGSCI (qs-proxydb2.800best.com) 5> start YLREP
Sending START request to MANAGER ...
REPLICAT YLREP starting
GGSCI (qs-proxydb2.800best.com) 6> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT ABENDED TMREP 01:05:31 00:10:22
REPLICAT ABENDED V5REP 01:07:25 00:09:00
REPLICAT RUNNING YLREP 00:00:00 00:00:06
2017-03-23 12:48:00 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): start YLREP.
2017-03-23 12:48:00 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from GGSCI on host qs-proxydb2.800best.com (START REPLICAT YLREP ).
2017-03-23 12:48:00 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: REPLICAT YLREP starting.
2017-03-23 12:48:00 INFO OGG-00995 Oracle GoldenGate Delivery for Oracle, ylrep.prm: REPLICAT YLREP starting.
2017-03-23 12:48:00 INFO OGG-03035 Oracle GoldenGate Delivery for Oracle, ylrep.prm: Operating system character set identified as UTF-8. Locale: en_US, LC_ALL:.
2017-03-23 12:48:00 INFO OGG-01815 Oracle GoldenGate Delivery for Oracle, ylrep.prm: Virtual Memory Facilities for: COM
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/tmpdata/ogg/dirtmp.
2017-03-23 12:48:00 INFO OGG-00996 Oracle GoldenGate Delivery for Oracle, ylrep.prm: REPLICAT YLREP started.
2017-03-23 12:48:00 WARNING OGG-00869 Oracle GoldenGate Delivery for Oracle, ylrep.prm: OCI Error ORA-26945: unsupported hint RESTRICT_ALL_REF_CONS (status = 26945). UPDATE /*+ RESTRICT_ALL_REF_CONS */ "BTR_WYVERN"."WY_ONLINE_SCHEDULE" SET "LOCK_VERSION" = :a1,"MODIFY_FLAG" = :a2,"STATUS" = :a3,"PRE_EFFECT_TO" = :a4 WHERE "ID" = :b0.
2017-03-23 12:48:00 WARNING OGG-01004 Oracle GoldenGate Delivery for Oracle, ylrep.prm: Aborted grouped transaction on 'BTR_WYVERN.WY_ONLINE_SCHEDULE', Database error 26945 (OCI Error ORA-26945: unsupported hint RESTRICT_ALL_REF_CONS (status = 26945). UPDATE /*+ RESTRICT_ALL_REF_CONS */ "BTR_WYVERN"."WY_ONLINE_SCHEDULE" SET "LOCK_VERSION" = :a1,"MODIFY_FLAG" = :a2,"STATUS" = :a3,"PRE_EFFECT_TO" = :a4 WHERE "ID" = :b0).
2017-03-23 12:48:00 WARNING OGG-01003 Oracle GoldenGate Delivery for Oracle, ylrep.prm: Repositioning to rba 1260 in seqno 73.
2017-03-23 12:48:00 WARNING OGG-01154 Oracle GoldenGate Delivery for Oracle, ylrep.prm: SQL error 26945 mapping BTR_WYVERN.WY_ONLINE_SCHEDULE to BTR_WYVERN.WY_ONLINE_SCHEDULE OCI Error ORA-26945: unsupported hint RESTRICT_ALL_REF_CONS (status = 26945). UPDATE /*+ RESTRICT_ALL_REF_CONS */ "BTR_WYVERN"."WY_ONLINE_SCHEDULE" SET "LOCK_VERSION" = :a1,"MODIFY_FLAG" = :a2,"STATUS" = :a3,"PRE_EFFECT_TO" = :a4 WHERE "ID" = :b0.
2017-03-23 12:48:00 WARNING OGG-01003 Oracle GoldenGate Delivery for Oracle, ylrep.prm: Repositioning to rba 1260 in seqno 73.
2017-03-23 12:48:00 ERROR OGG-01296 Oracle GoldenGate Delivery for Oracle, ylrep.prm: Error mapping from BTR_WYVERN.WY_ONLINE_SCHEDULE to BTR_WYVERN.WY_ONLINE_SCHEDULE.
2017-03-23 12:48:00 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, ylrep.prm: PROCESS ABENDING.
GGSCI (qs-proxydb2.800best.com) 3> view params YLREP
replicat ylrep
setenv (NLS_LANG = AMERICAN_AMERICA.ZHS16GBK)
setenv (ORACLE_SID =prob阿薩德飛灑發的 )
userid ggs, password A, encryptkey default
reperror default,abend
purgeoldextracts /tmpdata/ogg/dirdat/yl/*, usecheckpoints, minkeepdays 7
discardfile /tmpdata/ogg/dirdat/ylrep.dsc,append, megabytes 20
discardrollover on sunday
assumetargetdefs
dboptions deferrefconst
2,修改oracle引數
12:47:28 sys@proxydb2>show parameter ENABLE_GOLDENGATE_REPLICATION;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
enable_goldengate_replication boolean FALSE
12:49:53 sys@proxydb2>ALTER SYSTEM SET ENABLE_GOLDENGATE_REPLICATION = TRUE SCOPE=BOTH;
System altered.
Elapsed: 00:00:00.08
3,重新啟動程式
GGSCI (qs-proxydb2.800best.com) 5> start YLREP
Sending START request to MANAGER ...
REPLICAT YLREP starting
GGSCI (qs-proxydb2.800best.com) 6> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT ABENDED TMREP 01:05:31 00:10:22
REPLICAT ABENDED V5REP 01:07:25 00:09:00
REPLICAT RUNNING YLREP 00:00:00 00:00:06
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/29108064/viewspace-2135915/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 【故障-goldengate】WARNING OGG-00869 OCI Error ORA-14400GoError
- Oracle goldengate的觸發器錯誤 OGG-00869OracleGo觸發器
- Oracle案例13—— OGG-01163 Oracle GoldenGate Delivery for Oracle, reprpt01.prmOracleGo
- ORACLE GOLDENGATE MANAGER ABENDS, ERROR OGG-01454OracleGoError
- Oracle GoldenGate DirectorOracleGo
- oracle goldengate 配置OracleGo
- 關於Oracle OCI驅動的使用Oracle
- PHP提供Oracle支援增加oci8模組PHPOracle
- About the Oracle GoldenGate TrailOracleGoAI
- oracle goldengate維護OracleGo
- Oracle GoldenGate: 使用巨集OracleGo
- GoldenGate Oracle MSSQL DateGoOracleSQL
- EWM error 'Delivery is already fully invoiced'Error
- 【GoldenGate】Oracle GoldenGate(三) DDL同步配置GoOracle
- ORACLE STREAM ERROROracleError
- 【GoldenGate】Oracle GoldenGate(二) 雙向同步配置GoOracle
- 轉:ORACLE的JDBC連線方式:OCI和THINOracleJDBC
- Oracle GoldenGate安裝(一)OracleGo
- Oracle GoldenGate安裝(二)OracleGo
- Oracle GoldenGate安裝(三)OracleGo
- ORACLE GoldenGate Initial LoadOracleGo
- Oracle GoldenGate環境搭建OracleGo
- oracle goldengate 初始化OracleGo
- Oracle goldengate 安裝配置OracleGo
- oracle GoldenGate Veridata配置OracleGo
- 轉:Oracle GoldenGate VeridataOracleGo
- Oracle GoldenGate – MappingsOracleGoAPP
- GoldenGate MSSQL Oracle基本流程GoSQLOracle
- 解除安裝Oracle GoldenGateOracleGo
- Oracle GoldenGate下載地址OracleGo
- oracle goldengate日常管理命令OracleGo
- Oracle GoldenGate and compressed tablesOracleGo
- WARNING: Oracle executable binary mismatch detectedOracle
- Goldengate資料傳輸外來鍵問題OGG-00869Go
- Oracle GoldenGate 異構平臺同步(Mysql到Oracle)OracleGoMySql
- oracle goldengate for oracle rac 的安裝和切換OracleGo
- Oracle GoldenGate 18.1釋出OracleGo
- Oracle Dataguard + Goldengate資料同步OracleGo