Oracle GoldenGate 10.4: Troubleshooting and Tuning

Course Description

The Oracle GoldenGate Troubleshooting and Tuning course provides lecture, demonstration, and hands-on lab exercises to sharpen participant’s analytical skills on troubleshooting common problems. The course teaches participants how to proactively monitor GoldenGate, understand where to collect details when a problem arises, and use tools to analyze the cause. Additional practices cover scenarios on resolving process failures, extraction failures, synchronization failures, mapping failures, and others. Participants also learn to tune process for achieving better performance. 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.

Skills Gained

• Learn to gather evidence using GGSCI commands to help troubleshoot few common problems such as process startup, replication and synchronization
• Know how to use the troubleshooting tools
• Learn to tune Manager, Extract and Replicate process to achieve better performance

Who Can Benefit

• System Integrator

Prerequisites

• Experience in configuring and managing a GoldenGate instance

Syllabus

Gathering Evidence

• Using GGSCI commands and Viewing Reports and Logs
• Using GGSCI command to view Processing status
• Using GGSCI command to view Events
• Using GGSCI command to view Errors
• Using GGSCI command to view Checkpoints
• Viewing information in the Process reports
• Viewing information in the Error log and System log
• Viewing information in the Discard file

Troubleshooting Tools

• Knowledge Documents
• Documentation
• Using SHOWSYNTAX parameter
• Using Logdump utility to view information in GoldenGate trail

Troubleshooting

• Troubleshooting Process startup problems
• Troubleshooting Extraction problems
• Troubleshooting Replication problems
• Troubleshooting Missed transactions
• Troubleshooting Mapping problems
• Troubleshooting Synchronization problems
• Troubleshooting SQLEXEC problems
• Troubleshooting File maintenance problems

Performance Tuning

• Identifying causes for slow startups
• Monitoring lag and statistics
• Tuning Manager
• Identifying network and disk bottlenecks
• Tuning Extract
• Tuning Replicate