OGG 19.1 certification matrix

https://www.oracle.com/technetwork/middleware/ogg-19-1-0-0-0-cert-matrix-5491855.xls   Product Release Processor Type OS Version Oracle GoldenGate 19.1.0.0.200714+ Microsoft Windows x64 (64-bit) 2012 / 2012R2 / 2016 / 2019 Oracle GoldenGate 19.1.0.0.200414+ Microsoft Windows x64 (64-bit) 2012 / 2012R2 / 2016 / 2019 Oracle GoldenGate 19.1.0.0.200414+ Microsoft Windows x64 (64-bit) 2019    

this type of principal cannot be impersonated, or youdo not have permission

Symptoms: GGSCI> delete trandata dbo.* 2020-12-08 11:53:54 WARNING OGG-00782 Error in changing transaction logging for table: dbo.tab. 2020-12-08 11:53:54 ERROR OGG-05345 Failed to disable change data capture for table ‘dbo.tab in the database ‘tstdb’. SQL error: 15517: [Microsoft][ SQL Server Native Client 11.0][SQL Server]Cannot execute as the database principal because the principal “cdc” does not […]

ALLOWOUTPUTDIR – Fix OGG-25127 XXXX not in any allowed output directories.

Symptoms: Pump report: 2020-11-20 19:05:58 ERROR OGG-25127 Received an error reply requesting a graceful shutdown. (Reply received is ‘GSOutput file /u01/app/ogg/dirdat/target/TT000000 is not in any allowed output directories.’.). Cause: With this parameter, we can authorize GoldenGate to use a different location than its home to store trail files. If you need different directories for your […]

OGGMA: Create distribution path via adminclient commands

ADD DISTPATH PUMP01 SOURCE trail://127.0.0.1:5100/services/v2/sources?trail=/source/SS TARGET wss://<targetIP>:6100/services/v2/targets?trail=/target/TT ALTER DISTPATH PUMP01 OPTIONS AUTORESTART RETRIES 10 delay 2 ALTER DISTPATH PUMP01 TARGET SIZEMB 200 ALTER DISTPATH PUMP01 TARGET SEQLEN 9 ALTER DISTPATH PUMP01 OPTIONS EOFDELAY 100

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