一、集成模式进程配置
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脚本，编译失效对象