Oracle ClassesOracle-logo

Oracle GoldenGate Training: GoldenGate 12c Fundamentals

Oracle GoldenGate Training –

Oracle GoldenGate 12c Fundamentals

The Oracle GoldenGate 12c Fundamentals Course covers the infrastructure and architecture of Oracle’s GoldenGate software. We look at the source and target databases as related to replication and migration. In the class students will obtain the skill set required to design, deploy, install, and configure Oracle GoldenGate 12.2 software. Students will learn “best practices” for managing GoldenGate in multiple scenarios. The course focuses on real-world deployment issues including data security, performance tuning, debugging, trouble-shooting, and removal of GoldenGate software from the environment.

This class can be customized for GoldenGate 12c between Oracle databases (single or multiple versions) or between Microsoft SQL Server and an Oracle database in version 10g, 11g or 12c.

ORACLE GOLDENGATE 12C COURSE TOPICS 

  • Implementation requirements for homogeneous and heterogeneous replication and migration
  • Deploy and configure GoldenGate software connecting two database instances
  • Run and manage Oracle GoldenGate software live replication
  • Learn basic troubleshooting skills for the GoldenGate environment
  • Brief overview of database replication and migration technologies
  • Review of single, bi-directional, and multi-directional use cases
  • Detailed examination of GoldenGate’s architecture, tools and processes including trail files
  • Design and architecture considerations for basic replication, high availability and disaster recovery scenarios
  • Change Management and DDL Replication
  • Security features
  • GoldenGate licensing overview
Oracle GoldneGate Training: GoldenGate 12c Advanced Course

Oracle GoldenGate Training –

Oracle GoldenGate 12c Advanced Course

The Oracle GoldenGate 12c Advanced Course builds on the foundation laid down in the GoldenGate 12c Fundamentals Course continuing to teach “best practices” while focusing on advanced skills for troubleshooting, performance tuning, and replication error handling. Students will face real-world issues, troubleshoot them,  and resolve them in hands-on labs so that they have the skills necessary to do so in their own production environment.

This class can be customized, at the customer’s request, for Oracle GoldenGate 12.2 data integration between Oracle databases (single or multiple versions) or between Microsoft SQL Server and an Oracle database in version 10g, 11g or 12c.  Students will learn the tools and techniques they need to master so that they can provide the security, stability, and scalability your replication, upgrade, and migration projects require.

  • Triage and Root Cause Analysis Overview
  • Investigation and Informational Analysis
  • Exception Handler Creation
  • Working Effectively with Support on Replication Issues
  • End-to-end Performance Tuning

COURSE TOPICS

  • Build on existing database and GoldenGate competencies
  • Reinforce  a working knowledge of implementation requirements for homogeneous and heterogeneous replication and migration
  • Reinforce a working knowledge of implementation and requirements for single, bi-directional, and multi-directional replication
  • Learn how to identify and resolve replication issues in a wide variety of environments
  • Brief overview of the “Fundamentals for Administrators” class’ materials
  • Deep-dive into performance tuning Extract, Pump, and Replicate processes
  • Deep-dive into troubleshooting Extract, Pump, and Replicate processes
  • Troubleshooting synchronization and missing transaction issues
  • Advanced review of GoldenGate commands
  • Advanced Security  for Data Replication
Oracle Database 12c Training: New Features for Administrators

Oracle Database 12c Training –

Oracle Database 12c New Features for Administrators

Our Oracle Database 12c training was specifically designed for organizations that will be upgrading or migrating to 12c.  Our training will help IT professionals effectively plan and implement the new Oracle Database 12c  in their environment.  We will examine issues in preparing to move to 12c as well as troubleshooting issues that may occur during the move in our state-of-the-art training lab through interactive, hands-on exercises.

Oracle Database 12c is forcing organizations to reevaluate many aspects of how to minimize risk and be successful in the upgrade, migration or implementation of this new architecture. For example, if the organization plans to use the new multi-tenant architecture then their existing servers and network infrastructure may need to be upgraded as well as Cron jobs may require a rewrite.  We’ll examine  the  “best practice” for enhanced performance and security.  We will review these and many other architecture planning and implementation steps during this class.

This course was written and developed by one of Performance Tuning Corporation’s Oracle ACE Director who was one of Oracle’s 12c Beta testers.  The focus of this course is on the changes that are mandatory, rather than the many optional changes in the database.  Real world training focused on the core skills required to move your organization forward and to recruit and retain a professional staff that will keep your business “in business.”

TOPICS OVERVIEW

  • Brief overview of instance and database basics in database 11gR2 and before
  • Container Database architecture
  • Root container CDB$ROOT
  • Seed container PDB$SEED
  • Pluggable Database architecture (PDB)
  • The 12c Data Dictionary
  • User creation, application access, and new roles and privileges
  • Tablespace creation
  • Unified Audit Policies
  • Database Scheduler (DBMS_SCHEDULER)