• admin@thetechmaster.in
  • |
  • +919676516545

admin@thetechmaster.in

+919676516545

Oracle Goldengate - Kumar

Faculity Name : Kumar

Experience : 7 Years

Course Duration : 22 days

Price : 16000 INR

Course Details

  • About Course
  • About Instructor
  • Course Content
  • Videos

Oracle Goldengate is the emerging and enhanced replication tool to connect multiple RDBMS. It is now very hot course in the market and knowledge on this is going to get better job and high paid packages.

Pre-requisite: Good knowledge on Oracle DBA

Training highlights:

Hands on vmware dump for practice

Handy materials and documents

In depth knowledge on replication

Kumar

Experience : 7 Years

Kumar is having 7 years experience and working as Sr Oracle DBA in an MNC with core expertise in performance tuning, Dataguard and Goldengate.

He is having 6 years of training experience and handles training for performance tuning, Oracle DBA, Dataguard, RAC and Goldengate courses.

Oracle Goldengate - Kumar Course Content

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

GOLDENGATE 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

For Quick Contact Please Call Us : +919676516545

Batch Timings

Course Features

  • Live Instructor Led Course
  • Real Time oriented training
  • Guidance on Resume preparation
  • Mock Interviews
  • Training on latest version
  • Guidance on certification
  • Coverage of extended topics
  • Lower price