OGG-02050 not enough database memory to honor requested Max_sga_size

When testing goldengate Integrated Capture mode, start the extraction process OGG-02050 not enough database memory to honor requested Max_sga_size error

The parameters are configured as follows:

Ggsci (ZBDBA1) 20> view param ext1extract ext1userid ogg, PASSWORD oggtranlogoptions Integratedparams (max_sga_size 50, Parallelism 1) exttrail/ogg/dirdat/satable zbdba.*;

Solution:

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>

Try to start the extract process again:

Ggsci (ZBDBA1) 21> info allprogram     Status      Group       Lag at chkpt time  Since chkptmanager     RUNNING                                          EXTRACT     RUNNING     EXT1        00:00:00      00:00:08   

To view logs:

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 RE Covery:reset to initial or altered checkpoint.2015-03-02 10:47:26 INFO OGG-01815 Oracle GoldenGate Capture for Oracl E, ext1.prm:Virtual Memory Facilities for:br anon alloc:mmap (map_anon) anon free:munmap file Alloc:mmap (map_s  hared) 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 fil  E 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:3 3 INFO OGG-02036 Oracle GoldenGate capture for Oracle, ext1.prm:Integrated capture successfully attached to Logmini ng server ogg$ext1.2015-03-02 10:47:34 INFO OGG-00993 Oracle GoldenGate Capture for Oracle, Ext1.prm:EXTRACT EXT1 s tarted.2015-03-02 10:47:34 INFO OGG-01052 Oracle GoldenGate Capture for Oracle, ext1.prm:No recovery is required fo R Target file/ogg/dirdat/sa000000, at RBA 0 (file not opened). 2015-03-02 10:47:34 INFO OGG-01478 Oracle GoldenGate C  Apture for Oracle, Ext1.prm:Output File/ogg/dirdat/sa is using format RELEASE 11.2.

OGG-02050 not enough database memory to honor requested Max_sga_size