OGGMA for Oracle – LeoSunny

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

October 13, 2020 leosunny

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

October 13, 2020 leosunny

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:

October 7, 2020October 8, 2020 leosunny

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

September 29, 2020 leosunny

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

Oracle GoldenGate(12.3, 19) Trail FORMAT RELEASE

September 9, 2020 leosunny

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

Chnage TLS Cipher suites with ./oggServiceConfig

November 1, 2019May 4, 2020 leosunny

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

November 1, 2019November 1, 2019 leosunny

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

November 1, 2019 leosunny

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

Example: OGG Microservice Architecture RestAPI Commands

October 14, 2019October 14, 2019 leosunny

–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

October 14, 2019 leosunny

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())] : […]