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

Remote Clone PDB with error ORA-17628

Remote Clone PDB with error ORA-17628 Syptoms: SQL> CREATE PLUGGABLE DATABASE PTRG FROM PSRC@clone_link file_name_convert=(‘+DATA_TRG’,’+DATA_SRC’); CREATE PLUGGABLE DATABASE PTRG FROM PSRC@clone_link file_name_convert=(‘+DATA_TRG’,’+DATA_SRC’) * ERROR at line 1: ORA-17628: Oracle error 17630 returned by remote Oracle server ORA-17630: Mismatch in the remote file protocol version client server Cause: TRG: 12.2.0.1.190115 SRC: 12.1.0.2.180116 This appears to be […]

Fixied: Cassandra CQLSH OperationTimedOut error=Client request timeout. See Session.execute[_async](timeout)

root@0102469423f8:/# cqlsh cassandrahost01 9042 -u cass_srvc Password: Connected to CassandraCluster at cassandrahost01:9042. [cqlsh 5.0.1 | Cassandra 3.11.1.2323 | CQL spec 3.4.4 | Native protocol v4] Use HELP for help. cass_srvc@cqlsh> select count(*) from app_blue.cont_history; OperationTimedOut: errors={‘10.115.66.55’: ‘Client request timeout. See Session.execute[_async](timeout)’}, last_host=10.115.66.55 cass_srvc@cqlsh> exit root@0102469423f8:/# cqlsh cassandrahost01 9042 -u cass_srvc –request-timeout=6000 Password: Connected to CassandraCluster […]

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