“Not enough database memory” On GoldenGate

 

If Goldengate doesn’t start with errors like this, the solution is very easy.

Possible errors:

Not enough database memory to honor requested MAX_SGA_SIZE of 400.

PROCESS ABENDING.

Solution:

Set the parameters for streams_pool_size and shared_pool_size.

streams_pool_size must be greater than the size specified in the error (400 in the example above). Then restart the database.

dbtut
Author: dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *