Goldengate “Not enough database memory” issue

If Goldengate extract services fail to start with errors such as the ones below, the solution is very easy.

Possible errors:

Not enough database memory to honor requested MAX_SGA_SIZE of 400.

PROCESS ABENDING.

Solution:

Set the streams_pool_size and shared_pool_size parameters. The streams_pool_size must be larger than the size in the error (400 in the example above). Then restart the database.

alter system set streams_pool_size=1G scope=spfile sid='*';
alter system set shared_pool_size=5G scope=spfile sid='*';
srvctl stop database -d ORCL
srvctl start database -d ORCL