OGG-02050 Not enough database memory to honor requested MAX_SGA_SIZE

来源：互联网发布：专业视频制作软件编辑：程序博客网时间：2024/04/30 16:17

在测试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 streamsNAME                                 TYPE        VALUE------------------------------------ ----------- ------------------------------streams_pool_size                    big integer 4MSQL>SQL>SQL>SQL> startup force;ORACLE instance started.Total System Global Area  417546240 bytesFixed Size                  2253824 bytesVariable Size             322964480 bytesDatabase Buffers           88080384 bytesRedo Buffers                4247552 bytesDatabase mounted.Database opened.SQL>SQL>SQL> show parameter streamsNAME                                 TYPE        VALUE------------------------------------ ----------- ------------------------------streams_pool_size                    big integer 100MSQL>

再次尝试启动extract进程：

GGSCI (zbdba1) 21> info allProgram     Status      Group       Lag at Chkpt  Time Since ChkptMANAGER     RUNNING                                          EXTRACT     RUNNING     EXT1        00:00:00      00: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: BR    anon alloc: mmap(MAP_ANON)  anon free: munmap    file alloc: mmap(MAP_SHARED)  file free: munmap    target directories:    /ogg/BR/EXT1.2015-03-02 10:47:26  INFO    OGG-01815  Oracle GoldenGate Capture for Oracle, ext1.prm:  Virtual Memory Facilities for: COM    anon alloc: mmap(MAP_ANON)  anon free: munmap    file alloc: mmap(MAP_SHARED)  file free: munmap    target 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.

1 0