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 |
