Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
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.
1 2 3 4 | 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 |
