Optimize and Troubleshoot with Confidence: Oracle GoldenGate 19c Training.

Gain the expertise to fine-tune and troubleshoot Oracle GoldenGate 19c environments effectively. This course is designed for database administrators and IT professionals looking to enhance their skills in optimizing data replication and resolving performance issues.

Learn actionable techniques to diagnose bottlenecks, streamline replication processes, and ensure seamless data integration. With hands-on experience, you’ll be prepared to tackle real-world challenges and maintain high-performance GoldenGate implementations.

Overview

This course helps you learn how to gather and examine evidence. You will learn to solve case problems, diagnose their cause and find methods of resolution. Each of these practices challenges you to diagnose and troubleshoot the issue using the GoldenGate software.

Skills Covered

Learn How To:

  • Use GGSCI commands for gathering process evidence
  • Use the Oracle GoldenGate troubleshooting tools like Knowledge Documents, Documentation, SHOWSYNTAX parameter and the Logdump utility
  • Troubleshoot problems in areas such as extraction, replication, missed transactions, mapping, synchronization, SQLEXEC, file maintenance and more
  • Identify what causes slow startups
  • Monitor lag and statistics
  • Identify network and disk bottlenecks
  • Perform tuning of Manager, Extract and Replicate
  • Diagnose and tune the latest Integrated Extract and Replicate

Prerequisites

There are no prerequisites required to attend this course.

Target Audience

Anyone who are interested can attend.

Course Curriculum

Module 1: Introduction

  • Introduction
  • Course Practice Environment: Security Credentials

Module 2: Gathering Evidence

  • Gathering Evidence
  • Event (Error) Log
  • Practice 2-1: Becoming Familiar with Your Oracle Environment
  • Practice 2-2: Finding Clues in the adminclient Information Commands
  • Practice 2-3: Finding Clues with the Administration Server
  • Practice 2-4: Checking the Files for More Evidence with adminclient
  • Practice 2-5: Finding Clues in GGSCI Information Commands
  • Practice 2-6: Checking the Files for More Evidence Using GGSCI

Module 3: Tools

  • Tools
  • Using logdump: Open
  • Practice 3-1: Using ShowSyntax
  • Practice 3-2: Using logdump Part 1
  • Practice 3-2: Using logdump Part 2

Module 4: Basic Problems and Process Startup Problems

  • Basic Problems and Process Startup Problems
  • Practice 4-1: Solving Extract Startup Problems
  • Practice 4-2: Solving Pump Extract Startup Problems
  • Practice 4-3: Solving Replicat Startup Problems

Module 5: Extraction Problems

  • Extraction Problems
  • Practice 5-1: Solving Extract User Problems
  • Practice 5-2: Solving Path Connection Problems
  • Practice 5-3: Solving Pump Extract Connection Problems Part 1
  • Practice 5-3: Solving Pump Extract Connection Problems Part 2

Module 6: Replication Problems

  • Replication Problems
  • Practice 6-0: Environment Setup
  • Practice 6-1: Solving Replicat Problems Using adminclient and Administration Server Part 1
  • Practice 6-1: Solving Replicat Problems Using adminclient and Administration Server Part 2
  • Practice 6-1: Solving Replicat Problems Using adminclient and Administration Server Part 3
  • Practice 6-2: Solving Trail File Problems Using the Administration Server and adminclient Part 1
  • Practice 6-2: Solving Trail File Problems Using the Administration Server and adminclient Part 2

Module 7: Missed Transactions

  • Missed Transactions
  • Practice 7-1: Solving Mismatch Problems
  • Practice 7-2: Handling Errors in GGSCI
  • Practice 7-3: Handling Errors Using the Administration Server

Module 8: Mapping and Synchronization Problems

  • Mapping and Synchronization Problems
  • Practice 8-1: Solving Mapping Problems Part 1
  • Practice 8-1: Solving Mapping Problems Part 2

Module 9: SQLEXEC, File-Maintenance, and Other Problems

  • SQLEXEC, File-Maintenance, and Other Problems
  • Practice 9-1: Solving Trail Maintenance Issues
  • Practice 9-2: Applying a Patch
  • Practice 9-3: Create Purge Trails Task

Module 10: Classic Performance Tuning

  • Classic Performance Tuning
  • Bottlenecks: Determining Lag (Latency)
  • Automatically Restarting Processes that Fail
  • Tuning Classic Replicat: BatchSQL Overview
  • Practice 10-1: Tuning Replication Part 1
  • Practice 10-1: Tuning Replication Part 2

Module 11:  Integrated Performance Tuning

  • Integrated Performance Tuning
  • Integrated Replicat Performance
  • Practice 11-1: Preparing the Environment Part 1
  • Practice 11-2: Configuring an Integrated Extract and a Distribution Path
  • Practice 11-3: Configuring an Integrated Replicat
  • Practice 11-4: Generating Data on the Source Schema and Verifying That Replication Is Occurring
  • Practice 11-5: Gathering Performance Statistics from GoldenGate CDB, DBA, and V$ Views

Module 12: Integrated Capture and Delivery Troubleshooting

  • Integrated Capture and Delivery Troubleshooting
  • Practice 12-1: Capturing AWR Snapshots Overview & Practice 12-2: Installing the UTL_RPADV Package
  • Practice 12-3: Running and Analyzing the Healthcheck Script
  • Practice 12-4: Generating AWR Reports and Analyzing the Results

Dates & Locations

Let’s make it work for you

Can’t find a date that fits? Need to train your whole team? Looking for a discount?
Speak to one of our learning experts today.

There’s no intakes scheduled for this course at the moment!

For enquiries, please contact our reps.

Exam & Certification

This course is not associated with any Certification.

Training & Certification Guide

Why train with Trainocate

Speak to a Training Consultant

All courses are HRD Claimable.
Get in touch with our team via the form or WhatsApp us on +6011-5119 6631

Preferred mode of training
Checkboxes