Golden Gate Monitoring and Troubleshooting Lorena Lobato Pardavila

Golden. Gate Monitoring and Troubleshooting Lorena Lobato Pardavila - CERN Replication Technology Evolution for ATLAS Data Workshop

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

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

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

System Requirements q Oracle Golden. Gate 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 Web. Logic Server 11 g Standard Edition o o Ø q Oracle Golden. Gate Director Web o o q 10. 3. 1, 10. 3. 2, 10. 3. 3, 10. 3. 4, or 10. 3. 5 or 12 c (12. 1. 1) Supports Microsoft Internet Explorer v 6. 0 or later and Mozilla Firefox v 2. 0 or later No software is installed on the client system for the OGG Web Oracle Director Desktop Client o o Same version as that Oracle Golden. Gate Director Server Install Java Runtime Environment (JRE) on each cliente host Replication Technology Evolution for ATLAS Data Workshop 6

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

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

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

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

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

OGG Enterprise Manager Plug-in (Live) q For installing the plug-in: o o q Enterprise Manager Cloud Control 12 c Bundle Patch 1 (12. 1. 0. 1) and later Oracle Golden. Gate 11 g Release 2 (11. 2. 1. 0. 1) and later Management features: o o Monitor Oracle Golden. Gate instances. Gather configuration data and track configuration changes for Oracle Golden. Gate instances. 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 Golden. Gate instance. Replication Technology Evolution for ATLAS Data Workshop 12

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

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

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

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

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

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

OGG Reports q Oracle Golden. Gate Error Log Analysis : ggserr. log o GGSCI> view ggsevt q 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 19

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

Log. Dump Group. ID Trail Info Tokens Signature, Compatibility, Character Set, Creation Time, URI History, File Name, Multipart, Trail Sequence Number, File Size, First CSN, Last CSN, First IO Time, Last IO Time, Log BSN Machine Info Operating System Name, Node Name, Release, Version, Hardware Database Info Vendor, Name, Character Set, Major Version, Minor Version, Version String, Client Character Set, Client Version String, Client NCharacter Set, Db Locale, Db NCharacter Set, Db Object Metadata, Db Time Zone Producer Info Name, Data Source, Major Version, Minor Version, Maintenance Level, Bug Fix Level, Build Number, Version String Continuity Info Recovery Mode Replication Technology Evolution for ATLAS Data Workshop 21

Log. Dump 1. . /logdump 2. Open /trail_file_full_path 3. count • Standard utility that comes with Oracle Golden. Gate • 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 22

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