Oracle GoldenGate 12c: Fundamentals for Oracle Training

3896 Learners

Oracle GoldenGate 12c: Fundamentals for Oracle training focuses on the functions, features, architecture, parameters, and commands for the installation and configuration of Oracle GoldenGate. The training explains how to maintain Oracle-to-Oracle database replication on a Windows or Linux platform. The candidates will learn how to extract trails and files using Data Pump, create parameter files and manage Oracle GoldenGate instances.

Oracle GoldenGate 12c: Fundamentals for Oracle course will help you in the following ways:

  • Install GoldenGate and issue the Oracle GoldenGate command line interface (GGSCI) efficiently
  • Prepare the source and target database (assumes Oracle-to-Oracle replication)
  • Use Oracle GoldenGate products and environments to design the replication solutions and manage multiple Oracle GG instances
  • Configure, and monitor Change Capture (Extract), and Change Delivery (Replicat)
  • Perfom Initial Load and edit configuration parameters
  • Manage Extract trails and files using Data Pump
  • Use  encryption and compression to control network transmission
  • Use macros, user tokens, user exits, Oracle Sequences to transform data
Target audience
  • Data Warehouse Developer
  • Data Warehouse Analyst
  • Data Warehouse Administrator
  • Database Designers
  • Database Administrators
  • System Integrator
  • Technical Consultant
  • Configuration Consultant
Prerequisites
  • Basic understanding of Oracle Database and basic SQL using SQL*Plus
  • Conceptual  idea of editing Linux text files using gedit or vi
  • Knowledge of basic encryption techniques will be an added advantage
Download Course Brochure

Oracle GoldenGate 12c: Fundamentals for Oracle training focuses on the functions, features, architecture, parameters, and commands for the installation and configuration of Oracle GoldenGate. The training explains how to maintain Oracle-to-Oracle database replication on a Windows or Linux platform. The candidates will learn how to extract trails and files using Data Pump, create parameter files and manage Oracle GoldenGate instances.

Oracle GoldenGate 12c: Fundamentals for Oracle course will help you in the following ways:

  • Install GoldenGate and issue the Oracle GoldenGate command line interface (GGSCI) efficiently
  • Prepare the source and target database (assumes Oracle-to-Oracle replication)
  • Use Oracle GoldenGate products and environments to design the replication solutions and manage multiple Oracle GG instances
  • Configure, and monitor Change Capture (Extract), and Change Delivery (Replicat)
  • Perfom Initial Load and edit configuration parameters
  • Manage Extract trails and files using Data Pump
  • Use  encryption and compression to control network transmission
  • Use macros, user tokens, user exits, Oracle Sequences to transform data
Target audience
  • Data Warehouse Developer
  • Data Warehouse Analyst
  • Data Warehouse Administrator
  • Database Designers
  • Database Administrators
  • System Integrator
  • Technical Consultant
  • Configuration Consultant
Prerequisites
  • Basic understanding of Oracle Database and basic SQL using SQL*Plus
  • Conceptual  idea of editing Linux text files using gedit or vi
  • Knowledge of basic encryption techniques will be an added advantage

Oracle GoldenGate 12c: Fundamentals for Oracle Training Course Content

1. Technology Overview

  • Creating Oracle GoldenGate Topologies
  • Reviewing Oracle GoldenGate Use Cases
  • Assembling Building Blocks
  • Listing Supported OS
  • Listing Supported Databases
  • Listing the Oracle GoldengGate 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
  • Configuring Environment Variables
  • 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
  • Using DBMS_GOLDENGATE_AUTH Package

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
  • Configuring New Integrated Replicat

7. Configuring Extract Trails and Files (Data Pump)

  • Reviewing Extract Trails and Files Overview
  • Describing Trail Formats
  • Using Logdump for Viewing Trails
  • Reversing the Trail 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 Methods
  • 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) Functions
  • Using SQLEXEC to Interact Directly with a Database
  • Configuring New Coordinated Replicat

11. Additional Transformation Concepts

  • Configuring and Using Macros
  • Configuring and Using User Tokens
  • Configuring and Using User Exits
  • Configuring and Using Oracle Sequences

12. Configuration Options

  • Configuring and Using BATCHSQL
  • Configuring and Using Compression
  • Configuring and Using Encryption
  • Configuring and Using Event Actions
  • Configuring New Wallet Security

13. Bidirectional Replication

  • Reviewing Bidirectional Considerations
  • Detecting Loops
  • Avoiding Conflicts
  • Configuring and Using Conflict Detection and Resolution
  • Describing Identity Types Issues

14. DDL Replication

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

Drop Us a Query

+91 95550 06479

Available 24x7 for your queries

Oracle GoldenGate 12c: Fundamentals for Oracle Corporate Training & Certification Program

Employee training and development programs are essential to the success of businesses worldwide. With our best-in-class corporate trainings you can enhance employee productivity and increase efficiency of your organization. Created by global subject matter experts, we offer highest quality content that are tailored to match your company’s learning goals and budget.

Learn from the experts

Customized Training

Be it schedule, duration or course material, you can entirely customize the trainings depending on the learning requirements of your workforce. You can even choose a trainer from our team of certified industry experts.

Learn from the experts

Expert Mentors

Get trained from our team of highly skilled and certified trainers, who are officially accredited professionals with relevant industry experience and adept in providing the knowledge and skills required to be successful.

Learn from the experts

360º Learning Solution

Engage your employees with our all-inclusive learning platform. Avail benefits of 24/7 access to the learning management system, industry-certified mentors, assessments & mock tests, real-time learning and more.

Learn from the experts

Learning Assessment

Check test score and performance with our skills analysis tools. Our detail scoreboard displays scores, areas of strength, detailed answer of questions and more for each employee.

Download Corporate Brochure

+91 9555006479

Available 24x7