一、集成模式进程配置
1、用户授权:exec dbms_goldengate_auth.grant_admin_privilege('goldengate');
2、参数调整:alter system set streams_pool_size=12g scope=spfile;
3、执行注册:dblogin userid goldengate password xxx
register extract capture01 database
4、增加extract进程
方法一:add extract capture01 integrated tranlog,begin now
方法二:alter extract capture01,upgrade integrated tranlog
5、删除注册信息:unregister extract capture01 database


二、常见报错处理

报错一:OGG-00868 ERROR CODE 1291 ORA-01291
解决:删除注册信息,重新注册


报错二:OGG-02077 ERROR CODE 3113 ORA-03113
原因:tranlogoptions integratedparams(_checkpoint_frequency 10000)
      tranlogoptions checkpointretentiontime 2
解决:修改参数,将参数注释掉,重启进程


报错三:OGG-01755 ERROR:OCI ERROR XXX
解决:select server_name,queue_name from dba_xstream_outbound;
exec dbms_xstream_gg_adm.stop_outbound('&server_name',true);
exec dbms_xstream_adm_drop_outbound('&server_name');
exec dbms_streams_adm.remove_queue(queue_name=>'ggmining.&queue_name',cascade=>true.drop_unused_queue_table=>true);


报错四:ERROR OGG-02028 ERROR 3113 ORA-03113
dbms_capture_adm.drop_capture(caoture_name=>'xxx',drop_unused_rule_sets=true);end; /
报错ORA-03113
使用10046追踪:
alter session set events '10046 trace name context forever,level 12';
alter session set events '10046 trace name context off';
报错:ORA-07445 lnxsni()+1874  ORA-01280
原因:打完oracle补丁23536249之后,没有执行postinstall脚本
解决:重启DB,关闭监听,重新跑postinstall脚本,编译失效对象