leosunny – LeoSunny

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, 2019November 1, 2019 leosunny

1 Chnage TLS Cipher suites with ./oggServiceConfig https://github.com/oracle/docker-images/tree/master/OracleGoldenGate/bin [oracle@scrbcdhnl006918 conf]$ pwd /u02/ogg/TICOGG/var/lib/conf [oracle@scrbcdhnl006918 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]] : […]

Create and Drop type in Oracle DB

October 16, 2019 leosunny

create or replace TYPE “ora_typ_01” AS OBJECT ( delievery_order_number VARCHAR2(20), haulage_number VARCHAR2(20), count_issued NUMBER, count_total NUMBER, document_status VARCHAR2(10) ) Type ora_typ_01 compiled CREATE OR REPLACE EDITIONABLE TYPE ora_typ_01 AS OBJECT ( delievery_order_number VARCHAR2(20), haulage_number VARCHAR2(20), count_issued NUMBER, count_total NUMBER, document_status VARCHAR2(10) ) Type ORA_TYP_01 compiled select * from dba_objects where object_type=’TYPE’ and owner=’LEOSUNNY’; LEOSUNNY ora_typ_01 […]

Archive log mining steps(logminer to html)

October 16, 2019October 16, 2019 leosunny

1.1 Archive log mining steps(logminer to html): 1.1.1 STEP 1: Execute the below query on the target db alter session set nls_date_format=’dd-mm-yyyy hh24:mi’; select name,thread#,sequence#,first_time,next_time from v$archived_log where first_time between to_date(’05-05-2019 16:00′) and to_date(’05-05-2019 20:00′); <<<<<<<<<<<<<<<<Put the time when the record was inserted on source around example around 2019/05/05 17:43:56.030.651, we need to find corresponding […]