How many ways to monitor oracle golden gate wide format

18 %
82 %
Information about How many ways to monitor oracle golden gate wide format
Technology

Published on October 2, 2014

Author: BobbyCurtisMBA

Source: slideshare.net

Description

Oracle Open World 2014 GoldenGate Presentation.

1. How many ways to monitor Oracle GoldenGate? Session: UGF9217 Oracle Open World 2014 User Group Sunday

2. IOUG SIG Meetings @ Oracle Open Sunday, September 28 Cloud Computing SIG: 1:30 p.m. - 2:30 p.m. Monday, September 29 Exadata SIG: 2:00 p.m. - 3:00 p.m. BIWA SIG: 5:00 p.m. – 6:00 p.m. Tuesday, September 30 Internet of Things SIG: 11:00 a.m. - 12:00 p.m. Storage SIG: 4:00 p.m. - 5:00 p.m. SPARC/Solaris SIG: 5:00 p.m. - 6:00 p.m. Note: Wednesday, October 1 Oracle Enterprise Manager SIG: 8:00 a.m. - 9:00 a.m. Big Data SIG: 10:30 a.m. - 11:30 a.m. Oracle 12c SIG: 2:00 p.m. – 3:00 p.m. Oracle Spatial and Graph SIG: 4:00 p.m. (*OTN lounge) All Meeting located in Moscone South – Room 208

3. Accenture Enkitec Group Enkitec joined Accenture’s Infrastructure Services as Accenture Enkitec Group (May 2014)  17,000 Infrastructure Services professionals  52,000 Oracle professionals Focus on Oracle Engineered Systems Solutions  Database Migrations & Transformations  Database-as-a-Service  Oracle Applications on Engineered Systems  Cloud-based solutions leveraging Engineered Systems

4. Speaker Douglasville, Georgia Senior Technical Consultant IOUG, RMOUG, GAOUG, RACSIG @dbasolved http://dbasolved.com bcurtis@enkitec.com curtisbl@gmail.com

5. Session Agenda 1. What is Oracle GoldenGate? 2. Use Cases/Topologies 3. Monitoring  GGSCI  Command Line  SQL  Management Pack

6. What is Oracle GoldenGate?

7. Oracle GoldenGate • Comprehensive software for real-time data integration in heterogeneous environments • Benefits • High Availability Solutions • Real-Time Data Integration • Transactional Change Data Capture • Data Replication • Transformation of Data • Verification of Data • Primary Replication Tool in Oracle Database 12c (12.1.0.1/12.1.0.2) • Oracle Upgrade Guide, Sections 8.1.6 & 8.1.7

8. Use Cases/Topologies

9. Unidirectional Query Offloading Zero-Downtime Migration Data Integration Cloud or On-Premise Bi-Directional Active-Active for Multi-Master/HA Cloud or On-Premises Data Distribution via Messaging Cloud Apps Integration Big Data Delivery Real/Time and Batch Delivery Structured Data to Data Reservoir

10. Monitoring

11. Monitoring • Different Approaches to Monitoring • Manual • Scripts Based • SQL Based • Oracle Management Pack For Oracle GoldenGate • Oracle GoldenGate Monitor (not discussed) • Oracle GoldenGate Director • Oracle Enteprise Manager 12c

12. Manual Monitoring • Simplest Approach • Monitoring parameters in parameter files • Uses GoldenGate Service Command Interface (GGSCI) • Error Reporting -> ggserr.log • SQL Errors -> Discard File (*.dsc)

13. Manual Monitoring : GGSCI Commands

14. Manual Monitoring : Parameters

15. Monitoring: Scripts • Wrappers for manual commands • Any language • Shell • Perl • Etc… • Write once, Run multiple times • Repeatable process -> no memorization • Portable between environments

16. Monitoring: Scripts Example: Info_all.sh #!/bin/sh #info_all.sh export GGS_HOME=/opt/oracle/product/ggate $GGS_HOME/ggsci <<EOF info all exit EOF

17. Monitoring: Scripts Example: gg_mem_mon.sh PROCESSES="mgr ggcmd extract replicat" for GGPROCESS in $PROCESSES do FLAG=`ps -ef | grep $GGPROCESS` if [ $_ ] then "No GoldenGate Process Found" else ps -C $GGPROCESS -O rss | awk '{print $2/1024, "MB", $12}' | sort -k 2 fi done exit 0

18. Monitoring: SQL • Golden Gate specific tables • 11.2.0.3 (few) • 11.2.0.4 (little more) • 12.1.0.1 (moving forward) • 50 Objects (to date) • Integrated Capture/Apply • 11.2.0.3 (Capture) • 11.2.0.4 (Capture/Apply) • 12.1.0.1 • Non-PDB (classic/integrated) • PDB (integrated only) • Increase in views (AQ_*)

19. Monitoring: SQL & SQL Developer • Hybrid (Scripts/SQL) • Ability to monitor from SQL*Plus or SQL Developer • Can only see what is going on currently • Moving parts • Script to write text file • Need to schedule run (crontab/dbms_scheduler) • Usage of External Tables

20. Monitoring: SQL & SQL Developer Example: gg_mon_sqldev.pl . [Code Removed] open (GGPROC, ">$outfile") or die "Unable to open file"; foreach (@buf){ if(/MANAGER/||/JAGENT/||/EXTRACT/||/REPLICAT/) { no warnings 'uninitialized'; chomp; my ($program, $status, $group, $lagatchkpt, $timesincechkpt) = split(" "); if ($group eq "") { $group = $program; } if ($lagatchkpt eq "" || $timesincechkpt eq "") { $lagatchkpt = "00:00:00"; $timesincechkpt = "00:00:00"; } print GGPROC "$program|$status|$group|$lagatchkpt|$timesincechkptn"; } } close (GGPROC);

21. Monitoring: Director • Multi-tier, client-server application • Can manage GoldenGate from a remote client • Many moving parts • See Architecture (Next Slide) • Client – GUI interface for users • Mid-Tier Server • Weblogic, Application & Monitor agent • Central Repository – i.e. Database

22. Monitoring: Director

23. Monitoring: Enterprise Manager 12c • Quickly becoming monitoring tool of choice • GoldenGate monitoring available in OEM 12c (12.1.0.1) • Support via a plug-in • JAgent is used to interact with OEM Agent/Plug-In • Plug-in (12.1.0.2), separate JAgent install (12.1.3) • GLOBALS (ENABLEMONITORING)

24. Monitoring: Enterprise Manager 12c • GoldenGate Plug-in Installed • Oracle Management Server • Oracle Agent • Current Release (12.1.0.2) • Ensure update of plug-in • Setup -> Extensibility -> Self Update

25. Monitoring: Enterprise Manager 12c GoldenGate Access • Deployed on OMS/Agent • JAgent started • Targets -> GoldenGate

26. Monitoring: Enterprise Manager 12c

27. Monitoring: Enterprise Manager 12c Metric Extensions • Hybrid Approach • Metric Extensions • Metric Extensions • Uses Scripts/More Texted based • Can be deployed to any agent • Does not have up/down issues with Jagent - Agent interaction • Not restricted to a minimum version of GoldenGate

28. Monitoring: Enterprise Manager 12c M#!/usre/bitn/rpeircl - wExtensions # # use strict; use warnings; #Static Variables my $gghome = "/oracle/app/product/12.1.2/ggate"; #Program my @buf = `$gghome/ggsci << EOF info all EOF`; foreach (@buf) { if(/EXTRACT/||/REPLICAT/) { s/s+/|/g; print $_."n"; } }

29. Monitoring: Enterprise Manager 12c Metric Extensions • Metric Extension • Enterprise -> Monitoring -> Metric Extensions • Metric seen under All Metrics for Hosts (*) • Packaged and deployed to multiple agents

30. Monitoring: Enterprise Manager 12c Metric Extensions • Metric Extension -> All Metrics

31. Bugs

32. Bugs No Monitoring Solution is 100%! Choose wisely for your data!

33. Contact Info @dbasolved http://dbasolved.com bcurtis@enkitec.com curtisbl@gmail.com

#static presentations

Add a comment

Related presentations

Presentación que realice en el Evento Nacional de Gobierno Abierto, realizado los ...

In this presentation we will describe our experience developing with a highly dyna...

Presentation to the LITA Forum 7th November 2014 Albuquerque, NM

Un recorrido por los cambios que nos generará el wearabletech en el futuro

Um paralelo entre as novidades & mercado em Wearable Computing e Tecnologias Assis...

Microsoft finally joins the smartwatch and fitness tracker game by introducing the...

Related pages

Replicating Transactions Between Microsoft SQL Server and ...

Replicating Transactions Between Microsoft SQL Server and ... file /u01/app/oracle/gg/dirdat/ex is using format ... are many different ...
Read more

Oracle GoldenGate Hands-on Tutorial - Ahmed Baraka DBA

Golden Gate Components ... Oracle GoldenGate Hands-on Tutorial Oracle Database Issues with ... o Oracle GoldenGate Monitor V11.1.1.1.0 ...
Read more

7 Integrating with Oracle Coherence GoldenGate HotCache

This chapter describes how to use Oracle Coherence ... GoldenGate monitors the ... Example properties are located in $GOLDEN_GATE_HOME/ggjava ...
Read more

Best Practices for Conflict Detection and Resolution in ...

... one-to-many, many-to-one, and ... in Active-Active Replication Environments Using Oracle ... in a cost-effective way. Oracle GoldenGate is uniquely ...
Read more

4 Getting Started with the Oracle GoldenGate Process ...

4 Getting Started with the Oracle GoldenGate Process Interfaces. ... and monitor Oracle ... 4.2 Controlling Oracle GoldenGate Processes. The standard way ...
Read more

Ask Tom "CPU utilization" - Oracle

How can I reduce CPU utilization of Oracle ... Use the v$ views to monitor how many ... but there should be a way to test Oracle database and ...
Read more

Oracle® Database Express Edition

... but you probably do not want to because many documents show ... Oracle Database XE comes ... Creating an application is an easy way to view and ...
Read more

Oracle eBooks - Free Download IT eBooks

... and the many redesigned wizards give ... needed for you to effectively manage and monitor the Oracle SOA Suite ... wide identity management solution ...
Read more

SQL Server Monitoring Tool - SQL Monitor | Redgate

SQL Monitor is a SQL server monitoring tool that transforms the way you look ... SQL Monitor cuts your ... data in an easy to use format. Aaron ...
Read more

Oracle RAC - Wikipedia, the free encyclopedia

[citation needed] This makes Oracle RAC horizontally scalable with many nodes. ... Oracle RAC Documentation; Oracle Real Application Clusters ...
Read more