GoldenGate Monitoring and Troubleshooting

2. GoldenGateMonitoring and Troubleshooting Lorena Lobato Pardavila - CERN Replication Technology Evolution for ATLAS Data Workshop

3. Outline Replication Technology Evolution for ATLAS Data Workshop Oracle GoldenGate Director and Oracle GoldenGate Enterprise Manager Plug-in Database level Monitoring GoldenGate Troubleshooting Questions

4. Outline Replication Technology Evolution for ATLAS Data Workshop Oracle GoldenGate Director and Oracle GoldenGate Enterprise Manager Plug-in Database level Monitoring GoldenGate Troubleshooting Questions

5. Oracle GG Director: Overview OGG Director Server Domain GGSCI OGG Director Web OGG Director Server Application GGSCI OGG Director Client GGSCI OGG Director Administrator Monitor Agent Clients OGG Instances OGG DIRECTOR DATABASE Replication Technology Evolution for ATLAS Data Workshop • Multi-tiered, client-server application that enables the configuration and management of Oracle GoldenGate instances from a remote client

6. System Requirements Replication Technology Evolution for ATLAS Data Workshop • Oracle GoldenGate Director Server • 1 GB of RAM up to 1.5 GB (recommended) of free disk space. • Dedicated http port (default port is 7001) • DYNAMICPORTLIST in each Manager process • Oracle WebLogic Server 11g Standard Edition • 10.3.1, 10.3.2, 10.3.3, 10.3.4, or 10.3.5 or 12c (12.1.1) • Oracle GoldenGate Director Web • Supports Microsoft Internet Explorer v6.0 or later and Mozilla Firefox v2.0 or later • No software is installed on the client system for the OGG Web • Oracle Director Desktop Client • Same version as that Oracle GoldenGate Director Server • Install Java Runtime Environment (JRE) on each cliente host

7. Oracle GG Director: Overview Replication Technology Evolution for ATLAS Data Workshop • OGG Director Administrator Tool

8. Oracle GG Director: Overview Replication Technology Evolution for ATLAS Data Workshop • OGG Director Desktop Client

9. Oracle GG Director: Overview Replication Technology Evolution for ATLAS Data Workshop • OGG log

10. Oracle GG Director: Overview • Alerts configuration Replication Technology Evolution for ATLAS Data Workshop

11. Oracle GG Director: Web • Server_domain/acon Replication Technology Evolution for ATLAS Data Workshop

12. OGG Enterprise Manager Plug-in (Live) Replication Technology Evolution for ATLAS Data Workshop • For installing the plug-in: • Enterprise Manager Cloud Control 12c Bundle Patch 1 (12.1.0.1) and later • Oracle GoldenGate 11g Release 2 (11.2.1.0.1) and later • Management features: • Monitor Oracle GoldenGate instances. • Gather configuration data and track configuration changes for Oracle GoldenGateinstances. • Raise alerts and violations based on thresholds set on monitored targets and configuration data. • Support monitoring by a remote Agent. A Local Agent is an agent running on the same host as the Oracle GoldenGate instance.

13. OGG Enterprise Manager Plug-in Replication Technology Evolution for ATLAS Data Workshop • Summary

14. OGG Enterprise Manager Plug-in (Live Demo) https://oem-test.cern.ch/ Replication Technology Evolution for ATLAS Data Workshop

15. Outline Replication Technology Evolution for ATLAS Data Workshop Oracle GoldenGate Director and Oracle GoldenGate Enterprise Manager Plug-in Database level Monitoring GoldenGate Troubleshooting Questions

16. Outline Replication Technology Evolution for ATLAS Data Workshop Oracle GoldenGate Director and Oracle GoldenGate Enterprise Manager Plug-in Database level Monitoring GoldenGate Troubleshooting Questions

17. Troubleshooting Network Hardware Operating System Database Application Server Storage/Disk OGG REPORTS ORACLE DATABASES LOGDUMP Replication Technology Evolution for ATLAS Data Workshop

18. OGG Reports • Oracle GoldenGate Process Failures • GGSCI> info all • GGSCI> info <process_name>, detail • GGSCI> view report <process_name> • Oracle GoldenGate Trail Files Problems • Trail files that don’t roll over: info exttrail * • Trail files purging issues: PURGEOLDEXTRACTS Replication Technology Evolution for ATLAS Data Workshop

19. OGG Reports • Oracle GoldenGate Error Log Analysis : ggserr.log • GGSCI>view ggsevt • Configuration issues • Incorrect sofware version installed for OGG • Database configuration issues on the source and/or target with OGG • OGG parameter file configuration issues • Operating system configuration issues • Network configuration issues Replication Technology Evolution for ATLAS Data Workshop

20. Oracle Database issues with GoldenGate • Extract errors = logminer problems • Replicat issues = streams apply problems • Data-synchronization issues • Missing columnand rows errors • Procedures the same like for Streams! Replication Technology Evolution for ATLAS Data Workshop

21. LogDump Replication Technology Evolution for ATLAS Data Workshop

22. LogDump • ./logdump • Open /trail_file_full_path • count • Standard utility that comes with Oracle GoldenGate • Enables to the user to view and scan for transactions and records • Obtains transaction statistics and save data contained within OGG Trails • Identify missing transactions • Troubleshoot replication issues Replication Technology Evolution for ATLAS Data Workshop

23. THANK YOU! lorena.lobato@cern.ch Replication Technology Evolution for ATLAS Data Workshop