Download PDF
of this course

Oracle GoldenGate 11g Troubleshooting and Tuning (G11GTT)

  • Overview
  • Who Should Attend
  • Certifications
  • Prerequisites
  • Objectives
  • Content
  • Schedule
Course Overview

Duration: 3 Days

Price: SGD 2,520.00

This Oracle GoldenGate 11g Troubleshooting and Tuning course teaches you the skills to be self-sufficient in gathering and examining evidence; you’ll also 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 GoldenGate software.

Learn 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 Replicat.

Performance Tuning

You’ll also learn methods of Oracle GoldenGate 11g performance tuning. Expert instructors will teach you to identify the causes of slow startups, evaluate lag statistics and solve network and disk bottlenecks. Utilize all of the existing GoldenGate tools, such as GGSCI and Logdump, to troubleshoot system issues.

Platforms

This training is on a Linux platform; however many of the troubleshooting techniques are equally applicable to a Windows or iSeries platform. The databases used for source and target are Oracle 11gR2. Many of the techniques are also applicable to DB2, SQL Server, MySQL, etc.

A Live Virtual Class (LVC) is exclusively for registered students; unregistered individuals may not view an LVC at any time. Registered students must view the class from the country listed in the registration form. Unauthorized recording, copying, or transmission of LVC content may not be made.

 

Who Should Attend

  • Database Administrators
  • System Administrator
  • Support Engineer
  • Technical Consultant
  • Data Warehouse Administrator

Course Certifications

This course is part of the following Certifications:

Prerequisites

Required Prerequisites:

  • Familiarity with the Oracle Database
  • Oracle GoldenGate 11g: Fundamentals for Oracle

Course Objectives

  • Describe solutions for the most common problems
  • Monitor and tune performance
  • Gather evidence to help troubleshoot problems
  • Use troubleshooting tools

Course Content

Gathering Evidence

  • GGSCI commands
  • Viewing Checkpoint Details
  • Evaluating a Process Report
  • Evaluating a Log Sample
  • Gather and evaluate systems logs

Troubleshooting Tools

  • SHOWSYNTAX overview, usage and output
  • Logdump overview
  • Utilizing the key commands and functionality of Logdump

Startup Problems

  • GoldenGate configuration
  • Operating system configuration
  • Permissions
  • Slow startup

Extraction Problems

  • Diagnosing a slow Extract
  • Solving the issue when Extract abends
  • Solving the issue when the Data Pump Extract abends

Replication Problems

  • Replicat is not moving or abends
  • Replicat abends with Error 509
  • Preventing Replicat from exiting

Missed Transaction Problems

  • Transactions not being processed
  • Including missed transactions

Mapping and Synchronization Problems

  • Solve mapping problems such as missed definitions and colum mappings
  • Syncrhronization issues such as out-of-sync rows, tables without keys, character sets, and DML on target tables

SQLEXEC Problems

  • SQL does not execute
  • Tracing SQLEXEC problems
  • File Maintenance Problems
  • Time differences
  • Unusable indexes
  • Too many open cursors

Performance Tuning

  • Builing the object record for speeding up the startup
  • Monitoring lag statistics
  • Identifying bottlenecks such as lag, network issues, and disk reads
  • Tuning Extract and Replicat for optimal performance

Course ID: G11GTT


Show Schedule for 1 Month  3 Months  All 
Date Country Location Register