Exception Code: OGG-01232 (DISTPATH01) cased by Network Issue:

Exception Code: OGG-01232 (DISTPATH01) cased by Network Issue: Symptom: 2018-09-17T22:50:06.996+0000 ERROR| SSL readBuffer error: 113. (DISTPATH01) 2018-09-17T22:50:06.996+0000 ERROR| Secure Comm Error : SSL IO error (28862). (DISTPATH01) 2018-09-17T22:50:06.996+0000 ERROR| Secure Comm Error : SSL IO error (28862). (DISTPATH01) 2018-09-17T22:50:07.233+0000 ERROR| Exception Code: OGG-01232 (DISTPATH01) 2018-09-17T22:50:07.233+0000 ERROR| Exception Message: Receive TCP params error: TCP/IP error 10351 […]

OGG-10351 Certificate validation error: Unacceptable certificate from in OGGMA 19.1

OGG-10351 Certificate validation error: Unacceptable certificate from <IP> in OGGMA 19.1 Symptom: 2020-10-07T13:50:40.095+0000 INFO | Cipher installed: 0x003d – ‘TLS_RSA_WITH_AES_256_CBC_SHA256’. (DISTPATH01) 2020-10-07T13:50:40.095+0000 INFO | Cipher installed: 0x009d – ‘TLS_RSA_WITH_AES_256_GCM_SHA384’. (DISTPATH01) 2020-10-07T13:50:40.106+0000 INFO | Using configured client REQUIRED authentication mode ‘client_server’ -> AuthenticateClient (nzosEstablishTrustInClient). (DISTPATH01) 2020-10-07T13:50:40.107+0000 INFO | Using configured server authentication mode: ‘client_server’ -> kAuthenticateServer […]

Top errors in Oracle GoldenGate12c:

https://oraclexperto.blogspot.com/2018/08/top-7-errors-in-oracle-goldengate12c.html https://docs.oracle.com/goldengate/1212/gg-winux/GIORA/setup.htm#GIORA367 https://www.vitalsofttech.com/enable_goldengate_replication-is-not-set-to-true/ OGG (https://oggvm01:9001 DEPLOY as SRCOGGCDB@CDB/CDB$ROOT) 7> register extract ext01 DATABASE CONTAINER (PDB01) 2020-10-07T15:54:23Z ERROR OGG-02058 The Oracle source database is not configured properly to support integrated capture. The following configuration error must be fixed: No minimum supplemental logging is enabled. SQL> archive log list Database log mode Archive Mode Automatic archival Enabled […]

Distribution Path failed with ENCKEY and Filter rule

Distribution Path failed with ENCKEY and Filter rule Symptom: OGG MA12.3 2016-09-29T13:00:36.413+0000 ERROR| Exception Code: OGG-02271 (DISTPATH01) 2016-09-29T13:00:36.413+0000 ERROR| Exception Message: Decryption key is missing and record can not be filtered out. (DISTPATH01) 2016-09-29T13:00:36.413+0000 ERROR| Exception, killing the path DISTPATH01 (DISTPATH01) 2016-09-29T13:00:36.454+0000 WARN | Path killed. (DISTPATH01) Cause: Filter rule is using in distpath with […]

Use OPatch to check Oracle GoldenGate version

Use OPatch to check Oracle GoldenGate version Recently on I was strolling the OTN message boards and came across a question about identifying the version of Oracle GoldenGate using OPatch. This was the second time I came across this question; with that I decided to take a look and see if Oracle GoldenGate information could […]

OGG-05258 Could not retrieve the current Change Data Capture settings for database testdb

Symptom: 2018-09-11 02:00:06 INFO OGG-05264 Opening DSN connection: testdb, Server: mssqlvm01, Database: testdb. 2018-09-11 02:00:06 WARNING OGG-05265 The SQL Agent on server mssqlvm01 is not running. SQL Server CDC requires that the SQL Agent be running to capture change records. Source Context : SourceModule : [ggmssqlcdcvam.mssqlcdctable] SourceID : [ggmssqlcdcvam/MSSqlCDCTable.cpp] SourceMethod : [mssqlcdcvam::MSSqlCDCJobSettings::ReportCDCCaptureJob] SourceLine : [668] […]

Oracle GoldenGate(12.3, 19) Trail FORMAT RELEASE

1         Can a 12.3 GoldenGate replicat process consume trail files from GG 12.1? https://community.oracle.com/message/15055722#15055722 https://community.oracle.com/message/14426682#14426682   When source is ogg v12.3.x and target is ogg v12.1.x , you need to have the trail files written in the 12.1 format so that the ogg v12.1. replicat could consume the ogg v12.3.x trail file.So you need to […]

OGG Manager could not purge old trail file

OGG Manager could not purge old trail file Symptom: manager could not purge old trail files while not extract or replicat is existing in this ogg, because this ogg is only receiving trail from source and cascade data to target. GGSCI (OGGVM01) 2> edit param mgr PURGEOLDEXTRACTS /u01/app/ogg/dirdat/DD*, USECHECKPOINTS, MINKEEPDAYS 30 Solution: GGSCI (OGGVM01) 2> […]

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 […]