在测试GoldenGate Integrated Capture Mode的时候，，启动抽取进程报 OGG-02050 Not enough database memory to honor requested MAX_SGA_SIZE 错误
参数配置如下：
GGSCI (zbdba1) 20> view param ext1EXTRACT ext1USERID ogg, PASSWORD oggTRANLOGOPTIONS INTEGRATEDPARAMS (MAX_SGA_SIZE 50,parallelism 1)EXTTRAIL /ogg/dirdat/saTABLE zbdba.*;解决方案：SQL> alter system set streams_pool_size=100m scope=spfile;System altered.SQL> show parameter streamsNAMETYPEVALUE———————————— ———– ——————————streams_pool_sizebig integer 4MSQL>SQL>SQL>SQL> startup force;ORACLE instance started.Total System Global Area 417546240 bytesFixed Size2253824 bytesVariable Size322964480 bytesDatabase Buffers88080384 bytesRedo Buffers4247552 bytesDatabase mounted.Database opened.SQL>SQL>SQL> show parameter streamsNAMETYPEVALUE———————————— ———– ——————————streams_pool_sizebig integer 100MSQL>再次尝试启动extract进程：GGSCI (zbdba1) 21> info allProgramStatusGroupLag at Chkpt Time Since ChkptMANAGERRUNNINGEXTRACTRUNNINGEXT100:00:0000:00:08
查看日志：
2015-03-02 10:47:26 INFO OGG-00992 Oracle GoldenGate Capture for Oracle, ext1.prm: EXTRACT EXT1 starting.2015-03-02 10:47:26 INFO OGG-03035 Oracle GoldenGate Capture for Oracle, ext1.prm: Operating system character set identified as UTF-8. Locale: en_US, LC_ALL:.2015-03-02 10:47:26 INFO OGG-01635 Oracle GoldenGate Capture for Oracle, ext1.prm: BOUNDED RECOVERY: reset to initial or altered checkpoint.2015-03-02 10:47:26 INFO OGG-01815 Oracle GoldenGate Capture for Oracle, ext1.prm: Virtual Memory Facilities for: BRanon alloc: mmap(MAP_ANON) anon free: munmapfile alloc: mmap(MAP_SHARED) file free: munmaptarget directories:/ogg/BR/EXT1.2015-03-02 10:47:26 INFO OGG-01815 Oracle GoldenGate Capture for Oracle, ext1.prm: Virtual Memory Facilities for: COManon alloc: mmap(MAP_ANON) anon free: munmapfile alloc: mmap(MAP_SHARED) file free: munmaptarget directories:/ogg/dirtmp.2015-03-02 10:47:26 WARNING OGG-01423 Oracle GoldenGate Capture for Oracle, ext1.prm: No valid default archive log destination directory found for thread 1.2015-03-02 10:47:33 INFO OGG-02036 Oracle GoldenGate Capture for Oracle, ext1.prm: Integrated capture successfully attached to logmining server OGG$EXT1.2015-03-02 10:47:34 INFO OGG-00993 Oracle GoldenGate Capture for Oracle, ext1.prm: EXTRACT EXT1 started.2015-03-02 10:47:34 INFO OGG-01052 Oracle GoldenGate Capture for Oracle, ext1.prm: No recovery is required for target file /ogg/dirdat/sa000000, at RBA 0 (file not opened).2015-03-02 10:47:34 INFO OGG-01478 Oracle GoldenGate Capture for Oracle, ext1.prm: Output file /ogg/dirdat/sa is using format RELEASE 11.2.
人要有梦想，有了梦想才会努力奋斗，
