Oracle

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 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