您当前位置：
首页 >
数据库 >
数据库应用 > 在测试GoldenGate Integrated Capture Mode的时候，启动抽取进程报 OGG-02050 Not enough database m
在测试GoldenGate Integrated Capture Mode的时候，启动抽取进程报 OGG-02050 Not enough database m
来源：程序员人生 发布时间：2015-03-25 11:56:05 阅读次数：5184次
在测试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⑻. 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.
-
生活不易，码农辛苦
如果您觉得本网站对您的学习有所帮助,可以手机扫描二维码进行捐赠
------分隔线----------------------------
------分隔线----------------------------
