Oracle GoldenGate Training

Oracle GoldenGate Training in Bangalore

DSMINFOTECH is a software training institute located in Bangalore that offers training in Oracle GoldenGate. The training covers the basics of Oracle GoldenGate, as well as advanced topics, to help students become proficient in using the tool for real-time data replication and integration.

Some of the topics covered in the Oracle GoldenGate course at DSMINFOTECH include:

  1. Introduction to Oracle GoldenGate
  2. Overview of Oracle GoldenGate architecture
  3. Oracle GoldenGate components and modules
  4. Oracle GoldenGate installation and configuration
  5. Oracle GoldenGate maintenance and management
  6. Oracle GoldenGate performance tuning and optimization
  7. Oracle GoldenGate troubleshooting and error handling
  8. Oracle GoldenGate best practices and real-world case studies

DSMINFOTECH has experienced trainers who use a combination of lectures, hands-on labs, and real-world case studies to help students understand the concepts and apply them in practical scenarios.

Get In Touch

Oracle GoldenGate Course Syllabus

 
Chapter 1 
  • Introduction to Oracle GoldenGate 
  • Oracle GoldenGate supported processing methods and databases 
  • Overview of the Oracle GoldenGate architecture 
  • Overview of process types 
  • Overview of groups 
  • Overview of the Commit Sequence Number (CSN)
Chapter 2
  • Installing Oracle GoldenGate 
  • Downloading Oracle GoldenGate
  • Setting ORACLE_HOME and ORACLE_SID 
  • Specifying Oracle variables on UNIX and Linux systems
  • Specifying Oracle variables on Windows systems 
  • Setting library paths for dynamic builds on UNIX 
  • Preparing to install Oracle GoldenGate within a cluster 
  • Installing as the Oracle user 
  • Supported Oracle cluster storage 
  • Deciding where to install Oracle GoldenGate binaries and files in the cluster
  • Installing Oracle GoldenGate on Linux and UNIX 
  • Installing Oracle GoldenGate on Windows
  • Installing Oracle GoldenGate into a Windows Cluster
  • Installing the Oracle GoldenGate files
  • Specifying a custom Manager name 
  • Installing Manager as a Windows service
  • Integrating Oracle GoldenGate into a cluster
  • General requirements in a cluster 
  • Adding Oracle GoldenGate as a Windows cluster resource
  • Installing support for Oracle sequences
Chapter 3
  • Configuring Manager and Network Communications
  • Overview of the Manager process
  • Assigning Manager a port for local communication 
  • Maintaining ports for remote connections through firewalls
  • Choosing an internet protocol
  • Recommended Manager parameters
  • Creating the Manager parameter file 
  • Starting Manager
  • Stopping Manager
Chapter 4 
  • Getting started with the Oracle GoldenGate process interfaces
  • Using the GGSCI command line interface
  • Using UNIX batch and shell scripts
  • Using Oracle GoldenGate parameter files
  • Supported characters in object names
  • Specifying object names in Oracle GoldenGate input 
Chapter 5
  • Using Oracle GoldenGate for live reporting
  • Overview of the reporting configuration
  • Considerations when choosing a reporting configuration
  • Creating a standard reporting configuration
  • Creating a reporting configuration with a data pump on the source system
  • Creating a reporting configuration with a data pump on an intermediary system 
  • Creating a cascading reporting configuration
Chapter 6 
  • Using Oracle GoldenGate for realtime data distribution
  • Overview of the datadistribution configuration
  • Considerations for a datadistribution configuration
  • Creating a data distribution configuration
Chapter 7 
  • Configuring Oracle GoldenGate for realtime data warehousing
  • Overview of the datawarehousing configuration
  • Considerations for a data warehousing configuration
  • Creating a data warehousing configuration
Chapter 8
  • Configuring Oracle GoldenGate for activeactive high availability
  • Overview of an activeactive configuration
  • Considerations for an activeactive configuration
  • Preventing data looping
  • Creating an activeactive configuration
  • Managing conflicts
  • Handling conflicts with the Oracle GoldenGate CDR feature
  • Configuring Oracle GoldenGate CDR
  • CDR example : All conflict types with USEMAX, OVERWRITE, DISCARD
  • CDR example : UPDATEROWEXISTS with USEDELTA and USEMAX
  • CRD example : UPDATEROWEXISTS with USEDELTA, USEMAX, and IGNORE
Chapter 9 
  • Mapping and manipulating data
  • Limitations of support
  • Parameters that control mapping and data integration
  • Mapping between dissimilar databases
  • Deciding where data mapping and conversion will take place
  • Globalization considerations when mapping data
  • Mapping columns
  • Selecting rows
  • Retrieving before values
  • Selecting columns
  • Selecting and converting SQL operations
  • Using transaction history
  • Testing and transforming data
  • Using tokens 
Chapter 10 
  • Handling Oracle GoldenGate processing errors
  • Overview of Oracle GoldenGate error handling
  • Handling Extract errors
  • Handling Replicat errors during DML operations
  • Handling Replicat errors during DDL operations
  • Handling TCP/IP errors
  • Maintaining updated error messages
  • Resolving Oracle GoldenGate errors
Chapter 11 
  • Associating replicated data with metadata
  • Configuring Oracle GoldenGate to assume identical metadata
  • Configuring Oracle GoldenGate to assume dissimilar metadata
  • Configuring Oracle GoldenGate to use a combination of similar and dissimilar definitions
  • Chapter12 
  • Configuring online change synchronization
  • Overview of online change synchronization
  • Configuring change synchronization to satisfy a specific topology
  • Naming conventions for groups
Perl/Tk
  • Creating a Perl/Tk Application
  • GUI Programming Overview
  • Adding Widgets
  • Scrolled Widgets
  • Configuring Widgets
  • Menus
  • More Fun with Menus
  • Using FileSelect
Perl/Tk Programming
  • Tk::Error and Tk::ErrorDialog
  • Configuring Widgets
  • Geometry Management
  • Geometry Management with grid()
  • The Frame Widget
  • Defining Widget Callbacks
  • Bindings
  • Nonblocking I/O with fileevent()
  • Tags
  • Other Widgets
  • Other Tk Commands
  • Getting Tk
  • Extending Perl with C/C++
  • Extending the Perl Interpreter
  • Overview of Perl5 XSUBs
  • Get Started with h2xs
  • Set up the Perl Wrapper Class
  • Write the XS Code
  • The XS File
  • Write Some Test Code
  • What Do You Want?
  • Returning Values on the Stack
  • A Walk Through an XSUB
  • Arguments to XSUBs
  • Other h2xs Options
  • Embedding the Perl Interpreter
  • Why Embed Perl?
  • Embedding Perl in a C Program

    To Get Complete Course Information