Oracle GoldenGate 10.4: Troubleshooting and Tuning
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.
This course is based on Oracle Golden Gate version 10.4.
Audience
- System Integrator
Course Topics Gathering Evid…
There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.
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.
This course is based on Oracle Golden Gate version 10.4.
Audience
- System Integrator
Course Topics 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
- Knowledge Documents
- Documentation
- Using SHOWSYNTAX parameter
- Using Logdump utility to view information in GoldenGate trail
- 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
- Identifying causes for slow startups
- Monitoring lag and statistics
- Tuning Manager
- Identifying network and disk bottlenecks
- Tuning Extract
- Tuning Replicat
Course Objectives
- 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
There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.
