OGG-02050 Not enough database memory to honor requested MAX_SGA_SIZE

在测试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.*;

解决方案:

SQL> alter system set streams_pool_size=100m scope=spfile;

System altered.

SQL> show parameter streams

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
streams_pool_size                    big integer 4M
SQL>
SQL>
SQL>
SQL> startup force;
ORACLE instance started.

Total System Global Area  417546240 bytes
Fixed Size                  2253824 bytes
Variable Size             322964480 bytes
Database Buffers           88080384 bytes
Redo Buffers                4247552 bytes
Database mounted.
Database opened.
SQL>
SQL>
SQL> show parameter streams

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
streams_pool_size                    big integer 100M
SQL>
 再次尝试启动extract进程:

GGSCI (zbdba1) 21> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     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.
 





郑重声明:本站内容如果来自互联网及其他传播媒体,其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享,并不代表本站赞同其观点和对其真实性负责,也不构成任何其他建议。