Posted: 14 days ago

Oracle GoldenGate Learn in just One month by Industry exper in Cauvery Nagar

Shortlist Click to Shortlist
+91 98865 41264
+91-4152 3314

Send Email Response

  • College name: Oracle GoldenGate Learn in just One month by Industry exper
  • Available courses: bachelor degree
  • Locality: Cauvery Nagar
Description for "Oracle GoldenGate Learn in just One month by Industry exper in Cauvery Nagar"

Oracle GoldenGate Learn in just One month by Industry experts in Elegant it

Use Oracle GoldenGate utilities
Perform data transformation using Oracle GoldenGate
Run and manage Oracle GoldenGate instances
Oracle GoldenGate solutions
Oracle GoldenGate architecture
Install Oracle GoldenGate software on Linux
Configure Oracle GoldenGate for Oracle-to-Oracle replication

Who Needs to Attend

Presales, administrators, support engineers, technical consultants, and data warehouse and database administrators


Familiarity with Oracle Database

Follow-On Courses

There are no follow-ons for this course.

Course Outline

1. Oracle GoldenGate 11gR1 Introduction

Oracle GoldenGate Features and Functionality
Oracle Middleware for Business Intelligence
Oracle GoldenGate High Availability and Disaster Tolerance Solutions
Oracle GoldenGate Real-time Data Integration Solutions

2. Oracle GoldenGate: Overview

Oracle GoldenGate Functionality and Components
Supported Databases and Platforms
Oracle GoldenGate Product Line

3. Oracle GoldenGate Architecture

Oracle GoldenGate Process Groups
Change Capture and Delivery (with and without a Data Pump)

Initial Data Load
Contrasting Batch and Online Operation
Oracle GoldenGate Checkpointing
Commit Sequence Number (CSN)
Oracle GoldenGate Files

4. Installing Oracle GoldenGate

Installing Oracle GoldenGate on Linux
Preparing the Operating System
Running GoldenGate Commands from the GGSCI Prompt
Using Obey Files and OS Shell
Get Help Information on GGSCI Commands
Types of GGSCI Commands Available

5. Configuration Overview and Preparing the Environment

High-Level Configuration Steps
Configuring and Starting the Manager Process
Generating a Source Definitions File
Preparing a Source Database for Transaction Capture

6. Configuring Change Capture

Extract Process
Marking Tables with TRANDATA
Configuring Extract to Access Logs on Oracle ASM
Configuring and Starting an Extract Process
Adding Local and Remote Trails
Configuring and Starting an Extract Data Pump

7. Configuring Initial Load

Oracle GoldenGate Initial Load Methods
Variety of Database-Specific Methods
Advantages of Oracle GoldenGate Methods
Configuring an Initial Load Using Oracle GoldenGate

8. Configuring Change Delivery

Replicat Process
Adding, Configuring, and Starting a Replicat Process
Avoid and Handle Collisions Between Changes and the Initial Load Data

9. Extracting Trails and Files

Extract Trails vs. Files
Investigating Different Formats
Viewing Extract Trails and Files with Logdump

Reversing the Sequence of Operations in an Extract Trail or File to Back Out Changes

10. Working with Parameters

Editing Parameter Files
Contrasting GLOBALS with Process Parameters

Commonly-Used Parameters for GLOBALS, Manager, Extract, and Replicat

11. Using Data Selection and Filtering

Selecting and Filtering Data for Replication
Mapping Columns Between Different Schemas
Using Built-In Functions
Using SQLEXEC to Interact Directly with a Database

12. Using Additional Transformation Concepts

Creating and Invoking Macros
Setting and Retrieving User Tokens
Running User Exits in GoldenGate Processes
Replicating Oracle Sequences

13. Configuration Options

Using BATCHSQL to Speed Delivery
Data Compress Across the Network
Enabling Message, Trail, and Password Encryption
Using Event Records to Automatically Trigger Actions

14. Configuring Bidirectional Replication

Bidirectional Configuration
Detecting and Avoid Loops
Avoiding, Detecting, and Handling Conflicts
Handling Identity Types

15. Setting Up DDL Replication

Concept of DDL Replication
Requirements for Oracle DDL Replication
GoldenGate Options for DDL Replication
DDL String Subsitution

16. Tuning and Troubleshooting

Controlling Command Permissions
Managing Trail Files
Automating Process Setup
Restarting Oracle GoldenGate
Handling TCP/IP Errors
Using Reporting and Statistics
Monitoring Processes, Lags, and Error Messages
Features of GoldenGate Management Pack


Elegant IT Services,
#352, 2nd Floor, Aswath Nagar,Varthur main road,
Opp Safal Fresh,Near Railway Fly Over
Maratha halli,Bangalore - 560037.Ph:-9886541264/87

See more ads by this user
Mark as Spam
Safety tips for buyers / sellers
Use      keys to browse Next/Prev ads
Bachelor degree colleges in Cauvery Nagar :
Get similar ads More details
Available courses: Bachelor Degree / Master
Direct Admission Through Mgt Quota B'lore Pune-9535186924
Available courses: Bachelor degree / Master degree / Professional degree
Direct Admission Through Management Quota For Engg. Call 9481855555
Available courses - Bachelor Degree
Posted: 20 days ago   |   Colleges - Bangalore
Promote your business on
(Premium packages / Banners / Leads)
Mail us at