Golden Gate Replicat process may abend for hundreds of reasons, and the situation depends from scenario to scenario.
Consider this as a new setup and added parameters/configuration of Replicat and tried to start the replicat, and you observed the below output from the report.
*********************************************************************** * ** Run Time Statistics ** * *********************************************************************** 2022-06-07 16:50:36 INFO OGG-02932 Reading /u01/app/oracle/product/OGG_19.1.0/ogghome_1/dirdat/st000000000, curre nt SEQNO 0, RBA 3,423, 0 records, m_file_seqno = 0, m_file_rba = 3,756. Report at 2022-06-07 16:50:36 (activity since 2022-06-07 16:50:31) Integrated Replicat Statistics: Total transactions: 0 Redirected: 0 Replicated procedures: 0 DDL operations: 0 Stored procedures: 0 Datatype functionality: 0 Operation type functionality: 0 Event actions: 0 Direct transactions ratio: 0% No records were replicated. Last log location read: FILE: /u01/app/oracle/product/OGG_19.1.0/ogghome_1/dirdat/st000000000 SEQNO: 0 RBA: 3423 TIMESTAMP: 2022-06-07 16:43:04.000845 EOF: NO READERR: 0 2022-06-07 16:50:36 ERROR OGG-01668 PROCESS ABENDING. CACHE OBJECT MANAGER statistics
After reviewing identified as the mapping statements for tables are incorrect. The original mapping syntax is below.
ORA-X1:(oracle):PRODS:/u01/app/oracle/product/OGG_19.1.0/ogghome_1> cat dirprm/map_statements.inc Map SCOTT.DB_ADRESSE, target SCOTT.DB_ADRESSE, Comparecols (on update all, on delete all), Resolveconflict ( updaterowexists, (default, Discard)), Resolveconflict ( insertrowexists, (default, Discard)), Resolveconflict ( deleterowexists, (default, Discard)), Resolveconflict ( deleterowmissing, (default, Discard)), Resolveconflict ( insertrowmissing, (default, Discard));
from the above syntax, the last line was found to be incorrect, and this should be corrected from insertrowmissing to updaterowmissing
ORA-X1:(oracle):PRODS:/u01/app/oracle/product/OGG_19.1.0/ogghome_1> cat dirprm/map_statements.inc
Map SCOTT.DB_ADRESSE, target SCOTT.DB_ADRESSE,
Comparecols (on update all, on delete all),
Resolveconflict ( updaterowexists, (default, Discard)),
Resolveconflict ( insertrowexists, (default, Discard)),
Resolveconflict ( deleterowexists, (default, Discard)),
Resolveconflict ( deleterowmissing, (default, Discard)),
Resolveconflict ( updaterowmissing, (default, Discard));
After changing started replicat started without any issues anymore.
Refer to the Oracle Documentation for more information https://docs.oracle.com/goldengate/1212/gg-winux/GWUAD/conflict_resolution.htm#GWUAD318
