GoldenGate Online Training

Oracle GoldenGate Online Training

Oracle GoldenGate Online Training
Oracle GoldenGate Online Training

GoldenGate Online Training Course Content :

Introduction to Oracle Golden Gate

  • Oracle Golden Gate Replication Solutions for Live Reporting, Real Time Data Warehousing, Live Standby Database, and High Availability.
  • Supported databases and platforms
  • Advantages of Oracle Golden Gate

Installing Oracle Golden Gate

  • Downloading the software from Oracle website.
  • Installing Oracle Golden Gate
  • Explaining Subdirectories
  • Preparing Oracle 11g database for data replication

Oracle Golden Gate Technology and Architecture

  • Understanding Golden Gate Components: Processes and Files
  • Process Data Flow
  • GoldenGate Architecture
  • Design Considerations

Configuring & Preparing the Environment

  • Configuring the Manager process
  • Describing the Manager Parameters
  • Starting the Manager process
  • Configuring GLOBALS file

Data Definitions File

  • Overview of Data Definitions File
  • When to use Data Definitions Files
  • Types of Data Definitions File
  • Configuring Data Definitions File

Configuring Change Capture Delivery – With and Without Data Pump

  • Preparing a source database for transaction capture
  • Describing the high-level configuration steps
  • Explaining change capture and delivery with a data pump
  • Explaining change capture and delivery without a data pump
  • Comparing batch and online operation
  • Explaining Oracle Golden Gate Checkpoints
  • Describing the Extract process
  • Configuring and starting an Extract process
  • Adding local and remote trails
  • Configuring and starting a data pump
  • Explaining the Replicate process
  • Configuring a Replicate process
  • Starting a Replicate process
  • Describing GGSCI commands
  • Describing Extract trails and files

Configuring Change Capture Delivery – DDL Replication and Initial Data Load

  • Overview of DDL synchronization
  • Preparing a source database for transaction capture
  • Describing the high-level configuration steps
  • Configuring Extract and Replicat for DDL replication
  • Configuring Initial Data Load using Oracle GoldenGate Extract and Replicat

Oracle Golden Gate Commands

  • Running Golden Gate commands from the GGSCI prompt
  • Running Golden Gate commands from the obey files
  • Running Golden Gate commands from the OS shell
  • dentifying the types of GGSCI commands available

Managing Oracle Golden Gate

  • Managing trail files
  • Automating process startup
  • Using reporting and statistics

GoldenGate Security Features

  • Using message, trail and password encryption
  • Controlling command permissions – CMDSEC file

Advanced Configuration: Mapping and manipulating data

  • Overview of data mapping and manipulation
  • Deciding where data mapping and conversion will take place
  • Data Selection and Filtering
  • Data Transformation
  • Using built-in functions
  • Using SQLEXEC to interact directly with a database

Troubleshooting Oracle Golden Gate

  • Troubleshooting process startup failures
  • Troubleshooting slow startup
  • Troubleshooting Extract problems
  • Troubleshooting missed transactions
  • Using the discard file
  • Using SHOWSYNTAX to view Replicat SQL statements
  • Using the Logdump utility

GoldenGate Performance Tuning

  • Using BATCHSQL to speed delivery
  • Using RANGE Function
  • Using parallel Replicat groups on a target system

Drop your query

What my Client's Say?


  • Prabhu is an excellent instructor, very patient and thorough. I have tried another training class and EXPLORE IT far exceeds other trainers and their methods ~ Hassan Malik

  • An extremely helpful and informative course. Training materials were well organized and provided good case studies. Instructor was extremely professional and pleasant to learn from.~ Bhavani Sudarshnam

  • The training was clear and detailed. I like Parker's style of teaching as the recurrent training is a thorough review of the HR. Every opportunity for the student to ask questions was provided. ~ Yiting Chen

  • Jane Anderson conducted the class in a very professional manner. Examples were very relevant and I feel that I gained a lot from the updated materials this year.~ Somesh Taneja

  • Prem was a great instructor. Thanks Prem for making the training easy to understand. A lot of information was covered. He made the approach easy to follow.~ Komali Sambakula

  • She wants to make sure that her students walk away from her course with a good working knowledge. She is an excellent trainer and cares that all of her students learn the material.~ Kiran Jain

  • Krishna is very thorough and professional. He made the code very understandable. I was very impressed with his teaching methods and presentation of the regulations. EXPLORE IT is the best! ~ Rajesh Isukapalli

  • Mr. Chris Brown was very affirmative with the course, on time and fluent. This is my second recourse with him. I hope to take his course as long as I am shipping at my current job. ~ Awais Rahim