在测试GoldenGate Integrated Capture Mode的时候，启动抽取进程报 OGG-02050 Not enough database memory to honor reque

在测试GoldenGate的集成捕获模式时，遇到错误OGG-02050，提示数据库内存不足无法满足请求的MAX_SGA_SIZE。已尝试将streams_pool_size设置为100M，但问题依然存在。日志显示EXT1进程已启动并成功附加到日志挖掘服务器，但没有有效的默认归档日志目的地。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

在测试GoldenGate Integrated Capture Mode的时候，启动抽取进程报 OGG-02050 Not enough database memory to honor requested MAX_SGA_SIZE 错误

参数配置如下：

[html] view plain copy

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.*;

解决方案：

[html] view plain copy

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进程：

[html] view plain copy

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

查看日志：

[html] view plain copy

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.