Select Page

Oracle Goldengate Training – The only Course you need

⏰24 hours | ▶️ 24 Videos | 📣 49 Participants | 🔥11 Reviews

Choose a Plan that Works for You

Upcoming Batches PST

 Weekday 

Jan 19 (1 HR A DAY)
06:00 PM PST
Enroll Now  →

 Weekday 

Jan 25 (1 HR A DAY)
06:00 AM PST
Enroll Now  →

 Weekend

Jan 22 (1 HR A DAY)
06:00 PM PST
Enroll Now  →

Upcoming Batches IST

 Weekend 

Jan 20 (1 HR A DAY)
07:30 AM IST
Enroll Now  →

 Weekday 

Jan 25 (1 HR A DAY)
07:30 PM IST
Enroll Now  →

 Weekend 

Jan 23 (1 HR A DAY)
07:30 AM IST
Enroll Now  →

Course Description

So you want to learn Oracle Goldengate Training? Great job!

Do you know Oracle Goldengate Training  is the most trending Analytics course?

There are massive opportunities in Oracle Goldengate Training as it leads the Analytics market.

Our Oracle Goldengate Training course is a job oriented course ie at the end of the course you can
easily clear interviews or on board into an ongoing Oracle Goldengate Training project.

Also the salaries in Oracle Goldengate Training is very impressive (Indeed.com report)

Features

✅Lifetime access ✅Lifetime video access
✅Real-time case studies ✅The project integrated into the Curriculum
✅24*7 Support from our team of administrators

Course Content

1.1. OGG ARCHITECTURE

  • Building Blocks of Golden Gate
  • Manager
  • Extract(Capture)
  • Datapump(Routing)
  • Replicate(Delivery)
  • Trails (Extract) Files
  • Checkpoints – Detailed explanation of checkpoints
  • Collector (Server collector)
  • Data Source
  • Groups
  • Transformation

2. INSTALLATION OF GOLDEN GATE

Preparation & Installation of GG S/W on Source Server

  • Very Important pre-requisites on Source DB
  • Installing OGG S/W on Source Server
  • Creating of working /mandatory directories
  • Verifying DB connectivity from GG S/W

Preparation & Installation of GG on Target server

  • Very Important Pre-requisites on Target DB
  • Installing OGG S/W on Target Server
  • Creating of working /mandatory directories
  • Verifying DB connectivity from GG S/W

3. ORACLE GOLDEN GATE SUB-DIRECTORIES

  • Reports (.rpt)
  • Parameters (.prm)
  • Stdout (.out)
  • Replicate checkpoints (.cpr)
  • Extract checkpoints (.cpe)
  • Process Status (.pcs)
  • SQL Scripts (.sql)
  • Database Definitions (.def)

4. OPERATING SYSTEM REQUIREMENTS

  • Memory Requirements
  • Disk Requirements
  • Storage for Oracle Golden Gate Trails
  • To estimate required trail space
  • Temporary Disk requirements
  • Network
  • Operating System Privileges

5. CONFIGURING GLOBALS FILE

  • Checkpoint table
  • Configuring the Manager Process
  • Describing the Manager Parameters
  • Starting the Manager Process

6. HIGH LEVEL STEPS OF “REPLICATION WITH DATAPUMP” EXTRACT CONFIGURATION ON SOURCE SIDE.

  • Describing the Extract process
  • Explaining Extract checkpoints
  • Extract Creation on source side
  • Adding Extract on GG Interface
  • Adding remote trail at GG Interface on source side
  • Registering Extract at GG Interface on source side
  • Starting Extract process
  • Describing GGSCI commands
  • Describing Extract trails and files
  • Configuring Replicate on target side
  1. Describing the Replicate process
  2. Explaining Replicate checkpoints
  3. Replicate Creation on target side
  4. Adding Replicate on GG Interface
  5. Starting replicate process on target side
  • Observing Unidirectional Replication
  1. Describing GGSCI commands
  2. Describing Extract trails and files

7.REPLICATION WITH DATAPUMP

Extract Configuration on Source side

  • Describing the Extract process
  • Explaining Extract Checkpoints
  • Extract Creation on Source side
  • Adding Extract on GG Interface
  • Registering Extract at GG Interface on source side
  • Adding local trail at GG Interface on source side
  • Starting an Extract process
  • Describing GGSCI commands
  • Describing Extract trails and files

Datapump (Secondary Extract-Optional) Configuration on Source side

  • Describing the Datapump process
  • Explaining Datapump checkpoints
  • Datapump Creation on source side
  • Adding Datapump on GG Interface
  • Adding remote trail at GG Interface on source side
  • Starting Datapump process
  • Describing GGSCI commands
  • Describing Extract trails and files

Configuring Replicate target side

  • Describing the Replicate process
  • Explaining Replicate Checkpoints
  • Replicate Creation on target side
  • Adding Replicate on GG Interface
  • Starting replicate processes on target side

Observing Unidirectional Replication

  • Describing GGSCI Commands
  • Describing Extract trails and files

8. CONFIGURING DDL REPLICATION AT HIGH LEVEL

  • Instantiation through Initial Load (table level)
  • Instantiation through exp & Imp (Schema/table)
  • Instantiation through RMAN cloning (FULL DB)

9. PASSWORD ENCRYPTION

  • Importance of Discard file
  • Overview of Data Definition File
  • When to use Data Definition File
  • Configuring Data Definition File

10. BIDIRECTIONAL REPLICATION (ACTIVE – ACTIVE)

  • Overview of Integrated Capture

11. COMMON ERRORS/TROUBLESHOOTING

  • Handing Data missing errors on target side
  • Handing TCP/IP Errors
  • Troubleshooting process startup failures
  • Troubleshooting Extract problems
  • Troubleshooting missed transactions
  • Using the discard file
  • Using SHOWSYNTAX to view Replicate SQL statements
  • Using the Log dump utility

FAQ’s

❓ Do you offer any discount/offer?

✅ Yes, offers keep changing from time to time. You can chat with us or call our training coordinator for more details.

❓ Is there any demo video which I can watch before enrolling to the course?

✅ Yes, we have provided a Demo video section on each course page so that you can get a glimpse into the course you want to enroll.

❓ How soon after signing up would I get access to the learning content?

✅ Yes, we will provide access to all the learning materials after the complete payment for the course.

Related Blogs


Drop US a Query


Suggested Courses


MuleSoft Training

⭐⭐⭐⭐⭐

😃 221 Learners

Pega Training

⭐⭐⭐⭐⭐

😃 391 Learners

Rpa  Training

⭐⭐⭐⭐⭐

😃 106 Learners

WorkDay Training

⭐⭐⭐⭐⭐

😃 158 Learners

A few of our students

Alamara Jamadar 

HR Officer, Associate CIPD

The trainer gives knowledge of all topics through...more 

Paul Aldred 

Conversationalist at Blue Smart Fish

The experience has been extremely satisfying....more 

Kalakota V. 

Agile Integration Systems Analyst at IBM

Immeasurable online content. The tutors have...more 

Corporate Training

See why leading organizations choose CloudFoundation to train their Resources.

Course: Oracle Goldengate Training - The only Course you need