Oracle Goldengate 19c Learn and Master Oracle Goldengate

Professionally learn to design & implement Goldengate setup for ur customer & enterprise
Oracle Goldengate 19c Learn and Master Oracle Goldengate
File Size :
9.70 GB
Total length :
23h 12m



Ashish Agarwal


Last update




Oracle Goldengate 19c Learn and Master Oracle Goldengate

What you’ll learn

Latest and Master Oracle Goldengate Version 19c with practicals and realtime activites
Install and Download Oracle GoldenGate 19c in realtime – Decide where to Install oracle Goldengate
Issue GGSCI commands.
What are the different architectures of Goldengate and how to setup Replication
Realtime Activities to setup Oracle Goldengate processes
Configure, start, stop and monitor Change Capture and Delivery processes in Realtime
Manage Extract trails, Remote trails and files using Data Pump and Replicat
How to design and analyse Oracle Goldengate for your projects – Things to consider and how to do seggregation
Prerequisites to download and setup Oracle Goldengate 19c
How to check Oracle Goldengate Certification matrix
Comprehend and Create Goldengate process parameter files
Different types of extracts and Replicats available for configuration in 19c
Oracle Goldengate how to perform Silent Installation
Setting up Oracle database and preparing source and target database for Goldengate Replication
Oracle Goldengate 19c New features
Oracle Goldengate 19c: Troubleshooting – OGG common issues troubleshooting,approach and strategy
Oracle Goldengate 19c: Tuning – Perform tuning of Manager, Extract and Replicate.
Identify what causes slow startups.
Monitor lag and statistics.
Oracle Goldengate Bidirectional Replication- Setup in realtime with considreations and things to keep in mind
Bidirectional Auto CDR – Oracle Goldengate new feature-
Diagnose and tune the Integrated Extract and Integrated Replicat and usage and benefits
Parallel Replicat – Oracle Goldengate new feature setup in realtime and usage and benefits
Heartbeat Table – Oracle Goldengate new feature setup in realtime and usage and benefits
Performane Matrix server(PMSRVR)- Oracle Goldengate new feature setup in realtime and usage and benefits
DDl Replication setup in realtime and usage and benefits
What is Supplemental logging – benefits and usage
Create Oracle Goldengate Credential Store
Goldengate architecture and Process data flow
Difference between Time since Checkpoint and Lag at Checkpoint
Goldengate process status and trail file switchover scenarios
How to autostart Goldengate processes realtime
Oracle Goldengate concepts and components
Oracle Goldengate Initial Load and File to Replicat initial load in realtime
Zero downtime upgradation and migration Strategy
Realtime usage and benefits to show how GG could be used as business intelligence tool along with informatica/ODI
Data Filteration and transformation
How to add new table into already running OGG configuration
Oracle Goldengatesecurity in realtime and how to perform trail file Encryption
How to read Goldengate trail files using Logdump utility in realtime
How to put description to Oracle Gldengate new and existing processes
Oracle Goldengate Macros,Obey Files and Include Files
Special sessions on project activites, how to HANDLE Collisions and different parameters
Enabling Command Line security

Oracle Goldengate 19c Learn and Master Oracle Goldengate


Basic knowledge of database architecture
Familiarity with Linux Basics
Familiarity with SQl Basics


Oracle Goldengate 19c is the latest version of Oracle Goldengate with lot of new features and advantages. The new features include robustness,security,performance and loads of new features. This course is complete course which starts from download and installation of Goldengate and covers advanced topics. I created this course because I want to encourage you to learn and build career in Goldengate. I want you to be an expert in Goldengate. Contrary to what we are being told and even technical “gurus”, learning Goldengate is not difficult. Its very easy. Creating this course has been a journey – a journey of delivering my knowledge I’ve carried about Goldengate for a long time. i want to emphasise learning Goldengate is easy and being a Goldengate expert is not that tough. it just need some guidance,mentorship and practise. This course has all ingredients to make you learn Goldengate and pave your path towards becoming Goldengate expert.This is the course with realtime activity course focussing on practicals. This course will make you interview ready and job ready. My assurance is at the end of the training you will be able to setup, manage,troubleshoot,configure Goldengate on ur own as well as able to provide solutions related to Goldengate on ur own to ur customer. If you are starting you carerr in Goldengate or new to Goldengate this is the correct course to pursue. Also if u have done my 12c course still there are lot of new topics introduced with this training.It is highly recommended that you enroll for this course.  this course has all the topics. This is the best course available related to Goldengate.The course is designed to meet best learning experience. With each session of the course you get notes/recap of the session and what practical implementaion to follow prior to next session to get you ready. With the course you get step by step activity guides,whatsapp group support and for any technical issues I am just an email away. The course Oracle GoldenGate 19c training will help you gain a strong foundation as well as expertise in implementing Oracle GoldenGate solutions. The course will deep dive into Oracle Goldengate architecture, parameters, mapping, transformations, and much more with real-time examples. You’ll also gain hands-on expertise with the help of Oracle GoldenGate training. There are many new topics included in training:1. Parallel Replicat2. Bidirectional auto CDR3. Heartbeat table4. PMSRVR5. Troubleshooting strategies6. Goldengate security wallet


Section 1: Introduction,installation of Oracle Goldengate & Different Architectures

Lecture 1 Introduction, Overview, Different Types Of Architecture and extract and replicat

Lecture 2 Oracle Goldengate Installation – Preparation and getting ready

Lecture 3 Oracle Goldengate GUI and Silent installation and where to install Goldengate

Section 2: Oracle Goldengate replication setup -Prerequisites and Configuration

Lecture 4 Preparing Databse for OGG setup and meeting DB prerequisites to setup Goldengate

Lecture 5 What is Supplem,ental Logging – Importance and how to add OGG Credentialstore

Lecture 6 Setting up OGG Processes – Create extract, Pump and Replicat for replication

Section 3: Introduction to Troubleshooting technques in OGG and process Data Flow

Lecture 7 OGG process Data Flow, Troubleshooting commands & Understanding info all output

Lecture 8 OGG Troubleshooting Tips and techniques and Topologies of OGG

Lecture 9 Goldengate process status, trail file switchover & Parameter file Golden Rules

Section 4: All about Goldengate parameters and Parameter files

Lecture 10 Different Parameters of Oracle Goldengate and learning how to Handle Collisions

Lecture 11 Manager Parameters- Autostart and Autorestart and demo of HANDLECOLLISIONS

Section 5: Initial Load using OGG and how to approach and strategize troubleshooting issues

Lecture 12 OGG Components and Performing Initial Load – File to Replicat

Lecture 13 Oracle Goldengate Common Issues – Troubleshooting, Approach & Strategy

Section 6: Zero Downtime Upgradation & Migration Strategy & Data Filteration in OGG

Lecture 14 Zero Downtime Upgradation & Migration and Data filteration using WHERE clause

Lecture 15 Data Filteration using FILTER Clause and GG builtin function

Section 7: Data Transformation, GG with Informatica, Parallel Replicat and OGG Lag

Lecture 16 Add a new Table in existing GG config, Data Transformation & Parallel Replicat

Lecture 17 Convert UPDATE to DELETES, GG with ODI/Informatica and Monitoring OGG Lag

Section 8: OGG New features Automatic Heartbeat Table and Performance Metrics Server

Lecture 18 OGG Automatic Heartbeat table and Performance Metrics Server (PMSRVR)

Section 9: OGG Checkpoint, Configuring Security in OGG, DDL Replication and Logdump

Lecture 19 OGG Checkpoint and OGG Security features – Trail file encryption and CMDSEC

Lecture 20 DDL Replication using OGG and how to read trail files using Logdump utility

Section 10: OGG Bbidirectional Replication and Bidirectional Auto CDR ,OGG 19c new features

Lecture 21 OGG 19c New_Features, GG_Bidirectional Setup, Add description to OGG processes

Lecture 22 Bidirectioanl Automatic Conflict Detection and Resolution – Auto CDR

Section 11: OGG Performance Tuning, OGG Macros, OGG Include_Files and using Obey Command

Lecture 23 OGG Performance Tuning, OGG Macros, OGG Include_Files and using Obey Command

Administrator,Database Administrator,Implementer,System Integrator,Systems Administrator,Analyst,Architect,Developer,DBAs,Goldengate Administrators,technologists

Course Information:

Udemy | English | 23h 12m | 9.70 GB
Created by: Ashish Agarwal

You Can See More Courses in the IT & Software >> Greetings from

New Courses

Scroll to Top