Oracle GoldenGate 11g Troubleshooting and TuningNEW

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.

Audience

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

Course Topics 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

• Solving Mapping Problems Such as Missed Definitions and Column 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

• Building 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 Objectives

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