leosunny – LeoSunny

OGG-02271 Decryption key is missing and record can not be filtered out

July 6, 2020 leosunny

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

May 7, 2020May 7, 2020 leosunny

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)

January 21, 2020January 22, 2020 leosunny

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

November 1, 2019 leosunny

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

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

OGG4DB2 for IBM i PURGEOLDEXTRACTS not working

November 1, 2019November 1, 2019 leosunny

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

Compress option of OGG

October 28, 2019 leosunny

We can’t generate compressed trail files now. you can only configure Oracle GoldenGate to compress trail files in its extract pump process and distpath where you can specify COMPRESS in the RMTHOST option. For example, RMTHOST localhost, mgrport 7789, compress, compressthreshold 512 COMPRESS This option is valid for online or batch Extract […]

OGG-02198 Incompatible record (logical EOF) in trail file

October 18, 2019October 18, 2019 leosunny

OGG-02198 Incompatible record (logical EOF) in trail file Symptoms: 2019-10-17 14:48:43 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_adc4150505/oggcore/OpenSys/src/gglib/ggtrail/TrailDataSource.cpp] SourceMethod : [checkLogicalEOF] SourceLine : [3829] ThreadBacktrace : [15] elements : [/ogg/app/oracle/ogg4bd/12.3.2.1.0/libgglog.so(CMessageContext::AddThreadContext()+0x1e) [0x7f9a8d6230ae]] : [/ogg/app/oracle/ogg4bd/12.3.2.1.0/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, …)+0x6ac) [0x7f9a8d6139b c]] : […]