12c integrated模式OGG复制端不能插入数据

玉树林风

2014-05-12 19:47:13  ERROR   OGG-00664  Oracle GoldenGate Delivery for Oracle, zq.prm:  OCI Error Flushing database inbound server, 'OGG$ZQ' (status = 26804-ORA-26804: Apply "OGG$ZQ" is disabled.).2014-05-12 19:47:14  INFO    OGG-01971  Oracle GoldenGate Delivery for Oracle, zq.prm:  The previous message, 'INFO OGG-01021', repeated 1 times.2014-05-12 19:47:14  WARNING OGG-02531  Oracle GoldenGate Delivery for Oracle, zq.prm:  Inbound server OGG$ZQ error status ORA-600:ORA-00600: 内部错误代码, 参数: [knacmsg914], [], [], [], [], [], [], [], [], [], [], [].2014-05-12 19:47:15  ERROR   OGG-01668  Oracle GoldenGate Delivery for Oracle, zq.prm:  PROCESS ABENDING.

玉树林风

再次启动replicat进程，报错：
2014-05-12 20:03:21  INFO    OGG-02545  Oracle GoldenGate Delivery for Oracle, zq.prm:  Parameter GROUPTRANSOPS is ignored by Integrated Replicat when parallelism is greater than 1.
2014-05-12 20:03:26  ERROR   OGG-02513  Oracle GoldenGate Delivery for Oracle, zq.prm:  REPLICAT ZQ is not registered with the database.
2014-05-12 20:03:26  ERROR   OGG-01668  Oracle GoldenGate Delivery for Oracle, zq.prm:  PROCESS ABENDING.

玉树林风

源端参数文件：
GGSCI (goldengate1) 16> view params lin

-- GoldenGate Initial Data Capture
-- for EMP_OGG and DEPT_OGG
--
EXTRACT lin
setenv (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)
userid C##ogg,PASSWORD Ogg
RMTHOST goldengate2,MGRPORT 7809
-- RMTTASK REPLICAT,GROUP zq
EXTTRAIL ./dirdat/zi
RMTTRAIL ./dirdat/zq
sourcecatalog goldengatetest11
TABLE scott.emp;
TABLE scott.dept;


目标端参数文件：
GGSCI (goldengate2) 24> view params zq

-- GoldenGate Initial Load Delivery
REPLICAT zq
setenv (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)
ASSUMETARGETDEFS
USERID ogg@goldengate2test, PASSWORD Ogg
HANDLECOLLISIONS
DISCARDFILE ./dirrpt/RINIaa.dsc, PURGE
DBOPTIONS INTEGRATEDPARAMS(parallelism 1)
DYNAMICRESOLUTION
SOURCECATALOG goldengatetest11
MAP scott.*, TARGET scott.*;

玉树林风

此次配置的是12c integrated模式的OGG，求帮助

玉树林风

已经解决了，MOS上查询到了这样的类似结果，跟这个无关。
C:\Users\Administrator\Desktop\knacmsg914.jpg
之前目标端注册了PDB数据库REGISTER EXTRACT zq DATABASE CONTAINER (goldengate2test)，源端抽取数据并投递到目标的时候，目标端才出现的这样报错，后根据2014-05-12 20:03:26  ERROR   OGG-02513  Oracle GoldenGate Delivery for Oracle, zq.prm:  REPLICAT ZQ is not registered with the database.这条报错，看来目标端只需要创建出同样的CDB用户和PDB的数据，不用注册PDB数据库，直接REGISTER EXTRACT zq，DATABASE即可，目标端成功抓到数据，不再报ORA-00600的[knacmsg914]错误。

玉树林风

这是图片

travel.liu

玉树林风 发表于 2014-5-13 10:59
已经解决了，MOS上查询到了这样的类似结果，跟这个无关。

之前目标端注册了PDB数据库REGISTER EXTRACT zq  ...

你搞错了 ！应用端不需要register啊。

玉树林风

哦 好吧……