Home > Oracle 12c GoldenGate Online Training

Oracle 12c GoldenGate Online Training

Cheyat Technologies is cutting-edge online training institute offering ORACLE12C GoldenGate Online Training to candidates. We have experienced pool of ORACLE 12C GoldenGate experts to offer world class online training to our candidates using their expertise. They have put lots of effort to design the course structure for ORACLE Goldengate Online Training. Along with Online Training , We undertake On Job Supports also.

Oracle 12c GoldenGate Online Training Demo Video

Oracle 12c GoldenGate Online Training Course content

SETTING UP SERVERS & USE CASES

  • Install Oracle Enterprise Linux servers
  • Install Oracle 12c database software
  • Setup Golden Gate OS dependencies
  • Clone Linux servers
  • Configure Oracle databases
  • Golden Gate use cases

INSTALL GOLDEN GATE 12C

  • Supported DB’s OS combinations
  • Software and OS requirements
  • Installation – OUI
  • Directories
  • Kick start
  • New in 12c GG

GOLDEN GATE 12C ARCHITECTURE

  • GG workflow
  • Related products
  • GG Components
  • Architecture basics
  • Processes
  • Parameters
  • Topologies

GOLDENGATE WIRE FRAME

  • CDC and Delivery
  • Role of Data pump in GG
  • Integrated extract
  • Data load
  • CKPT in GG

ORACLE TO ORACLE CONFIGURATION BASICS

  • Steps to configure
  • Preparing environment – Character set
  • Configure user – Oracle Database
  • Network diagnostics
  • Preparing environment – Supplemental logging
  • Configuring Manager
  • Defgen

EXTRACT DATA

  • Change capture
  • Data pump options
  • Process groups
  • Configure Wallet
  • Integrated Capture
  • Extract traill
  • Start Extract
  • ASM in CDC

REPLICATE DATA

  • Change delivery basics
  • CDD activities Treat Collisions
  • Integrated Apply
  • Monitoring
  • Reports & Diagnostics

TRAILING

  • Extract Trails and Files
  • Formats
  • Substitutes
  • Log Dump
  • Logging trails
  • Reverse utility

BEGIN YOUR REPLICATION

  • Initial load
  • Kick start load
  • Pre-checks
  • Methods
  • File based loading
  • Direct load

DATA AND CONFIGURATIONS

  • GLOBAL & Manager Parameters
  • Extract & Replicat Parameters
  • Data selection: WHERE, FILTER
  • Data Mapping: Columns
  • RANGE
  • SQLEXEC functionalities
  • Functions specific to Golden Gate

OTHER CONSIDERATIONS

  • Macros & Tokens
  • User exits & Sequences
  • BatchSQL in GG
  • Data compression in GG
  • Data encryption & Events
  • GOLDENGATE – BIDIRECTIONAL
  • Pictorial view
  • Configurations
  • Data looping’s
  • Resolving conflicts
  • Effect of Oracle Sequences
Shop No 1, Kasturi Apartments,
Sindhubhavan Road, Brundavan Colony, Vijayawada - 520010
+91-91009-98433/34
+1(224) 676-9882
24 x 7 Call Support
trainings@cheyat.com
Email support
TOP