While register the golden gate extract process causing the following error in alert log file.
Integrated Extract need memory if 3 process running then 3 GB memory it needed.
$register extract ext01 database
Error OGG-00221 cannot register or unregister Extract ext01 because of the following SQL error: OCI Error 4,031.
-- On checking the alert log getting the following error:
ORA-04031: unable to allocate 61536 bytes of shared memory ("shared pool","GGS_DDL_TRIGGER_BEFORE")
Cause: Error occurred due to less size allocated to streams pool in SGA.
Solution: Check the memory parameter first. Increase the memory parameter first. Then Increase the memory of stream pool.
SQL> show parameter memory
— Increase the memory target and max parameter
SQL> show parameter sga
— Increase the sga target and max parameter
SQL>alter system set streams_pool_Size =500m;