As part of the Golden Gate Setup added the extract parameters and configuration, below is the information.
GGSCI (ORA-X1 as ggadmin@PRODS) 3> view param inext1 extract inext1 userid ggadmin@PRODS, password Welcome1 tranlogoptions integratedparams (max_sga_size 2G) exttrail /dirdat/et logallsupcols tranlogoptions updaterecordformat full warnlongtrans 4h, checkinerval 10m, skipemptytrans br broff tranlogoptions excludetag 00112233445566778899AABBCCDDEEFF tranlogoptions excludeuser ggadmin tranlogoptions includeregionid statoptions resetreportstats report at 00:01 reportrollover at 00:03 reportcount every 1 minutes, rate include dirprm/includefile.inc
Now, I tried to start the extract process and immediately failed with the below error.
GGSCI> start inext1 ... .. . 2021-06-06 07:49:45 ERROR OGG-00662 OCI Error ORA-23605: invalid value "2G" for GoldenGate parameter MAX_SGA_SIZE ORA-06512: at "SYS.DBMS_XSTREAM_GG_ADM", line 1056 ORA-06512: at "SYS.DBMS_XSTREAM_ADM", line 1593 ORA-06512: at "SYS.DBMS_LOGREP_UTIL", line 555 ORA-06512: at "SYS.DBMS_CAPTURE_ADM_IVK", line 874 ORA-06512: at "SYS.DBMS_XSTREAM_ADM", line 1582 ORA-06512: at "SYS.DBMS_XSTREAM_GG_ADM", line 1050 ORA-06512: at line 1 (status = 23605). The assigned max_sga_size value is unrecognized by the golden gate, hence changing the value from 2G to 2048. After started the extract process, it was started without issues.
GGSCI (ORA-X1 as ggadmin@PRODS) 10> start inext1 Sending START request to MANAGER ... EXTRACT INEXT1 starting GGSCI (ORA-X1 as ggadmin@ PRODS) 11> info all Program Status Group Lag at Chkpt Time Since Chkpt MANAGER RUNNING EXTRACT RUNNING INEXT1 00:00:00 00:01:24 EXTRACT STOPPED PMP1 00:00:00 09:32:22 REPLICAT STOPPED INREP1 00:00:00 09:21:59
