Oracle GoldenGate is a comprehensive software package for real-time data integration and replication in heterogeneous IT environments. The product set enables high availability solutions, real-time data integration, transnational change data capture, data replication, transformations, and verification between operational and analytical enterprise systems. Oracle GoldenGate brings extreme performance with simplified configuration and management, tighter integration with Oracle Database, support for cloud environments, expanded heterogeneity, and enhanced security.

Download Brochure

This course introduces the Oracle GoldenGate Architecture as well as various product features. Participants learn to install Oracle GoldenGate and prepare the source and target environments. The course teaches how to use the Oracle GoldenGate command line interface (GGSCI) efficiently. Participants configure Change Capture (Extract), Change Delivery (Replicat), and Initial Load. They learn to extract trails and files using Data Pump, create parameter files, and to manage Oracle GoldenGate instances. Capture of both DML and DDL will be configured for both unidirectional and bi-directional replication.

Who can attend?

  • Database Administrators
  • Database Designers
  • Data Warehouse Administrator
  • Data Warehouse Analyst
  • Data Warehouse Developer
  • System Integrator
  • Technical Consultant

Suggested Pre-requisites

  • Basic Linux
  • Familiarity with Oracle Database and basic SQL

Training Highlights

  • In-depth coverage with real world examples and scenarios
  • Top Quality course material for self-study and future reference
  • Server Access for practice
  • Interview questions & Guidance on Oracle certifications
  • Assistance on resume preparation
  • 100% Placement assistance by full-fledged in-house placement cell
1. Oracle GoldenGate Technology Overview

  • Creating Oracle GoldenGate Topologies
  • Reviewing Oracle GoldenGate Use Cases
  • Assembling Building Blocks
  • Listing Supported OS
  • Listing Supported Databases
  • Listing the oracle GoldenGate Product line
  • Describing GUI Management Options
  • Listing Non-Database Sources and Targets
2. Oracle GoldenGate Architecture

  • Describing Oracle GoldenGate Process Groups
  • Explaining Change Capture And Delivery ( With and Without a Data Pump)
  • Explaining Initial Data Load
  • Contrasting Batch and Online Operation
  • Explaining Oracle GoldenGate Checkpointing
  • Describing Commit Sequence Numbers (CSN)
  • Describing Oracle GoldenGate Files and Directories
3. Installing Oracle GoldenGate

  • Listing System Requirements
  • Performing Installation
  • Using GGSCI
  • Running Oracle GoldenGate from the OS Shell
4. Configuration Overview and Preparing the Environment

  • Reviewing Configuration Overview
  • Configuring Manager Process
  • Creating Source Definitions
  • Preparing the Source Database
  • Assigning Oracle Database Roles/Privileges Required
5. Configuring Change Capture (Extract)

  • Reviewing Extract Overview
  • Accessing Logs on Oracle ASM
  • Accessing Logs Remotely
  • Configuring Extract Tasks
  • Adding Extract Group
  • Editing Extract Parameters
  • Extracting Use of Archived Transaction Logs
  • Adding Trails
6. Configuring Change Delivery (Replicat)

  • Reviewing Replicat Overview
  • Configuring Replicat Tasks
  • Configuring a Sample Environment
7. Configuring Extract Trails and Files (Data Pump)

  • Reviewing Extract Trails and Files Overview
  • Describing Trail Formats
  • Using Logdump for Viewing Trails
  • Reversing the Trails Sequence
  • Configuring and Using Data Pumps
8. Performing Initial Load

  • Oracle GoldenGate Methods
  • Listing Database-specific Methods
  • Describing Resource Limitations
  • Listing Advantages of Oracle GoldenGate Methods
  • Configuring File Load Method
  • Configuring Direct Load Methods
  • Handling Collisions With Initial Load
9. Editing Configuration Parameters

  • Editing Parameter Files
  • Contrasting GLOBALS Versus Process Parameters
  • Configuring GLOBALS Parameters
  • Configuring Manager Parameters
  • Configuring Extract Parameters
  • Configuring Replicat Parameters
10. Filtering and Data Selection

  • Filtering and Data Selection
  • Mapping Columns Between Different Schemas
  • Using Built-in “@” (at) Function
  • Using SQLEXE C to Interact Directly with a Database
11. Bidirectional Replication

  • Reviewing Bidirectional Considerations
  • Detecting Loops
  • Avoiding Conflicts
  • Configuring And Using Conflict Detection and Resolution
  • Describing Identity Type Issues
12. DDL Replication

  • Reviewing Data Description Language Replication Overview
  • Configuring and Using Options for DDL Replication
  • Configuring and Using String Substitution in DDL

UCLID IT School is the pioneer in Oracle DBA training.  At UCLID, you are assured to get pure and clean Oracle DBA training. We have mastered the art of teaching Oracle DBA and changed many lives for good.  At UCLID, we follow an easy, simple and no-nonsense approach towards making you a master in Oracle DBA.

With it’s enviable & impeccable track record of training and placing thousands of students as Oracle DBAs in many IT organizations, Uclid has the following unique advantages:

  • Training by former employees of Oracle India and real time IT professionals from various top IT firms
  • Training on Real Time scenarios and case studies
  • Most in-depth and comprehensive training on every topic of the course
  • Well structured Training Material for future reference
  • Training on Latest Versions – Oracle 12c
  • Individual attention and group discussions for Interview preperation
  • Dedicated systems for Lab practice supported by qualified Lab Administrators and UPS for power backup
  • Unlimited Lab Access till you get job
  • 100% Placement Assistance backed by many top IT organizations (around 16 Top IT companies hire fresher DBAs from Uclid)
  • 100% Satisfaction guarenteed

UCLID has best of the best teaching faculties who are real time IT Professionals working with top MNCs. Each faculty has a minimum 10 years of real time experience in Oracle GoldenGate and working in the capacity of project leaders and project managers in various MNCs. You will benefit from their rich experience by going through the real time scenarios and case studies during the training. At the end of the course you will not only learn Oracle GoldenGate but familiarize yourself with the real time aspects of Oracle GoldenGate.