Leo is Sunny @_@
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 […]
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 […]
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 […]
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”, […]
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 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 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 […]
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 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 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 […]