Parallel Integrated replicat performance degradation after upgrade to GoldenGate 21.14 (Doc ID 3039682.1)

Last updated on AUGUST 19, 2024

Applies to:

Symptoms

The performance of a parallel integrated replicat process severely reduces after the deployment is upgraded to GoldenGate 21.14.

The replicat statistics show a very large number of transactions being retried:

*** Total statistics since 2024-07-12 11:30:16 ***
Total transactions 16025.00
Transactions retried 16025.00

Enabling activity logging for the replicat for a short period of time show the ffollowing error:

2024-07-11 Thu UTC 02:46:52.424 {%?Y?-Applier::PRErrorFallback throw ApplierFallbackException(APPLIER_ERROR_FALLBACK) Error 26697 to retry: ORA-26697: LCR contains extra column 'SYS_NC00005$'
ORA-14148: DML and DDL operations are not directly allowed on the guard-column.-2024-07-11 Thu UTC 02:46:52.424 %?H?:PRErrorFallback:151290} WARN |er.rollback |main| 4236 er/replicat/coord/Applie {2} | Applier::PRErrorFallback throw ApplierFallbackException(APPLIER_ERROR_FALLBACK) Error 26697 to retry: ORA-26697: LCR contains extra column 'SYS_NC00005$'

ORA-14148: DML and DDL operations are not directly allowed on the guard-column.
2024-07-11 Thu UTC 02:46:52.430 {%?Y?-Throwing fallback exception of type 1 from:
/u01/ogg/bin/replicat(ggs::Coord::ApplierFallbackException::ApplierFallbackException(ggs::Coord::ApplierFallbackType))
/u01/ogg/bin/replicat(ggs::Coord::Applier::PRErrorFallback())
/u01/ogg/bin/replicat()
/u01/ogg/bin/replicat(ggs::Coord::Applier::SendLCRBuffer(unsigned char*, unsigned long, bool))
/u01/ogg/bin/replicat(ggs::Coord::Applier::ProcessTransactionBatch())
/u01/ogg/bin/replicat(ggs::Coord::Applier::ProcessFlatLCRs())
/u01/ogg/bin/replicat(ggs::Coord::Applier::OnLoopStart())
/u01/ogg/bin/replicat()
/u01/ogg/bin/replicat(ggs::er::ReplicatContext::run())
/u01/ogg/bin/replicat()
/u01/ogg/bin/replicat(ggs::gglib::MultiThreading::MainThread::ExecMain())
/u01/ogg/bin/replicat(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*))
/u01/ogg/bin/replicat(ggs::gglib::MultiThreading::MainThread::Run(int, char**))
/u01/ogg/bin/replicat(main)
/lib64/libc.so.6(__libc_start_main)
/u01/ogg/bin/replicat()-2024-07-11 Thu UTC 02:46:52.430 %?H?:ApplierFallbackException:151291} DEBUG|er.replicat.coord.applier |main| 298 er/replicat/coord/Applie {2} | Throwing fallback exception of type 1 from

Checking the tables containing a column with the above name shows the column belongs to the replicat checkpoint table.

Changes

 Upgrade GoldenGate to 21.14

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.