Oracle 19C OGG基础运维-04DML同步常见问题

Oracle 19C OGG基础运维-04DML同步常见问题  一：源端添加检查点失败 错误： No checkpoint table specified. Using GLOBALS specification c##ogg.ggschkpt... GGSCI (cjcos01 as c##ogg@cjcdb/CDB$ROOT) 2> ADD CHECKPOINTTABLE  No checkpoint table specified. Using GLOBALS specification c##ogg.ggschkpt... ERROR: Catalog name is missing from checkpoint table specification c##ogg.ggschkpt. 解决方案： 用户前指定数据库名 GGSCI (cjcos01 as c##ogg@cjcdb/CDB$ROOT) 2> ADD CHECKPOINTTABLE CDB$ROOT.c##ogg.ggschkpt 二：启动抓取进程ext_01失败 错误： Classic Extract does not support multitenant container databases. [oracle@cjcos01 ogg]$ tail -f ggserr.log  ...... 2020-04-09T13:29:22.503+0800  ERROR   OGG-06220  Oracle GoldenGate Capture for Oracle, ext_01.prm:  Classic Extract does not support multitenant container databases. 2020-04-09T13:29:22.582+0800  ERROR   OGG-01668  Oracle GoldenGate Capture for Oracle, ext_01.prm:  PROCESS ABENDING. 解决方案： 添加ext_01时指定INTEGRATED 添加抽取进程 ---add extract ext_01,tranlog,begin now ---delete extract ext_01  ADD EXTRACT ext_01,INTEGRATED TRANLOG,BEGIN NOW 三：添加pump进程失败  错误： ERROR: Invalid group name (must be at most 8 characters). GGSCI (cjcos01 as c##ogg@cjcdb/CDB$ROOT) 10> add extract extpump_01,exttrailsource /ogg/dirdat/rt ERROR: Invalid group name (must be at most 8 characters). 解决方案： 进程名不能大于8个字符，将extpump_01改成pump_01 GGSCI (cjcos01 as c##ogg@cjcdb/CDB$ROOT) 10> add extract pump_01,exttrailsource /ogg/dirdat/rt 四：启动应用进程rep_01失败 错误： Checkpoint table chenpdb.ogg.checkpoint does not exist 2020-04-09T13:49:54.378+0800  ERROR   OGG-00446  Oracle GoldenGate Delivery for Oracle, rep_01.prm:  Checkpoint table chenpdb.ogg.checkpoint does not exist. Create this table with the ADD CHECKPOINTTABLE command. 解决方案 ：  检查在设置./GLOBALS时表名为chenpdb.ogg.ggschkpt，添加rep_01进程时错写成了chenpdb.ogg.ggschkpt，导致后来启动rep_01失败，删除rep_01重新添加即可 add replicat rep_01,exttrail /ogg/dirdat/mb, CHECKPOINTTABLE chenpdb.ogg.ggschkpt 欢迎关注我的微信公众号"IT小Chen"，共同学习，共同成长！！！