While starting the datapump in goldengate version 12.2.0 , you may get below error.   2016-04-14 15:14:39  ERROR   OGG-01031  There is a problem in network communication, a remote file problem, encryption keys for target and source do not match (if using ENCRYPT) or an unknown error […]

Problem: Goldengate extract may abend with the error OGG-01028  Formatting error on.   Source Context :   SourceModule            : [er.redo.ora]   SourceID                : [/scratch.local/mmar/view_storage/mmar_14516066/oggcore/OpenSys/src/app/er/redo/oracle/redoora.c]   SourceFunction          : [REDOORA_handle_format_error SourceLine              : [8949] 2016-03-30 18:13:34  ERROR   OGG-01028  Formatting error on: table name SIEBEL.S_CONTACT, rowid AABjIBAAgAAC/svAAL, XID 12.16.3440952, position (Seqno 7643, RBA 541369824). Invalid numeric data detected. Error converting numeric […]

                        While starting the extract it may get abend with the error  like OGG-01841  CACHESIZE TOO SMALL: .    2016-03-29 11:37:08  ERROR   OGG-01841  CACHESIZE TOO SMALL: 64M  MINIMUM REQUIRED: 128M   VM found: 128M Make sure there is sufficient swap space and make sure CACHEMGR CACHESIZE […]

 If you wish to disable DDL replication in goldengate, then you need to run few scripts from GG_HOME.     SQL> @ddl_remove.sql DDL replication removal script. WARNING: this script removes all DDL replication objects and data. You will be prompted for the name of a schema for the Oracle GoldenGate database objects. NOTE: The schema […]

                       The Manager process must be running on both Source and target systems. The Manager process starts Oracle GoldenGate processes, performs trail management, and starts dynamic processes.Oracle GoldenGate Installation has one manager process which supports multiple Extract and Replicat processes. We can simply say. without […]

Introduction to Oracle GoldenGate Oracle GoldenGate enables the exchange and manipulation of data at the transaction level among multiple, heterogeneous platforms. Oracle GoldenGate Architecture allows to replicate selected data, transactional changes, and changes to DDL. It supports various business requirements like High Availability, Initial Load and Database Migration etc.   Oracle GoldenGate Supported Topologies   […]

                Installing goldengate is very easy.  We are using V11.2.1.0.3 for Oracle 11g on Linux x86-64 for this Tutorial. Below steps need to be done on both source and targer side, i.e on extract side and replicate side. If you are new to golden gate Read – Introduction to golden […]

                  in goldengate 12c, oracle introduced universal installed(OUI) for installation, which makes it simpler.The installation need to be done on both source and target hosts, where gg process will be running. Lets see the steps.          1. Download the goldengate software for the appropriate […]