oracle 200x118 wht
8388  Reviews star_rate star_rate star_rate star_rate star_half

Oracle GoldenGate 12c: Troubleshooting and Tuning Ed 1

This Oracle GoldenGate 12c Troubleshooting and Tuning training teaches you how to gather and examine evidence; you’ll also learn to solve case problems, diagnose their cause and find methods of...

Read More
View Full Schedule Train Your Team
$4,000 USD
Duration 4 days
Course Code GG-TS-TUNING
Available Formats Classroom, Virtual

Upcoming Course Dates

  • Sep 15, 2025 - Sep 18, 2025 (4 days)
    Live Virtual | 9:00AM – 5:00PM EDT
    Language English
    Select from 1 options below
    Live Virtual |9:00AM – 5:00PM EDT
    Live Virtual | 9:00AM – 5:00PM EDT
    Enroll
    Enroll Add to quote
Ask a Question Request Other Date Request On-site Course

Overview

This Oracle GoldenGate 12c Troubleshooting and Tuning training teaches you how to gather and examine 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 Replicate.
  • Diagnose and tune the latest Integrated Extract, available since release 11.2.0.4 of the Oracle RDBMS, and Integrated Replicat, available since release 12c of the Oracle RDBMS.

Benefits to You

By enrolling in this course, you'll develop deeper knowledge of Oracle GoldenGate 12c performance tuning methods. Expert instructors will teach you how 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, the health check scripts and the Streams Performance Advisor (UTL_SPADV) to troubleshoot system issues occurring to both classic extract/replicat and integrated extract/replicate.

Explore 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 12cR1. Many of the techniques are also applicable to DB2, SQL Server, MySQL, etc.

Skills Gained

  • Monitor and tune performance
  • Gather evidence to help troubleshoot problems
  • Use troubleshooting tools
  • Familiarize with the latest tools to troubleshoot Integrated Extract/Replicat
  • Describe solutions for the most common problems

Who Can Benefit

  • Administrator
  • Database Administrator
  • Implementer
  • System Integrator
  • Systems Administrator

Prerequisites

Suggested Prerequisite

  • Oracle GoldenGate 12c: Fundamentals for Oracle Ed 1
  • Familiarity with the Oracle Database

Course Details

Topics

  • Gathering Evidence
    • Acquiring confidence using the standard Oracle GoldenGate tools normally used to interact with the software:
    • GGSCI
    • Error Logs, Process Reports, Discard File, System Logs
    • Competently using the tools mentioned above to gather evidence about alleged issues occurring to an Oracle GoldenGate environment
  • Oracle GoldenGate Troubleshooting Tools
    • Accessing knowledge Documents - Mailing lists, Oracle GoldenGate forums, etc.
    • Consulting the Documentation
    • Getting familiar with the ShowSyntax parameter
    • Getting familiar with the logdump utility
  • Basic and Startup Problems
    • Getting familiar with basic problems
    • Developing the ability to deal with Extract and Replicat startup issues
    • Verifying file names, file permissions, consistency between Extract and Replicat group names and their supporting files
    • Verifying consistent naming convention when defining trail files and their reference in the Extract/Replicat parameter files
    • Verifying that the correct software version has been installed
    • Verifying that the Oracle GoldenGate manager is running, that the group name which fails to start exists and is not misspelt
    • Verifying that the the parameter file exists, has the same name as the Extract/Replicat group, and is accessible by Oracle GoldenGate
    • Introducing the use of CHECKPARAMS to verify that the parameter syntax is correct
  • Data Extraction Problems
    • Developing the ability to deal with and troubleshoot data extraction issues:Extract is slow - Extract abends - Data pump abends
    • Analyzing various causes of a slow Extract startup
    • Tracing may be enabled, activity logging may be enabled, many columns listed in tables being replicated
    • Introducing the use of the CacheMgr parameter to control the virtual memory and temporary disk space that are available for caching uncommitted transaction data
    • In-depth analysis of abending Extracts: is Extract unable to open the transaction logs? - Checking to see if the disk is full -Is an archive log missing?
    • In-depth analysis of abending data pumps: Does the data pump abend with error number 509 ("Incompatible record")?Have the source tables been changed? Is the Extract abending due to data manipulation?
    • Was the primary Extract or the data pump stopped, re-added, or restarted without resetting the data pump’s read position in the local trail?
  • Data Replication Problems
    • Developing the ability to deal with and troubleshoot data replication issues:
    • Analyzing the various causes of a "stuck" Replicat: Does "Stats Replicat" return no statistics? Do successive "Info Replicat" commands indicate that the Replicat read checkpoint is not moving?
    • Verifying that the Replicat is reading the trail to which Extract is writing
    • Analyzing the reasons why a Replicat abends: Is Replicat unable to locate a trail? Is Replicat unable to open a trail file? Was "Add TranData" issued for each table?
  • Missed Transactions
  • Mapping and Synchronization Problems
  • SQLEXEC, File-Maintenance, and Other Problems
  • "Classic" Performance Tuning
  • "Integrated" Performance Tuning
  • "Integrated" Capture and Delivery Troubleshooting
  • Acquiring confidence using the standard Oracle GoldenGate tools normally used to interact with the software:
  • GGSCI
  • Error Logs, Process Reports, Discard File, System Logs
  • Competently using the tools mentioned above to gather evidence about alleged issues occurring to an Oracle GoldenGate environment

Oracle GoldenGate Troubleshooting Tools

  • Accessing knowledge Documents - Mailing lists, Oracle GoldenGate forums, etc.
  • Consulting the Documentation
  • Getting familiar with the ShowSyntax parameter
  • Getting familiar with the logdump utility

Basic and Startup Problems

  • Getting familiar with basic problems
  • Developing the ability to deal with Extract and Replicat startup issues
  • Verifying file names, file permissions, consistency between Extract and Replicat group names and their supporting files
  • Verifying consistent naming convention when defining trail files and their reference in the Extract/Replicat parameter files
  • Verifying that the correct software version has been installed
  • Verifying that the Oracle GoldenGate manager is running, that the group name which fails to start exists and is not misspelt
  • Verifying that the the parameter file exists, has the same name as the Extract/Replicat group, and is accessible by Oracle GoldenGate
  • Introducing the use of CHECKPARAMS to verify that the parameter syntax is correct

Data Extraction Problems

  • Developing the ability to deal with and troubleshoot data extraction issues:Extract is slow - Extract abends - Data pump abends
  • Analyzing various causes of a slow Extract startup
  • Tracing may be enabled, activity logging may be enabled, many columns listed in tables being replicated
  • Introducing the use of the CacheMgr parameter to control the virtual memory and temporary disk space that are available for caching uncommitted transaction data
  • In-depth analysis of abending Extracts: is Extract unable to open the transaction logs - Checking to see if the disk is full -Is an archive log missing
  • In-depth analysis of abending data pumps: Does the data pump abend with error number 509 ("Incompatible record")Have the source tables been changed Is the Extract abending due to data manipulation
  • Was the primary Extract or the data pump stopped, re-added, or restarted without resetting the data pump’s read position in the local trail

Data Replication Problems

  • Developing the ability to deal with and troubleshoot data replication issues:
  • Analyzing the various causes of a "stuck" Replicat: Does "Stats Replicat" return no statistics Do successive "Info Replicat" commands indicate that the Replicat read checkpoint is not moving
  • Verifying that the Replicat is reading the trail to which Extract is writing
  • Analyzing the reasons why a Replicat abends: Is Replicat unable to locate a trail Is Replicat unable to open a trail file Was "Add TranData" issued for each table

Missed Transactions

  • Developing the ability to deal with and troubleshoot missed transactions involving issues such as: Tables that are not properly specified - Missing" Add TranData" command - LOB data not replicating
  • Analyzing the reasons why transactions are not being processed: Were the tables included in Table and Map statements Are fully qualified names (owner.table) used for both Table and Map
  • 'Single quotes' on object names imply case-sensitive names for some databases (including the Oracle database)
  • Are the transactions coming out of the source system properly

Mapping and Synchronization Problems

  • Developing the ability to deal with and troubleshoot mapping problems, such us: Fetching from the source data fails - Table and column names not matching between the source and the target
  • Analyzing the causes of various mapping problems:Is Extract returning fetch-related errors Was the row containing the data deleted
  • Has the undo retention expired
  • Is "NoUseLatestVersion" for "FetchOptions" being used
  • Do the source and target tables exist in the databases Are they specified correctly in the Table or Map statement Are their names fully qualified (schema.table)
  • Do table and column names contain only supported characters
  • Are WHERE clauses comparing different data types
  • Is KeyCols being used Are both source and target KeyCols being used Corresponding source and target columns must match.

SQLEXEC, File-Maintenance, and Other Problems

  • Developing the ability to deal with and troubleshoot :
  • SQLEXEC problems - File-maintenance problems - Time differences - Too many open cursors
  • File-Maintenance Problems: Discard File Is Not Created - Discard File Is Too Big - Trail File Is Too Big
  • Miscellaneous Problems: Time Differences - INFO Command Shows Incorrect Status

"Classic" Performance Tuning

  • Identifying causes of slow startups
  • Monitoring lag and statistics
  • Tuning Manager
  • Identifying network and disk bottlenecks
  • Tuning "Classic" Extract
  • Tuning "Classic" Replicat

"Integrated" Performance Tuning

  • Describing architecture and advantages of the new Integrated capture
  • Describing architecture and advantages of the new Integrated delivery
  • Familiarizing with the new V$ tables holding real time Oracle GoldenGate statistics

"Integrated" Capture and Delivery Troubleshooting

  • Familiarizing with Troubleshooting Aids and Tools for Integrated Replication
  • Describing Oracle GoldenGate Healthcheck for Integrated Replicat
  • Describing the Oracle Database 12c GoldenGate AWR report
Read Less
|
View Full Schedule

Schedule

1 options available

  • Sep 15, 2025 - Sep 18, 2025 (4 days)
    Live Virtual | 9:00AM – 5:00PM EDT
    Language English
    Select from 1 options below
    Live Virtual |9:00AM – 5:00PM EDT
    Live Virtual | 9:00AM – 5:00PM EDT
    Enroll
    Enroll Add to quote

FAQ

Does the course schedule include a Lunchbreak?

Classes typically include a 1-hour lunch break around midday. However, the exact break times and duration can vary depending on the specific class. Your instructor will provide detailed information at the start of the course.

What languages are used to deliver training?

Most courses are conducted in English, unless otherwise specified. Some courses will have the word "FRENCH" marked in red beside the scheduled date(s) indicating the language of instruction.

What does GTR stand for?

GTR stands for Guaranteed to Run; if you see a course with this status, it means this event is confirmed to run. View our GTR page to see our full list of Guaranteed to Run courses.

Does Ascendient Learning deliver group training?

Yes, we provide training for groups, individuals and private on sites. View our group training page for more information.

What does vendor-authorized training mean?

As a vendor-authorized training partner, we offer a curriculum that our partners have vetted. We use the same course materials and facilitate the same labs as our vendor-delivered training. These courses are considered the gold standard and, as such, are priced accordingly.

Is the training too basic, or will you go deep into technology?

It depends on your requirements, your role in your company, and your depth of knowledge. The good news about many of our learning paths, you can start from the fundamentals to highly specialized training.

How up-to-date are your courses and support materials?

We continuously work with our vendors to evaluate and refresh course material to reflect the latest training courses and best practices.

Are your instructors seasoned trainers who have deep knowledge of the training topic?

Ascendient Learning instructors have an average of 27 years of practical IT experience and have also served as consultants for an average of 15 years. To stay current, instructors spend at least 25 percent of their time learning new, emerging technologies and courses.

Do you provide hands-on training and exercises in an actual lab environment?

Lab access is dependent on the vendor and the type of training you sign up for. However, many of our top vendors will provide lab access to students to test and practice. The course description will specify lab access.

Will you customize the training for our company’s specific needs and goals?

We will work with you to identify training needs and areas of growth.  We offer a variety of training methods, such as private group training, on-site of your choice, and virtually. We provide courses and certifications that are aligned with your business goals.

How do I get started with certification?

Getting started on a certification pathway depends on your goals and the vendor you choose to get certified in. Many vendors offer entry-level IT certification to advanced IT certification that can boost your career. To get access to certification vouchers and discounts, please contact info@ascendientlearning.com.

Will I get access to content after I complete a course?

You will get access to the PDF of course books and guides, but access to the recording and slides will depend on the vendor and type of training you receive.

How do I request a W9 for Ascendient Learning?

View our filing status and how to request a W9.

Reviews

Simply great training provider that I can go for updating/acquiring my skill sets.

my experince was great from the day i regetered to the actuall day of the class.

I didn't have any problem navigating Exitcertified website or lab material at all.

The labs and course material gave me valuable insights into cloud security architecture

The class covered the concepts needed for the AWS Cloud Practitioner Certification.