Oracle GoldenGate Training in Bangalore

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
• Compiling the Prog