Leo is Sunny @_@
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 […]
OGG4BD to send boolean data to Cassandra –Create target table in Cassandra CREATE TABLE TARGET.TARGET01 ( col1 text PRIMARY KEY, col5 float, col2 bigint, col3 timestamp, col4 boolean ) WITH bloom_filter_fp_chance = 0.01 AND caching = {‘keys’: ‘ALL’, ‘rows_per_partition’: ‘NONE’} AND comment = ” AND compaction = {‘class’: ‘org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy’, ‘max_threshold’: ’32’, ‘min_threshold’: ‘4’} AND compression […]
OGG-05259 The Extract’s recovery checkpoint LSN 00009da1:0057deff:0004 is not in the cdc.lsn_time_mapping table of database ‘test’. Symptoms: 2019-10-08 14:33:14 INFO OGG-05257 For CDC tuning best practices, please see https://technet.microsoft.com/en-us/library/dd266396%28v=sql.100%29.aspx. 2019-10-08 14:33:14 WARNING OGG-05292 The Oracle GoldenGate capture job is running on database test with NOMANAGECDCCLEANUP. Oracle GoldenGate will not purge CDC enabled tables. Source Context […]
OGG Replicat Abends On LOB Data. OGG Error: OGG-01028: Unexpected LOB Record Or Record Fragment In … (Trail File) SYMPTOMS: 2018-10-06 18:13:43 ERROR OGG-02188 Unexpected LOB record or record fragment in /trail/DL000000016, rba 1,750. CAUSE: replicat altered to start on trail where the first record is a LOB and not the base record INSERT/UPDATE/DELETE SOLUTION: […]
Install OGG for Sql Server Prepare Check sqlserver veriosn SELECT @@version Microsoft SQL Server 2016 (SP1-CU10-GDR) (KB4293808) – 13.0.4522.0 (X64) Jul 17 2018 22:41:29 Copyright (c) Microsoft Corporation Enterprise Edition: Core-based Licensing (64-bit) on Windows Server 2016 Datacenter 10.0 <X64> (Build 14393: ) (Hypervisor) Requirements https://docs.oracle.com/goldengate/c1230/gg-winux/OGGIN/installing-sql-server1.htm#OGGIN-GUID-EB7DD65D-4344-4F72-9B45-18631536AC84 For SQL Server 2016, use or install the Microsoft […]
MacBook-Air:.docker $ docker login –username=leosunnyPassword: Login Succeeded MacBook-Air:.docker $ docker pull leosunny/goldengate4bd:12.3.2.1.0 MacBook-Air:~ $ docker run –name=ogg4bd -d leosunny/goldengate4bd:12.3.2.1.0 MacBook-Air:~ $ docker exec -it –user oracle ogg4bd bash [oracle@64eeba6b8b09 ogg]$ pwd /u01/app/ogg [oracle@64eeba6b8b09 ogg]$ ggsci Oracle GoldenGate for Big Data Version 12.3.2.1.0 (Build 018) Oracle GoldenGate Command Interpreter Version 12.3.0.1.2 OGGCORE_OGGADP.12.3.0.1.2_PLATFORMS_180430.2321 Linux, x64, 64bit (optimized), […]