Slide 1

Slide 2

GoldenGate Monitoring and Troubleshooting Lorena Lobato Pardavila - CERN Replication Technology Evolution for ATLAS Data Workshop

Slide 3

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

Slide 4

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

Slide 5

Oracle GG Director: Overview 5Replication 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 OGG DIRECTOR DATABASE GGSCI Clients Monitor Agent OGG Instances OGG Director Web GGSCI OGG Director Client OGG Director Administrator OGG Director Server Application OGG Director Server Domain

Slide 6

System Requirements 6Replication Technology Evolution for ATLAS Data Workshop Oracle GoldenGate Director Server o 1 GB of RAM up to 1.5 GB (recommended) of free disk space. o Dedicated http port (default port is 7001) o DYNAMICPORTLIST in each Manager process o 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 o Supports Microsoft Internet Explorer v6.0 or later and Mozilla Firefox v2.0 or later o No software is installed on the client system for the OGG Web Oracle Director Desktop Client o Same version as that Oracle GoldenGate Director Server o Install Java Runtime Environment (JRE) on each cliente host

Slide 7

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

Slide 8

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

Slide 9

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

Slide 10

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

Slide 11

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

Slide 12

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

Slide 13

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

Slide 14

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

Slide 15

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

Slide 16

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

Slide 17

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

Slide 18

OGG Reports 18Replication Technology Evolution for ATLAS Data Workshop Oracle GoldenGate Process Failures oGGSCI> info all oGGSCI> info, detail oGGSCI> view report Oracle GoldenGate Trail Files Problems o Trail files that dont roll over: info exttrail * o Trail files purging issues: PURGEOLDEXTRACTS

Slide 19

OGG Reports 19Replication Technology Evolution for ATLAS Data Workshop Oracle GoldenGate Error Log Analysis : ggserr.log oGGSCI> 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

Slide 20

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

Slide 21

LogDump 21Replication Technology Evolution for ATLAS Data Workshop GroupIDTokens Trail Info Signature, Compatibility, Character Set, Creation Time, URI, URI History, File Name, Multi- part, Trail Sequence Number, File Size, First CSN, Last CSN, First IO Time, Last IO Time, Log BSN Machine InfoOperating 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 InfoRecovery Mode

Slide 22

LogDump 22Replication Technology Evolution for ATLAS Data Workshop 1../logdump 2.Open /trail_file_full_path 3.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

Slide 23

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

Slide 24