在测试GoldenGate Integrated Capture Mode的时候,启动抽取进程报 OGG-02050 Not enough database memory to honor requested MAX_SGA_SIZE 错误
参数配置如下:
- GGSCI (zbdba1) 20> view param ext1
- EXTRACT ext1
- USERID ogg, PASSWORD ogg
- TRANLOGOPTIONS INTEGRATEDPARAMS (MAX_SGA_SIZE 50,parallelism 1)
- EXTTRAIL /ogg/dirdat/sa
- TABLE zbdba.*;
解决方案: