OGG-05259 The Extract’s recovery checkpoint LSN is not in the cdc.lsn_time_mapping table of database ‘test’.

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

Configure probe to monitor Tomcat

Download tomcat https://tomcat.apache.org/download-70.cgi Install tomcat on Windows set CATALINA_HOME=F:\app\apache-tomcat-7.0.69 set JAVA_HOME=F:\app\Java\jdk1.7.0_79 start Install probe Download probe https://launchpad.net/lambdaprobe/+download https://github.com/psi-probe/psi-probe http://code.google.com/p/psi-probe/ —newest version —–>3.0.0-SNAPSHOT/ We download this version that it is psi-probe-web-3.0.0-20160603.023429-26.war Install probe on tomcat in windows   tomcat-users.xml edit $CATALINA_HOME/conf/tomcat-users.xml Example1: <role rolename=”manager-gui”/> <role rolename=”manager-script”/> <role rolename=”manager-jmx”/> <role rolename=”manager-status”/> <user username=”admin” password=”admin” roles=”manager-gui,manager-script,manager-jmx,manager-status”/> Example2 <role […]

OGG Error: OGG-01028: Unexpected LOB Record Or Record Fragment In … (Trail File)

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 in windows

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

Docker run OGG4BD to Hadoop

MacBook-Air:.docker $ docker login –username=leosunnyPassword: Login Succeeded MacBook-Air:.docker $ docker pull leosunny/goldengate4bd: MacBook-Air:~ $ docker run –name=ogg4bd -d leosunny/goldengate4bd: 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 (Build 018) Oracle GoldenGate Command Interpreter Version OGGCORE_OGGADP. Linux, x64, 64bit (optimized), […]