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

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

GG-02022 Logmining server does not exist on this Oracle database

GG-02022 Logmining server does not exist on this Oracle database Symptoms: 2019-07-29 11:49:40 ERROR OGG-02022 Logmining server does not exist on this Oracle database. Cause: The extract is not registered in DB SOLUTION: 1)Register extract 2)Add extract 3)Start extract Set the ORACLE_HOME ORACLE_SID using the SETENV parameter in the extract parameter file Below is the […]

OGG-02191 Incompatible record 104 in /trail/TR000000003, rba 1,589

OGG-02191 Incompatible record 104 in /trail/TR000000003, rba 1,589 when getting trail header. Symptoms: 2019-10-13 20:48:53 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_adc00jza/oggcore/OpenSys/src/gglib/ggtrail/TrailDataSource.cpp] SourceMethod : [readNextTrailRecord] SourceLine : [2687] ThreadBacktrace : [14] elements : [/ogg/oggma_12.3.0/bin/replicat(ggs::gglib::MultiThreading::MainThread::Run(int, char**))] : [/ogg/oggma_12.3.0/bin/replicat(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*))] : [/ogg/oggma_12.3.0/bin/replicat(_ZN3ggs5gglib14MultiThreading10MainThread3RunEiPPc+0xb5) […]

Test: OGG_extarct&reaplict with PK and duplicates

Test: OGG_extarct&reaplict with PK and duplicates 1. Source table without PK and OGG extract set the PK ”PKEY” 2. Target Table has PK “PKEY” and OGG replicat the PK ”PKEY” –Prepare the testing tables CREATE TABLE SOURCE.TST_TAB01 ( PKEY NUMBER(19) NOT NULL, TIME_IN TIMESTAMP(6), TIME_OUT TIMESTAMP(6), OGG_DATETIME DATE ) TABLESPACE USERS PCTUSED 0 PCTFREE 10 […]