WARNING OGG-00869 Oracle GoldenGate Delivery for Oracle, OCI Error ORA-26945

fei890910發表於2017-03-23
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    



來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/29108064/viewspace-2135915/,如需轉載,請註明出處,否則將追究法律責任。

相關文章