OGG-02271 Decryption key is missing and record can not be filtered out

Symptoms: 2020-07-06 16:37:35 INFO OGG-05520 Input trail file encryption: AES256. Source Context : SourceModule : [er.extract.processPumploop] SourceID : [er/extract/processPumpLoop.cpp] SourceMethod : [ggs::er::ExtractContext::processPumpLoop] SourceLine : [924] ThreadBacktrace : [13] elements : [E:\OGG4MSSQL\gglog.dll(??1CContextItem@@UEAA@XZ)] : [cŒ‚û] : [E:\OGG4MSSQL\gglog.dll(?_MSG_@@YAPEAVCMessage@@PEAVCSourceContext@@HW4MessageDisposition@CMessageFactory@@@Z)] : [E:\OGG4MSSQL\extract.exe(ERCALLBACK)] : [E:\OGG4MSSQL\extract.exe(ERCALLBACK)] : [E:\OGG4MSSQL\extract.exe(ERCALLBACK)] : [E:\OGG4MSSQL\extract.exe(_ggTryDebugHook)] : [C:\Windows\SYSTEM32\ntdll.dll(RtlUserThreadStart)] : [E:\OGG4MSSQL\extract.exe(_ggTryDebugHook)] : [E:\OGG4MSSQL\extract.exe(VAMVersion)] : [E:\OGG4MSSQL\extract.exe(VAMVersion)] : [C:\Windows\SYSTEM32\ntdll.dll(RtlUserThreadStart)] : [C:\Windows\SYSTEM32\ntdll.dll(RtlUserThreadStart)] […]

Cassandra timeout during write query at consistency ONE

  1         Symptoms The OGG report file show   timout exception of connecting to Cassandra, so the OGG replicat was abended.   2019-03-25 11:20:36  INFO    OGG-06510  Using the following key columns for target table APMT_CONTAINER_SERVICE_BLUE.CONTAINER_HISTORY: TERMINAL_ID, CONTAINER_NUMBER, EVENT_GKEY, VISIT_STATE.                 368147 records processed as of 2019-03-25 11:20:37 (rate 0,delta 0)               639799 records processed as […]

Chnage TLS Cipher suites with ./oggServiceConfig

  1         Chnage TLS Cipher suites with ./oggServiceConfig https://github.com/oracle/docker-images/tree/master/OracleGoldenGate/bin   [oracle@OGGVM conf]$ cd /u02/ogg/OGG/var/lib/conf [oracle@OGGVM conf]$ more adminsrvr-config.dat |python -m json.tool                     “cipherSuites”: [                         “TLS_RSA_WITH_AES_256_CBC_SHA”,                         “TLS_RSA_WITH_AES_128_CBC_SHA”,                         “SSL_RSA_WITH_RC4_128_SHA”,                         “SSL_RSA_WITH_RC4_128_MD5”,                         “SSL_RSA_WITH_3DES_EDE_CBC_SHA”                     ],   oracle@linuxvm01:/ogg/app/oracle/oggma/12.3.0.1.4/DEPLOYMENT_LOCAL/LOCAL/var/lib/conf % more adminsrvr-config.dat |python -m json.tool                     “cipherSuites”: [                         “TLS_RSA_WITH_AES_256_CBC_SHA”,                         “TLS_RSA_WITH_AES_128_CBC_SHA”,                         “SSL_RSA_WITH_RC4_128_SHA”,                         “SSL_RSA_WITH_RC4_128_MD5”,                 […]

alter extract begin timestamp get OGG-08100

432452405 432485451 1 1 1390 +ARCHDG/ORCL/ARCHIVELOG/2019_03_27/thread_1_seq_13 NO A  90.310.1004009429  433196395 433682358 1 1 1397 +ARCHDG/ORCL/ARCHIVELOG/2019_03_27/thread_1_seq_13 NO A  97.267.1004042105  434220075 434511477 1 1 1399 +ARCHDG/ORCL/ARCHIVELOG/2019_03_28/thread_1_seq_13 NO A  99.312.1004087427  439918452 440590238 1 1 1410 +ARCHDG/ORCL/ARCHIVELOG/2019_03_31/thread_1_seq_14 NO A  10.285.1004343531  441201995 441875468 1 1 1412 +ARCHDG/ORCL/ARCHIVELOG/2019_03_31/thread_1_seq_14 NO A  12.284.1004379771  442542323 443122491 1 1 1414 +ARCHDG/ORCL/ARCHIVELOG/2019_04_01/thread_1_seq_14 NO A  14.278.1004414591  443122491 […]

Issue: OGG-01416  File KA000000028, with format RELEASE 9.0/9.5, does not match current format specification of RELEASE 12.3

  Issue: OGG-01416  File KA000000028, with format RELEASE 9.0/9.5, does not match current format specification of RELEASE 12.3   1           SYMPTOMS: OGG (https://linuxvm01:18100 LOCAL) 20> info EXT01 detail EXTRACT    EXT01  Last Started 2019-03-18 12:58   Status ABENDED Checkpoint Lag       58:45:47 (updated 47:38:58 ago) Log Read Checkpoint  Oracle Integrated Redo Logs                      2019-03-16 01:21:11                      SCN 0.404133134 […]

OGG4DB2 for IBM i PURGEOLDEXTRACTS not working

  OGG4DB2 for IBM i PURGEOLDEXTRACTS not working 1.1        SYMPTOMS We set PURGEOLDEXTRACTS for mgr process in OGG4DB2, but purge action not working to clean down the old trail files. > view params mgr Port 7809 PURGEOLDEXTRACTS /GoldenGate/dirdat/SA*, USECHECKPOINTS, MINKEEPDAYS 7 > pwd /GoldenGate/dirdat > ls -lrt total 2752512 -rw-r—– 1 datahub 0 199998879 16 […]

OGG-02198 Incompatible record (logical EOF) in trail file

OGG-02198 Incompatible record (logical EOF) in trail file Symptoms: 2019-10-17 14:48:43 ERROR OGG-02171 Error reading LCR from data source. Status 509, data source type 0. Source Context : SourceModule : [gglib.ggtrail.TrailDataSource] SourceID : [/scratch/aime/adestore/views/aime_adc4150505/oggcore/OpenSys/src/gglib/ggtrail/TrailDataSource.cpp] SourceMethod : [checkLogicalEOF] SourceLine : [3829] ThreadBacktrace : [15] elements : [/ogg/app/oracle/ogg4bd/12.3.2.1.0/libgglog.so(CMessageContext::AddThreadContext()+0x1e) [0x7f9a8d6230ae]] : [/ogg/app/oracle/ogg4bd/12.3.2.1.0/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, …)+0x6ac) [0x7f9a8d6139b c]] : […]

Example: OGG Microservice Architecture RestAPI Commands

–Get the information of Distribution Path curl -u oggadmin:oracle -k -H “Content-Type: application/json” -H “Accept: application/json” -X GET http://linuxvm01:9102/services/v2/sources curl -u oggadmin:Oracle1! -k -H “Content-Type: application/json” -H “Accept: application/json” -X GET https://127.0.0.1:9102/services/v2/sources curl -u oggadmin:Oracle1! -k -H “Content-Type: application/json” -H “Accept: application/json” -X GET https://linuxvm01:19102/services/v2/sources/DIST01| python -m json.tool curl -u oggadmin:Oracle1! -k -H “Content-Type: application/json” […]

OGG-00868 Error code 1291, error message ORA-01291 missing logfile

Symptoms: 2019-07-29 10:15:56 INFO OGG-02248 Logmining server DDL filtering enabled. Source Context : SourceModule : [er.redo.oraxo] SourceID : [/scratch/aime/adestore/views/aime_adc00jza/oggcore/OpenSys/src/app/er/redo/oracle/redooraix.c] SourceMethod : [REDOORAIX_abend_if_missing_logfile] SourceLine : [8360] ThreadBacktrace : [16] elements : [ng::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*)] : [/ogg/app/oracle/oggma/12.3.0.1.4/bin/extract(ggs::gglib::MultiThreading::MainThread::Run(int, char**))] : [/ogg/app/oracle/oggma/12.3.0.1.4/bin/extract(ggs::gglib::MultiThreading::MainThread::Run(int, char**))] : [/ogg/app/oracle/oggma/12.3.0.1.4/bin/extract()] : [/ogg/app/oracle/oggma/12.3.0.1.4/bin/extract(ggs::er::OraTranLogDataSource::setup())] : [/ogg/app/oracle/oggma/12.3.0.1.4/bin/extract(ggs::gglib::MultiThreading::MainThread::Run(int, char**))] : [/ogg/app/oracle/oggma/12.3.0.1.4/bin/extract(ggs::er::OraTranLogDataSource::setup())] : [/ogg/app/oracle/oggma/12.3.0.1.4/bin/extract(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*)] : [/ogg/app/oracle/oggma/12.3.0.1.4/bin/extract(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*)] : [/ogg/app/oracle/oggma/12.3.0.1.4/bin/extract()] : [/ogg/app/oracle/oggma/12.3.0.1.4/bin/extract(ggs::gglib::MultiThreading::MainThread::ExecMain())] : […]